PREVIEW / etf_1hour / 2020-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-23.parquet
  size:    361 KB
  rows:    12,209

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-23 04:00:00	SPY	ETF	345.42	345.88	345.22	345.22	12291.0
2020-10-23 05:00:00	SPY	ETF	345.26	345.92	345.15	345.43	20488.0
2020-10-23 06:00:00	SPY	ETF	345.48	346.0	345.24	345.74	36239.0
2020-10-23 07:00:00	SPY	ETF	345.72	346.12	345.48	345.88	111583.0
2020-10-23 08:00:00	SPY	ETF	345.54	346.18	344.1	346.01	176545.0
2020-10-23 09:00:00	SPY	ETF	346.0	346.09	344.83	345.35	5155032.0
2020-10-23 10:00:00	SPY	ETF	345.3392	345.3392	344.4	344.71	6460194.0
2020-10-23 11:00:00	SPY	ETF	344.71	345.24	343.605	344.15	5189963.0
2020-10-23 12:00:00	SPY	ETF	344.145	344.45	343.13	343.41	5458770.0
2020-10-23 13:00:00	SPY	ETF	343.4	344.69	343.35	344.48	3940888.0
2020-10-23 14:00:00	SPY	ETF	344.49	345.16	344.32	344.74	3804051.0
2020-10-23 15:00:00	SPY	ETF	344.72	345.77	344.7	345.76	10469492.0
2020-10-23 16:00:00	SPY	ETF	345.75	345.78	345.07	345.22	7426432.0
2020-10-23 17:00:00	SPY	ETF	345.22	345.52	345.19	345.52	114046.0
2020-10-23 18:00:00	SPY	ETF	345.52	345.61	345.21	345.52	32596.0
2020-10-23 19:00:00	SPY	ETF	345.52	345.57	345.4	345.55	33112.0
2020-10-23 04:00:00	QQQ	ETF	284.68	284.83	284.2	284.23	24056.0
2020-10-23 05:00:00	QQQ	ETF	284.12	284.6	284.02	284.3	7908.0
2020-10-23 06:00:00	QQQ	ETF	284.36	284.66	283.8	284.49	39131.0
2020-10-23 07:00:00	QQQ	ETF	284.48	284.9	284.33	284.76	94483.0
2020-10-23 08:00:00	QQQ	ETF	284.39	285.19	284.0	285.01	148134.0
2020-10-23 09:00:00	QQQ	ETF	284.95	284.98	282.752	283.34	2632908.0
2020-10-23 10:00:00	QQQ	ETF	283.31	283.65	282.23	283.046	3378819.0
2020-10-23 11:00:00	QQQ	ETF	283.02	283.89	281.7818	282.54	3112139.0
2020-10-23 12:00:00	QQQ	ETF	282.5607	283.35	282.03	282.82	2440874.0
2020-10-23 13:00:00	QQQ	ETF	282.82	283.79	282.75	283.54	1541233.0
2020-10-23 14:00:00	QQQ	ETF	283.53	284.13	283.39	283.49	1815654.0
2020-10-23 15:00:00	QQQ	ETF	283.49	284.91	283.44	284.89	3217977.0
2020-10-23 16:00:00	QQQ	ETF	284.9	284.9	284.39	284.61	575656.0
2020-10-23 17:00:00	QQQ	ETF	284.7	285.06	284.52	284.86	54972.0
2020-10-23 18:00:00	QQQ	ETF	285.0	285.09	284.77	284.85	18669.0
2020-10-23 19:00:00	QQQ	ETF	284.9	285.0	284.83	285.0	13184.0
2020-10-23 04:00:00	IWM	ETF	162.88	163.18	162.7	162.7	12465.0
2020-10-23 05:00:00	IWM	ETF	162.71	163.06	162.7	162.9	13340.0
2020-10-23 06:00:00	IWM	ETF	162.93	163.28	162.82	163.18	11896.0
2020-10-23 07:00:00	IWM	ETF	163.14	163.3	162.95	163.22	63856.0
2020-10-23 08:00:00	IWM	ETF	163.07	163.35	162.07	163.12	146090.0
2020-10-23 09:00:00	IWM	ETF	163.14	163.33	162.345	162.58	1992910.0
2020-10-23 10:00:00	IWM	ETF	162.57	162.85	162.05	162.4	2774929.0
2020-10-23 11:00:00	IWM	ETF	162.38	162.89	162.16	162.32	1421019.0
2020-10-23 12:00:00	IWM	ETF	162.329	162.41	161.25	161.55	1747668.0
2020-10-23 13:00:00	IWM	ETF	161.53	162.615	161.53	162.6	998234.0
2020-10-23 14:00:00	IWM	ETF	162.61	163.04	162.53	162.69	1707287.0
2020-10-23 15:00:00	IWM	ETF	162.68	163.215	162.67	163.08	4285960.0
2020-10-23 16:00:00	IWM	ETF	163.07	163.07	162.68	163.02	1987581.0
2020-10-23 17:00:00	IWM	ETF	163.05	163.34	162.94	163.34	90301.0
2020-10-23 18:00:00	IWM	ETF	163.34	163.41	163.2	163.2	23282.0
2020-10-23 19:00:00	IWM	ETF	163.25	163.3	163.18	163.18	9441.0
2020-10-23 04:00:00	DIA	ETF	284.43	284.54	284.43	284.51	1300.0
2020-10-23 05:00:00	DIA	ETF	284.51	284.83	284.51	284.83	800.0

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

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