PREVIEW / etf_1hour / 2021-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-10.parquet
  size:    434 KB
  rows:    15,166

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-05-10 04:00:00	SPY	ETF	422.26	422.5	422.07	422.08	16579.0
2021-05-10 05:00:00	SPY	ETF	422.09	422.4	422.0	422.16	46310.0
2021-05-10 06:00:00	SPY	ETF	422.16	422.52	422.13	422.44	18950.0
2021-05-10 07:00:00	SPY	ETF	422.48	422.66	422.31	422.4	119574.0
2021-05-10 08:00:00	SPY	ETF	422.3696	423.0	422.17	422.6	128875.0
2021-05-10 09:00:00	SPY	ETF	422.61	422.74	421.66	422.11	5480034.0
2021-05-10 10:00:00	SPY	ETF	422.12	422.43	421.03	421.59	8474063.0
2021-05-10 11:00:00	SPY	ETF	421.5899	422.48	421.34	422.365	5922258.0
2021-05-10 12:00:00	SPY	ETF	422.37	422.65	421.77	421.8011	3620527.0
2021-05-10 13:00:00	SPY	ETF	421.81	422.01	421.37	421.44	3916842.0
2021-05-10 14:00:00	SPY	ETF	421.44	421.52	418.74	419.355	13991369.0
2021-05-10 15:00:00	SPY	ETF	419.355	419.8	417.81	417.99	19657936.0
2021-05-10 16:00:00	SPY	ETF	417.99	418.2	416.86	417.18	3713819.0
2021-05-10 17:00:00	SPY	ETF	417.3	417.44	417.17	417.32	121326.0
2021-05-10 18:00:00	SPY	ETF	417.33	418.08	417.33	418.0	187244.0
2021-05-10 19:00:00	SPY	ETF	418.02	418.14	417.7	417.96	60077.0
2021-05-10 04:00:00	QQQ	ETF	333.25	333.72	332.93	333.03	24647.0
2021-05-10 05:00:00	QQQ	ETF	333.03	333.61	332.96	333.38	35548.0
2021-05-10 06:00:00	QQQ	ETF	333.36	333.4	332.82	333.35	37141.0
2021-05-10 07:00:00	QQQ	ETF	333.31	333.5	332.62	332.74	162319.0
2021-05-10 08:00:00	QQQ	ETF	332.71	334.65	332.59	333.12	263583.0
2021-05-10 09:00:00	QQQ	ETF	333.14	333.25	329.44	329.97	7116835.0
2021-05-10 10:00:00	QQQ	ETF	329.99	330.45	328.12	328.73	7811820.0
2021-05-10 11:00:00	QQQ	ETF	328.73	329.66	328.08	329.59	5030539.0
2021-05-10 12:00:00	QQQ	ETF	329.6	330.19	329.03	329.1	2824599.0
2021-05-10 13:00:00	QQQ	ETF	329.1113	329.48	328.23	328.48	2831053.0
2021-05-10 14:00:00	QQQ	ETF	328.48	328.57	325.85	326.38	9200472.0
2021-05-10 15:00:00	QQQ	ETF	326.37	327.0704	325.55	325.61	10308150.0
2021-05-10 16:00:00	QQQ	ETF	325.62	328.6309	324.44	324.58	1967181.0
2021-05-10 17:00:00	QQQ	ETF	324.56	324.75	324.43	324.74	59764.0
2021-05-10 18:00:00	QQQ	ETF	324.72	325.18	324.5	325.15	211645.0
2021-05-10 19:00:00	QQQ	ETF	325.14	325.2	324.88	325.1	123537.0
2021-05-10 04:00:00	IWM	ETF	225.17	225.17	224.26	224.52	14544.0
2021-05-10 05:00:00	IWM	ETF	224.54	224.75	224.31	224.54	13235.0
2021-05-10 06:00:00	IWM	ETF	224.54	224.68	224.33	224.56	14501.0
2021-05-10 07:00:00	IWM	ETF	224.59	224.6	223.83	224.17	138790.0
2021-05-10 08:00:00	IWM	ETF	224.14	225.99	223.87	224.91	128968.0
2021-05-10 09:00:00	IWM	ETF	224.96	225.67	223.17	223.86	2893575.0
2021-05-10 10:00:00	IWM	ETF	223.88	224.705	222.84	223.42	3224168.0
2021-05-10 11:00:00	IWM	ETF	223.4	224.22	223.1	224.1	1800723.0
2021-05-10 12:00:00	IWM	ETF	224.11	224.34	223.08	223.21	1374081.0
2021-05-10 13:00:00	IWM	ETF	223.22	223.7	222.78	222.98	1049333.0
2021-05-10 14:00:00	IWM	ETF	222.98	223.02	220.46	220.94	3826100.0
2021-05-10 15:00:00	IWM	ETF	220.93	221.195	219.59	219.63	6211728.0
2021-05-10 16:00:00	IWM	ETF	219.66	221.26	218.8	218.87	1323324.0
2021-05-10 17:00:00	IWM	ETF	218.94	219.3115	218.9	219.01	17738.0
2021-05-10 18:00:00	IWM	ETF	219.06	219.65	219.01	219.59	35205.0
2021-05-10 19:00:00	IWM	ETF	219.58	219.89	219.28	219.34	270684.0
2021-05-10 04:00:00	DIA	ETF	348.71	348.81	348.57	348.57	9099.0
2021-05-10 05:00:00	DIA	ETF	348.66	348.66	348.66	348.66	400.0

> showing 50 of 15,166 rows — these rows as CSV

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