PREVIEW / etf_1hour / 2020-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-27.parquet
  size:    370 KB
  rows:    12,560

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-27 04:00:00	SPY	ETF	340.42	340.42	339.25	340.03	97607.0
2020-10-27 05:00:00	SPY	ETF	339.89	340.0	339.34	339.87	27780.0
2020-10-27 06:00:00	SPY	ETF	340.06	341.05	340.04	340.82	91869.0
2020-10-27 07:00:00	SPY	ETF	340.79	341.01	340.56	341.01	266907.0
2020-10-27 08:00:00	SPY	ETF	341.0	341.01	339.84	339.9	540032.0
2020-10-27 09:00:00	SPY	ETF	339.88	340.16	338.77	339.69	5376035.0
2020-10-27 10:00:00	SPY	ETF	339.7	340.08	338.14	338.78	8262668.0
2020-10-27 11:00:00	SPY	ETF	338.78	339.84	338.1922	339.76	6120521.0
2020-10-27 12:00:00	SPY	ETF	339.77	340.04	338.53	339.01	5033610.0
2020-10-27 13:00:00	SPY	ETF	339.01	340.12	338.563	339.66	5035466.0
2020-10-27 14:00:00	SPY	ETF	339.65	339.8182	338.27	338.56	5294919.0
2020-10-27 15:00:00	SPY	ETF	338.56	339.33	337.99	338.25	16484841.0
2020-10-27 16:00:00	SPY	ETF	338.28	338.62	336.9	336.91	11150083.0
2020-10-27 17:00:00	SPY	ETF	336.86	339.2738	336.21	336.85	597157.0
2020-10-27 18:00:00	SPY	ETF	336.84	336.89	335.77	335.96	352020.0
2020-10-27 19:00:00	SPY	ETF	335.98	336.64	335.98	336.55	143249.0
2020-10-27 04:00:00	QQQ	ETF	281.47	281.47	280.64	281.26	79295.0
2020-10-27 05:00:00	QQQ	ETF	281.23	281.48	280.77	281.21	50837.0
2020-10-27 06:00:00	QQQ	ETF	281.23	282.1	281.21	281.68	83592.0
2020-10-27 07:00:00	QQQ	ETF	281.72	282.06	281.59	282.06	124491.0
2020-10-27 08:00:00	QQQ	ETF	282.05	282.13	280.85	281.42	196752.0
2020-10-27 09:00:00	QQQ	ETF	281.4	282.42	280.5	281.77	3586159.0
2020-10-27 10:00:00	QQQ	ETF	281.79	282.35	280.2	281.83	3641164.0
2020-10-27 11:00:00	QQQ	ETF	281.83	283.11	281.45	282.99	3270616.0
2020-10-27 12:00:00	QQQ	ETF	283.0	283.16	281.7	282.3228	2420622.0
2020-10-27 13:00:00	QQQ	ETF	282.33	283.14	281.9	282.73	2192522.0
2020-10-27 14:00:00	QQQ	ETF	282.72	282.9017	281.5	282.0	2783135.0
2020-10-27 15:00:00	QQQ	ETF	282.0	283.505	281.51	282.6	4417498.0
2020-10-27 16:00:00	QQQ	ETF	282.63	283.4	281.85	281.87	1199740.0
2020-10-27 17:00:00	QQQ	ETF	281.89	282.0	281.52	281.8	114213.0
2020-10-27 18:00:00	QQQ	ETF	281.85	281.93	280.73	281.08	231076.0
2020-10-27 19:00:00	QQQ	ETF	281.08	281.5	281.07	281.45	107073.0
2020-10-27 04:00:00	IWM	ETF	160.03	160.08	159.47	159.66	6851.0
2020-10-27 05:00:00	IWM	ETF	159.26	159.4	159.1	159.3	11201.0
2020-10-27 06:00:00	IWM	ETF	159.35	160.08	159.35	160.05	90523.0
2020-10-27 07:00:00	IWM	ETF	160.05	160.26	159.91	160.04	130754.0
2020-10-27 08:00:00	IWM	ETF	160.22	160.22	159.37	159.45	99377.0
2020-10-27 09:00:00	IWM	ETF	159.45	159.89	159.1	159.89	1808028.0
2020-10-27 10:00:00	IWM	ETF	159.86	160.06	158.875	158.97	2561758.0
2020-10-27 11:00:00	IWM	ETF	158.97	159.25	158.36	158.97	1947345.0
2020-10-27 12:00:00	IWM	ETF	158.97	159.02	158.275	158.51	1185797.0
2020-10-27 13:00:00	IWM	ETF	158.49	159.03	158.21	158.8811	1801348.0
2020-10-27 14:00:00	IWM	ETF	158.88	158.96	158.095	158.28	2121509.0
2020-10-27 15:00:00	IWM	ETF	158.285	158.765	157.94	158.18	4128324.0
2020-10-27 16:00:00	IWM	ETF	158.18	158.18	157.03	157.09	796048.0
2020-10-27 17:00:00	IWM	ETF	157.18	157.4	156.96	157.22	47876.0
2020-10-27 18:00:00	IWM	ETF	157.16	158.18	156.59	156.71	124720.0
2020-10-27 19:00:00	IWM	ETF	156.69	157.05	156.68	156.96	41904.0
2020-10-27 04:00:00	DIA	ETF	277.0	277.31	276.92	277.27	2300.0
2020-10-27 05:00:00	DIA	ETF	276.72	277.12	276.62	276.98	12190.0

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

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