PREVIEW / etf_1hour / 2020-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-01.parquet
  size:    374 KB
  rows:    12,819

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-10-01 04:00:00	SPY	ETF	337.66	338.08	336.65	336.94	128838.0
2020-10-01 05:00:00	SPY	ETF	336.89	338.38	336.88	338.29	72939.0
2020-10-01 06:00:00	SPY	ETF	338.34	338.6	337.85	338.12	173977.0
2020-10-01 07:00:00	SPY	ETF	338.05	338.72	337.98	338.47	301061.0
2020-10-01 08:00:00	SPY	ETF	338.3099	338.64	334.89	337.66	620797.0
2020-10-01 09:00:00	SPY	ETF	337.65	338.74	336.61	336.76	10727634.0
2020-10-01 10:00:00	SPY	ETF	336.74	337.41	335.58	336.68	11882252.0
2020-10-01 11:00:00	SPY	ETF	336.68	337.64	335.8	337.2	9935740.0
2020-10-01 12:00:00	SPY	ETF	337.2	337.39	336.245	337.17	6713290.0
2020-10-01 13:00:00	SPY	ETF	337.17	337.653	335.87	336.25	8476334.0
2020-10-01 14:00:00	SPY	ETF	336.24	337.19	335.01	336.95	12407728.0
2020-10-01 15:00:00	SPY	ETF	336.96	337.44	335.815	337.03	18121928.0
2020-10-01 16:00:00	SPY	ETF	337.02	337.44	335.2417	336.74	5805457.0
2020-10-01 17:00:00	SPY	ETF	336.84	337.0	336.8	336.81	238976.0
2020-10-01 18:00:00	SPY	ETF	336.81	337.49	336.25	337.13	341438.0
2020-10-01 19:00:00	SPY	ETF	337.2	337.25	336.57	336.77	109254.0
2020-10-01 04:00:00	QQQ	ETF	280.22	280.9	279.66	279.97	90222.0
2020-10-01 05:00:00	QQQ	ETF	279.96	281.62	279.96	281.57	73704.0
2020-10-01 06:00:00	QQQ	ETF	281.6	282.19	281.35	281.94	60164.0
2020-10-01 07:00:00	QQQ	ETF	281.84	282.29	281.56	282.12	274355.0
2020-10-01 08:00:00	QQQ	ETF	282.13	282.71	277.84	281.87	661574.0
2020-10-01 09:00:00	QQQ	ETF	281.8498	282.26	280.75	281.03	5080572.0
2020-10-01 10:00:00	QQQ	ETF	281.03	281.55	280.12	280.88	4761749.0
2020-10-01 11:00:00	QQQ	ETF	280.88	281.86	279.84	281.28	3883970.0
2020-10-01 12:00:00	QQQ	ETF	281.235	281.59	280.45	281.54	2839385.0
2020-10-01 13:00:00	QQQ	ETF	281.55	282.38	281.21	281.57	3834181.0
2020-10-01 14:00:00	QQQ	ETF	281.56	282.665	280.42	282.45	5769270.0
2020-10-01 15:00:00	QQQ	ETF	282.49	282.8794	281.27	282.26	5953029.0
2020-10-01 16:00:00	QQQ	ETF	282.25	282.82	282.11	282.23	1787578.0
2020-10-01 17:00:00	QQQ	ETF	282.24	282.44	282.16	282.3	64542.0
2020-10-01 18:00:00	QQQ	ETF	282.25	283.0	281.84	282.68	175012.0
2020-10-01 19:00:00	QQQ	ETF	282.66	282.67	282.06	282.25	54848.0
2020-10-01 04:00:00	IWM	ETF	151.0	151.26	150.5	150.65	29433.0
2020-10-01 05:00:00	IWM	ETF	150.58	151.01	150.58	151.01	3864.0
2020-10-01 06:00:00	IWM	ETF	151.1	151.1	150.59	150.59	1088.0
2020-10-01 07:00:00	IWM	ETF	150.7	151.29	150.7	151.29	164757.0
2020-10-01 08:00:00	IWM	ETF	150.7101	151.31	150.64	150.89	263601.0
2020-10-01 09:00:00	IWM	ETF	150.89	151.52	150.17	150.24	3460388.0
2020-10-01 10:00:00	IWM	ETF	150.21	150.78	149.49	150.54	3529346.0
2020-10-01 11:00:00	IWM	ETF	150.53	150.77	150.064	150.56	2058421.0
2020-10-01 12:00:00	IWM	ETF	150.52	151.18	150.2	151.02	1072696.0
2020-10-01 13:00:00	IWM	ETF	151.02	151.54	150.89	150.99	1916220.0
2020-10-01 14:00:00	IWM	ETF	151.0	151.65	150.22	151.53	3426380.0
2020-10-01 15:00:00	IWM	ETF	151.53	152.2	151.245	152.16	4382476.0
2020-10-01 16:00:00	IWM	ETF	152.15	152.35	151.91	152.0	1530207.0
2020-10-01 17:00:00	IWM	ETF	152.13	152.16	152.0	152.02	16022.0
2020-10-01 18:00:00	IWM	ETF	152.14	152.39	151.91	152.18	34604.0
2020-10-01 19:00:00	IWM	ETF	152.11	152.11	151.93	151.95	6768.0
2020-10-01 04:00:00	DIA	ETF	279.9	280.3	279.23	279.48	1800.0
2020-10-01 05:00:00	DIA	ETF	279.74	279.83	279.74	279.83	600.0

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

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