PREVIEW / etf_1hour / 2020-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-13.parquet
  size:    372 KB
  rows:    12,836

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-05-13 04:00:00	SPY	ETF	285.68	286.59	285.24	285.55	124683.0
2020-05-13 05:00:00	SPY	ETF	285.39	287.24	285.26	286.98	136021.0
2020-05-13 06:00:00	SPY	ETF	286.9	287.66	286.89	287.21	298056.0
2020-05-13 07:00:00	SPY	ETF	287.3	287.94	286.85	287.64	610071.0
2020-05-13 08:00:00	SPY	ETF	287.62	287.92	285.0	286.86	834234.0
2020-05-13 09:00:00	SPY	ETF	286.81	286.81	283.64	284.85	14934303.0
2020-05-13 10:00:00	SPY	ETF	284.84	287.19	284.57	284.75	15945307.0
2020-05-13 11:00:00	SPY	ETF	284.76	285.39	281.18	281.87	19548168.0
2020-05-13 12:00:00	SPY	ETF	281.87	282.27	279.61	281.725	23666759.0
2020-05-13 13:00:00	SPY	ETF	281.7162	282.07	280.43	280.78	9508769.0
2020-05-13 14:00:00	SPY	ETF	280.79	281.83	279.67	279.6728	11041962.0
2020-05-13 15:00:00	SPY	ETF	279.67	282.09	278.965	281.67	33076865.0
2020-05-13 16:00:00	SPY	ETF	281.67	282.31	281.28	282.2	10557466.0
2020-05-13 17:00:00	SPY	ETF	281.68	282.32	281.6	282.3	3011015.0
2020-05-13 18:00:00	SPY	ETF	282.33	282.75	281.91	282.44	308054.0
2020-05-13 19:00:00	SPY	ETF	282.48	282.81	281.9	282.02	372317.0
2020-05-13 04:00:00	QQQ	ETF	222.02	222.76	221.62	221.97	59952.0
2020-05-13 05:00:00	QQQ	ETF	221.93	223.28	221.84	222.99	64824.0
2020-05-13 06:00:00	QQQ	ETF	222.94	223.53	222.94	223.25	64121.0
2020-05-13 07:00:00	QQQ	ETF	223.35	223.8	222.96	223.64	193806.0
2020-05-13 08:00:00	QQQ	ETF	223.6	223.77	221.31	223.13	326548.0
2020-05-13 09:00:00	QQQ	ETF	223.08	223.11	220.7	222.44	6917712.0
2020-05-13 10:00:00	QQQ	ETF	222.42	224.61	222.32	222.46	8046031.0
2020-05-13 11:00:00	QQQ	ETF	222.48	223.17	219.12	219.56	9543906.0
2020-05-13 12:00:00	QQQ	ETF	219.57	219.8	216.89	219.15	10119442.0
2020-05-13 13:00:00	QQQ	ETF	219.16	219.26	217.56	217.98	5398800.0
2020-05-13 14:00:00	QQQ	ETF	217.99	219.17	217.29	217.29	5316778.0
2020-05-13 15:00:00	QQQ	ETF	217.29	219.77	216.71	219.44	10647160.0
2020-05-13 16:00:00	QQQ	ETF	219.46	220.2	219.22	219.97	1596487.0
2020-05-13 17:00:00	QQQ	ETF	220.0	220.05	219.4	220.05	60593.0
2020-05-13 18:00:00	QQQ	ETF	220.05	220.39	219.82	220.28	170519.0
2020-05-13 19:00:00	QQQ	ETF	220.29	220.59	219.86	219.97	157099.0
2020-05-13 04:00:00	IWM	ETF	126.1	126.6	125.83	125.83	7200.0
2020-05-13 05:00:00	IWM	ETF	125.8	126.43	125.8	126.34	9600.0
2020-05-13 06:00:00	IWM	ETF	126.74	126.9	126.59	126.67	70679.0
2020-05-13 07:00:00	IWM	ETF	126.71	127.45	126.45	127.38	235954.0
2020-05-13 08:00:00	IWM	ETF	127.38	127.53	125.57	126.67	292049.0
2020-05-13 09:00:00	IWM	ETF	126.48	126.51	124.02	125.22	7016991.0
2020-05-13 10:00:00	IWM	ETF	125.21	126.08	124.01	124.065	5501064.0
2020-05-13 11:00:00	IWM	ETF	124.08	124.375	121.8	122.125	9149135.0
2020-05-13 12:00:00	IWM	ETF	122.13	122.6	120.41	122.065	7354467.0
2020-05-13 13:00:00	IWM	ETF	122.07	122.78	121.36	121.97	2897457.0
2020-05-13 14:00:00	IWM	ETF	121.96	122.855	121.46	121.97	4744673.0
2020-05-13 15:00:00	IWM	ETF	121.97	123.02	121.53	122.65	10221958.0
2020-05-13 16:00:00	IWM	ETF	122.64	123.14	122.29	123.08	3738245.0
2020-05-13 17:00:00	IWM	ETF	123.12	123.45	122.77	122.98	49623.0
2020-05-13 18:00:00	IWM	ETF	123.06	123.42	122.72	123.0	42431.0
2020-05-13 19:00:00	IWM	ETF	122.98	123.49	122.95	123.23	79701.0
2020-05-13 04:00:00	DIA	ETF	237.12	237.97	237.12	237.4	777.0
2020-05-13 05:00:00	DIA	ETF	237.02	238.43	237.02	238.43	2103.0

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

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