PREVIEW / etf_1hour / 2020-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-17.parquet
  size:    406 KB
  rows:    13,848

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2020-03-17 04:00:00	SPY	ETF	246.97	256.45	244.69	245.02	881653.0
2020-03-17 05:00:00	SPY	ETF	245.1	246.73	239.14	241.66	472495.0
2020-03-17 06:00:00	SPY	ETF	241.86	250.02	241.0	250.0	620255.0
2020-03-17 07:00:00	SPY	ETF	250.02	250.02	242.38	242.62	992084.0
2020-03-17 08:00:00	SPY	ETF	242.68	252.26	241.71	245.55	1901655.0
2020-03-17 09:00:00	SPY	ETF	245.64	247.45	237.67	238.16	31325403.0
2020-03-17 10:00:00	SPY	ETF	238.16	245.83	237.07	245.22	37778069.0
2020-03-17 11:00:00	SPY	ETF	245.18	251.6	244.41	251.03	31762679.0
2020-03-17 12:00:00	SPY	ETF	251.045	256.17	247.31	249.1	32832235.0
2020-03-17 13:00:00	SPY	ETF	249.12	250.5999	245.05	249.6201	24243573.0
2020-03-17 14:00:00	SPY	ETF	249.56	254.84	248.21	251.0075	26896645.0
2020-03-17 15:00:00	SPY	ETF	251.03	254.45	247.0	254.19	47562801.0
2020-03-17 16:00:00	SPY	ETF	254.34	254.75	249.03	249.03	16406731.0
2020-03-17 17:00:00	SPY	ETF	249.46	252.8	239.1037	248.62	4044596.0
2020-03-17 18:00:00	SPY	ETF	248.51	252.8	239.1237	246.87	1017324.0
2020-03-17 19:00:00	SPY	ETF	246.8	247.4	241.72	242.79	683096.0
2020-03-17 04:00:00	QQQ	ETF	178.06	180.89	174.78	175.14	94510.0
2020-03-17 05:00:00	QQQ	ETF	175.0	176.45	171.06	173.89	129778.0
2020-03-17 06:00:00	QQQ	ETF	173.32	178.1	173.32	178.04	164812.0
2020-03-17 07:00:00	QQQ	ETF	178.04	178.53	173.27	173.27	362767.0
2020-03-17 08:00:00	QQQ	ETF	173.56	178.07	172.81	175.35	505064.0
2020-03-17 09:00:00	QQQ	ETF	175.33	177.15	170.19	170.6	9775117.0
2020-03-17 10:00:00	QQQ	ETF	170.61	177.15	169.78	176.62	12452399.0
2020-03-17 11:00:00	QQQ	ETF	176.62	181.39	176.14	181.1	14339234.0
2020-03-17 12:00:00	QQQ	ETF	181.08	184.39	177.94	179.42	15454404.0
2020-03-17 13:00:00	QQQ	ETF	179.42	181.07	176.41	180.4	9905226.0
2020-03-17 14:00:00	QQQ	ETF	180.35	183.08	179.0	180.88	11563130.0
2020-03-17 15:00:00	QQQ	ETF	180.89	183.29	177.855	182.01	22363627.0
2020-03-17 16:00:00	QQQ	ETF	182.02	182.42	179.9	179.95	2596452.0
2020-03-17 17:00:00	QQQ	ETF	179.8699	180.5	178.99	179.36	121643.0
2020-03-17 18:00:00	QQQ	ETF	179.36	180.82	177.63	178.32	589499.0
2020-03-17 19:00:00	QQQ	ETF	178.17	180.82	175.0	175.62	773895.0
2020-03-17 04:00:00	IWM	ETF	109.83	111.02	105.99	105.99	22453.0
2020-03-17 05:00:00	IWM	ETF	105.98	106.0	102.94	104.0	21434.0
2020-03-17 06:00:00	IWM	ETF	103.84	107.02	103.51	105.71	52800.0
2020-03-17 07:00:00	IWM	ETF	105.82	105.87	104.15	104.15	179663.0
2020-03-17 08:00:00	IWM	ETF	104.6	107.51	103.72	104.76	225528.0
2020-03-17 09:00:00	IWM	ETF	104.76	106.73	100.61	101.255	5444392.0
2020-03-17 10:00:00	IWM	ETF	101.27	104.47	100.82	102.805	8825830.0
2020-03-17 11:00:00	IWM	ETF	102.82	107.99	102.5801	107.92	5431046.0
2020-03-17 12:00:00	IWM	ETF	107.97	110.71	105.64	106.2267	7073881.0
2020-03-17 13:00:00	IWM	ETF	106.24	106.95	104.2944	106.61	3657142.0
2020-03-17 14:00:00	IWM	ETF	106.61	109.33	106.14	107.72	5164529.0
2020-03-17 15:00:00	IWM	ETF	107.71	110.18	105.94	108.85	9446666.0
2020-03-17 16:00:00	IWM	ETF	108.87	109.8223	107.15	107.25	3895724.0
2020-03-17 17:00:00	IWM	ETF	107.4	107.89	107.0	107.67	24793.0
2020-03-17 18:00:00	IWM	ETF	107.21	107.56	105.5	105.86	117605.0
2020-03-17 19:00:00	IWM	ETF	108.37	108.37	104.59	104.83	633656.0
2020-03-17 04:00:00	DIA	ETF	214.5	214.77	207.01	207.01	14100.0
2020-03-17 05:00:00	DIA	ETF	206.74	208.2	202.33	204.17	6990.0

> showing 50 of 13,848 rows — these rows as CSV

> unlock the full archive -- $79 one-time