PREVIEW / etf_1hour / 2021-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-28.parquet
  size:    422 KB
  rows:    14,726

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
2021-01-28 04:00:00	SPY	ETF	370.6	371.88	370.32	371.58	127563.0
2021-01-28 05:00:00	SPY	ETF	371.35	373.11	371.33	372.56	126067.0
2021-01-28 06:00:00	SPY	ETF	372.46	374.0	372.24	373.28	281071.0
2021-01-28 07:00:00	SPY	ETF	373.3	374.5	373.16	373.75	478818.0
2021-01-28 08:00:00	SPY	ETF	373.66	376.32	370.88	376.04	1483853.0
2021-01-28 09:00:00	SPY	ETF	376.1	378.87	375.16	377.58	10025915.0
2021-01-28 10:00:00	SPY	ETF	377.59	380.18	377.27	379.78	10732969.0
2021-01-28 11:00:00	SPY	ETF	379.84	380.96	379.54	380.6	7196037.0
2021-01-28 12:00:00	SPY	ETF	380.59	381.8	380.59	381.48	5199341.0
2021-01-28 13:00:00	SPY	ETF	381.475	381.93	380.87	381.63	4382357.0
2021-01-28 14:00:00	SPY	ETF	381.67	381.78	379.9481	380.65	6194092.0
2021-01-28 15:00:00	SPY	ETF	380.63	380.63	377.26	377.6	13960955.0
2021-01-28 16:00:00	SPY	ETF	377.61	378.35	376.1	376.41	9903694.0
2021-01-28 17:00:00	SPY	ETF	376.5	377.63	376.25	376.6	261759.0
2021-01-28 18:00:00	SPY	ETF	376.52	377.63	375.81	376.0	213582.0
2021-01-28 19:00:00	SPY	ETF	376.23	376.77	375.85	375.99	185848.0
2021-01-28 04:00:00	QQQ	ETF	315.34	316.14	314.6	315.97	83495.0
2021-01-28 05:00:00	QQQ	ETF	315.97	316.75	315.38	315.87	114577.0
2021-01-28 06:00:00	QQQ	ETF	315.88	317.7	315.48	316.95	77185.0
2021-01-28 07:00:00	QQQ	ETF	316.93	318.5	316.8	317.4	510574.0
2021-01-28 08:00:00	QQQ	ETF	317.6396	319.89	315.25	319.74	813131.0
2021-01-28 09:00:00	QQQ	ETF	319.76	322.89	319.72	321.44	5178159.0
2021-01-28 10:00:00	QQQ	ETF	321.45	323.82	321.27	323.579	5325496.0
2021-01-28 11:00:00	QQQ	ETF	323.59	324.58	323.04	324.35	3587833.0
2021-01-28 12:00:00	QQQ	ETF	324.38	326.21	324.36	325.79	3817223.0
2021-01-28 13:00:00	QQQ	ETF	325.79	326.42	325.35	326.02	2399800.0
2021-01-28 14:00:00	QQQ	ETF	326.01	326.18	324.04	324.89	2840188.0
2021-01-28 15:00:00	QQQ	ETF	324.86	324.86	321.09	321.37	6813515.0
2021-01-28 16:00:00	QQQ	ETF	321.4	322.71	319.9	320.65	1268217.0
2021-01-28 17:00:00	QQQ	ETF	320.6	321.32	320.58	321.01	314619.0
2021-01-28 18:00:00	QQQ	ETF	320.82	321.4	320.06	320.06	380098.0
2021-01-28 19:00:00	QQQ	ETF	320.34	320.83	319.78	319.98	123413.0
2021-01-28 04:00:00	IWM	ETF	207.75	208.3	207.3	208.02	37081.0
2021-01-28 05:00:00	IWM	ETF	208.08	209.8	208.0	209.8	31321.0
2021-01-28 06:00:00	IWM	ETF	209.58	210.62	209.4	210.25	47280.0
2021-01-28 07:00:00	IWM	ETF	210.0	210.67	209.66	210.08	141916.0
2021-01-28 08:00:00	IWM	ETF	210.0804	212.39	207.5	212.31	347941.0
2021-01-28 09:00:00	IWM	ETF	212.36	212.65	210.27	212.0	3187950.0
2021-01-28 10:00:00	IWM	ETF	212.01	212.37	209.9	210.36	4034388.0
2021-01-28 11:00:00	IWM	ETF	210.35	210.5	207.63	209.8219	5222361.0
2021-01-28 12:00:00	IWM	ETF	209.84	210.14	208.765	208.84	2477263.0
2021-01-28 13:00:00	IWM	ETF	208.84	210.27	207.9	210.27	2342544.0
2021-01-28 14:00:00	IWM	ETF	210.26	210.96	209.44	210.51	2006771.0
2021-01-28 15:00:00	IWM	ETF	210.5	210.68	208.63	208.6999	4185555.0
2021-01-28 16:00:00	IWM	ETF	208.71	209.56	207.9	207.9	1845873.0
2021-01-28 17:00:00	IWM	ETF	207.8	208.72	207.8	208.4	272877.0
2021-01-28 18:00:00	IWM	ETF	208.33	208.79	208.0	208.34	172487.0
2021-01-28 19:00:00	IWM	ETF	208.56	208.99	208.31	208.74	33032.0
2021-01-28 04:00:00	DIA	ETF	301.49	301.67	300.76	301.67	16100.0
2021-01-28 05:00:00	DIA	ETF	301.88	302.87	301.88	302.7	3900.0

> showing 50 of 14,726 rows — these rows as CSV

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