PREVIEW / etf_1hour / 2020-08-05

all etf 1-hour files

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

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-08-05 04:00:00	SPY	ETF	331.85	331.87	331.0	331.81	35526.0
2020-08-05 05:00:00	SPY	ETF	331.82	332.0	331.47	331.86	12424.0
2020-08-05 06:00:00	SPY	ETF	331.98	332.1	331.69	331.95	28488.0
2020-08-05 07:00:00	SPY	ETF	331.81	332.16	331.68	332.16	258279.0
2020-08-05 08:00:00	SPY	ETF	332.21	332.21	330.0	331.64	405626.0
2020-08-05 09:00:00	SPY	ETF	331.63	331.93	331.23	331.88	4111637.0
2020-08-05 10:00:00	SPY	ETF	331.89	332.16	331.62	331.85	6345783.0
2020-08-05 11:00:00	SPY	ETF	331.86	332.39	331.62	331.64	4959859.0
2020-08-05 12:00:00	SPY	ETF	331.635	331.935	331.43	331.82	4234886.0
2020-08-05 13:00:00	SPY	ETF	331.82	332.02	331.66	331.881	3148696.0
2020-08-05 14:00:00	SPY	ETF	331.885	332.2299	331.73	331.88	3546436.0
2020-08-05 15:00:00	SPY	ETF	331.88	332.34	331.18	332.06	10412455.0
2020-08-05 16:00:00	SPY	ETF	332.06	332.12	331.46	331.85	4520742.0
2020-08-05 17:00:00	SPY	ETF	331.74	331.85	331.72	331.75	72651.0
2020-08-05 18:00:00	SPY	ETF	331.75	332.04	331.62	332.01	78175.0
2020-08-05 19:00:00	SPY	ETF	332.04	332.15	331.88	332.0	60988.0
2020-08-05 04:00:00	QQQ	ETF	271.61	271.75	270.94	271.47	36560.0
2020-08-05 05:00:00	QQQ	ETF	271.56	271.82	271.35	271.79	15769.0
2020-08-05 06:00:00	QQQ	ETF	271.75	271.75	271.12	271.21	155186.0
2020-08-05 07:00:00	QQQ	ETF	271.16	271.59	271.1	271.37	189618.0
2020-08-05 08:00:00	QQQ	ETF	271.16	271.77	270.42	270.53	238048.0
2020-08-05 09:00:00	QQQ	ETF	270.51	271.155	269.96	271.03	3119423.0
2020-08-05 10:00:00	QQQ	ETF	271.05	271.49	270.55	270.86	3529356.0
2020-08-05 11:00:00	QQQ	ETF	270.86	271.52	270.46	270.6	2713195.0
2020-08-05 12:00:00	QQQ	ETF	270.6	271.169	270.59	270.88	1566572.0
2020-08-05 13:00:00	QQQ	ETF	270.89	271.28	270.8068	271.12	1187660.0
2020-08-05 14:00:00	QQQ	ETF	271.11	271.37	270.76	271.05	1438151.0
2020-08-05 15:00:00	QQQ	ETF	271.05	271.24	270.1	271.11	3430445.0
2020-08-05 16:00:00	QQQ	ETF	271.1	271.12	270.51	270.74	715393.0
2020-08-05 17:00:00	QQQ	ETF	270.76	270.79	270.5801	270.64	11278.0
2020-08-05 18:00:00	QQQ	ETF	270.59	270.8	270.49	270.75	30863.0
2020-08-05 19:00:00	QQQ	ETF	270.76	270.81	270.54	270.59	36123.0
2020-08-05 04:00:00	IWM	ETF	151.99	152.08	151.7	152.08	5860.0
2020-08-05 05:00:00	IWM	ETF	152.15	152.3	152.12	152.21	4100.0
2020-08-05 06:00:00	IWM	ETF	152.35	152.35	152.19	152.35	106942.0
2020-08-05 07:00:00	IWM	ETF	152.25	152.81	152.18	152.81	128135.0
2020-08-05 08:00:00	IWM	ETF	152.2604	152.8	150.88	152.53	189484.0
2020-08-05 09:00:00	IWM	ETF	152.47	152.77	152.14	152.34	2121877.0
2020-08-05 10:00:00	IWM	ETF	152.33	152.57	151.78	152.415	1797427.0
2020-08-05 11:00:00	IWM	ETF	152.42	152.86	152.405	152.5	2021589.0
2020-08-05 12:00:00	IWM	ETF	152.5	152.74	152.24	152.435	1018312.0
2020-08-05 13:00:00	IWM	ETF	152.44	152.9699	152.355	152.88	1013797.0
2020-08-05 14:00:00	IWM	ETF	152.89	153.37	152.86	153.275	1327554.0
2020-08-05 15:00:00	IWM	ETF	153.27	153.89	152.2	153.77	4894257.0
2020-08-05 16:00:00	IWM	ETF	153.79	153.86	153.52	153.81	674192.0
2020-08-05 17:00:00	IWM	ETF	153.83	154.03	153.17	153.5	137731.0
2020-08-05 18:00:00	IWM	ETF	153.65	153.85	153.57	153.85	107102.0
2020-08-05 19:00:00	IWM	ETF	153.85	154.1	153.82	153.97	45730.0
2020-08-05 04:00:00	DIA	ETF	269.9	269.9	269.37	269.49	1800.0
2020-08-05 05:00:00	DIA	ETF	270.11	270.24	270.11	270.24	825.0

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

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