PREVIEW / etf_1hour / 2020-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-29.parquet
  size:    360 KB
  rows:    12,505

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-06-29 04:00:00	SPY	ETF	301.22	301.37	300.34	301.37	72347.0
2020-06-29 05:00:00	SPY	ETF	301.29	301.89	300.9	301.7	29865.0
2020-06-29 06:00:00	SPY	ETF	301.69	301.87	300.7	301.5	212308.0
2020-06-29 07:00:00	SPY	ETF	301.51	302.7	301.19	302.44	642614.0
2020-06-29 08:00:00	SPY	ETF	302.5	302.65	300.01	301.46	1224299.0
2020-06-29 09:00:00	SPY	ETF	301.5	301.7299	298.93	300.59	11391918.0
2020-06-29 10:00:00	SPY	ETF	300.575	303.43	300.57	302.58	12541956.0
2020-06-29 11:00:00	SPY	ETF	302.59	303.38	301.49	302.69	10625049.0
2020-06-29 12:00:00	SPY	ETF	302.69	303.81	302.69	303.35	5675014.0
2020-06-29 13:00:00	SPY	ETF	303.35	304.02	303.21	303.63	4537130.0
2020-06-29 14:00:00	SPY	ETF	303.635	303.83	302.7	302.93	6263320.0
2020-06-29 15:00:00	SPY	ETF	302.94	304.45	302.22	304.43	16894568.0
2020-06-29 16:00:00	SPY	ETF	304.42	305.17	304.3256	304.7	7303975.0
2020-06-29 17:00:00	SPY	ETF	304.87	304.87	304.46	304.7	257042.0
2020-06-29 18:00:00	SPY	ETF	304.65	305.98	304.53	305.66	229157.0
2020-06-29 19:00:00	SPY	ETF	305.67	305.99	305.35	305.47	132030.0
2020-06-29 04:00:00	QQQ	ETF	240.48	240.5	239.76	240.43	77269.0
2020-06-29 05:00:00	QQQ	ETF	240.42	240.6	240.05	240.5	150380.0
2020-06-29 06:00:00	QQQ	ETF	240.5	240.6	239.75	240.28	50466.0
2020-06-29 07:00:00	QQQ	ETF	240.33	241.18	239.9	241.01	135154.0
2020-06-29 08:00:00	QQQ	ETF	240.2699	241.08	239.38	240.22	269009.0
2020-06-29 09:00:00	QQQ	ETF	240.23	240.33	237.35	238.89	6151718.0
2020-06-29 10:00:00	QQQ	ETF	238.92	241.22	238.63	240.51	6504039.0
2020-06-29 11:00:00	QQQ	ETF	240.52	241.5614	239.8	241.3414	3763240.0
2020-06-29 12:00:00	QQQ	ETF	241.33	242.1801	241.33	241.97	2182683.0
2020-06-29 13:00:00	QQQ	ETF	241.99	242.46	241.58	242.14	1723560.0
2020-06-29 14:00:00	QQQ	ETF	242.15	242.29	241.22	241.38	2237906.0
2020-06-29 15:00:00	QQQ	ETF	241.4	242.81	240.81	242.77	5196634.0
2020-06-29 16:00:00	QQQ	ETF	242.81	243.86	242.6914	243.63	1025022.0
2020-06-29 17:00:00	QQQ	ETF	243.66	243.66	243.3	243.34	79666.0
2020-06-29 18:00:00	QQQ	ETF	243.49	244.11	243.33	243.91	141229.0
2020-06-29 19:00:00	QQQ	ETF	243.92	244.05	243.71	243.77	57669.0
2020-06-29 04:00:00	IWM	ETF	137.96	138.09	137.38	137.98	38425.0
2020-06-29 05:00:00	IWM	ETF	138.0	138.24	137.6	138.22	55677.0
2020-06-29 06:00:00	IWM	ETF	138.0	138.32	137.7	138.32	30914.0
2020-06-29 07:00:00	IWM	ETF	138.27	139.6	138.021	139.33	230288.0
2020-06-29 08:00:00	IWM	ETF	138.5	139.35	137.22	138.33	580470.0
2020-06-29 09:00:00	IWM	ETF	138.36	139.0	137.1	138.84	3978917.0
2020-06-29 10:00:00	IWM	ETF	138.84	141.48	138.84	140.74	6729440.0
2020-06-29 11:00:00	IWM	ETF	140.74	141.15	140.35	140.9	2555556.0
2020-06-29 12:00:00	IWM	ETF	140.9	141.985	140.74	141.49	3040544.0
2020-06-29 13:00:00	IWM	ETF	141.5	141.79	141.0	141.06	2329961.0
2020-06-29 14:00:00	IWM	ETF	141.06	141.19	140.11	140.43	2352265.0
2020-06-29 15:00:00	IWM	ETF	140.43	141.34	139.79	141.33	4670506.0
2020-06-29 16:00:00	IWM	ETF	141.35	141.96	137.0085	141.79	4175879.0
2020-06-29 17:00:00	IWM	ETF	141.65	141.82	141.55	141.7	14367.0
2020-06-29 18:00:00	IWM	ETF	141.7	142.25	141.51	142.01	49000.0
2020-06-29 19:00:00	IWM	ETF	141.98	142.15	141.8	141.9	22654.0
2020-06-29 04:00:00	DIA	ETF	251.0	251.61	250.5	251.61	14878.0
2020-06-29 05:00:00	DIA	ETF	251.52	252.11	251.3	252.11	5085.0

> showing 50 of 12,505 rows — these rows as CSV

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