PREVIEW / etf_1hour / 2020-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-06.parquet
  size:    382 KB
  rows:    13,053

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-11-06 04:00:00	SPY	ETF	348.07	348.11	346.12	346.3	150115.0
2020-11-06 05:00:00	SPY	ETF	346.3	347.86	345.77	347.5	81797.0
2020-11-06 06:00:00	SPY	ETF	347.69	348.28	347.4	347.86	102767.0
2020-11-06 07:00:00	SPY	ETF	347.84	348.53	346.78	346.99	370093.0
2020-11-06 08:00:00	SPY	ETF	348.3599	350.3	346.54	350.03	1236554.0
2020-11-06 09:00:00	SPY	ETF	350.04	351.87	347.65	348.26	7560706.0
2020-11-06 10:00:00	SPY	ETF	348.26	350.52	348.04	348.8866	7115759.0
2020-11-06 11:00:00	SPY	ETF	348.87	350.9	348.643	350.37	8351866.0
2020-11-06 12:00:00	SPY	ETF	350.36	350.78	349.4702	350.11	5274159.0
2020-11-06 13:00:00	SPY	ETF	350.127	350.82	350.06	350.47	3328344.0
2020-11-06 14:00:00	SPY	ETF	350.47	350.78	349.77	349.99	4494802.0
2020-11-06 15:00:00	SPY	ETF	349.97	351.51	349.21	350.19	24923124.0
2020-11-06 16:00:00	SPY	ETF	350.2	351.0	350.06	351.0	10398743.0
2020-11-06 17:00:00	SPY	ETF	351.06	351.06	350.08	350.91	501123.0
2020-11-06 18:00:00	SPY	ETF	350.91	350.93	350.82	350.9	61052.0
2020-11-06 19:00:00	SPY	ETF	350.9	351.03	350.87	350.96	48424.0
2020-11-06 04:00:00	QQQ	ETF	291.62	291.82	290.3	290.4	87086.0
2020-11-06 05:00:00	QQQ	ETF	290.43	291.38	289.55	291.14	78059.0
2020-11-06 06:00:00	QQQ	ETF	291.18	291.95	291.18	291.5	104344.0
2020-11-06 07:00:00	QQQ	ETF	291.55	292.38	290.8	291.2	303393.0
2020-11-06 08:00:00	QQQ	ETF	291.17	293.25	290.73	293.22	697267.0
2020-11-06 09:00:00	QQQ	ETF	293.25	294.42	289.83	290.2	6522644.0
2020-11-06 10:00:00	QQQ	ETF	290.22	293.25	289.95	291.99	4858365.0
2020-11-06 11:00:00	QQQ	ETF	291.99	294.36	291.76	293.87	3338101.0
2020-11-06 12:00:00	QQQ	ETF	293.9	294.55	293.35	294.25	2523566.0
2020-11-06 13:00:00	QQQ	ETF	294.2502	295.12	294.17	294.745	2269015.0
2020-11-06 14:00:00	QQQ	ETF	294.73	295.175	293.84	294.195	2559459.0
2020-11-06 15:00:00	QQQ	ETF	294.18	295.36	293.42	294.64	6437564.0
2020-11-06 16:00:00	QQQ	ETF	294.62	295.03	292.5	295.0	3198495.0
2020-11-06 17:00:00	QQQ	ETF	294.8	295.09	294.63	294.86	22884.0
2020-11-06 18:00:00	QQQ	ETF	294.83	294.8599	294.68	294.85	6485.0
2020-11-06 19:00:00	QQQ	ETF	294.8	295.0	294.79	294.95	22889.0
2020-11-06 04:00:00	IWM	ETF	163.99	164.12	163.22	163.32	25646.0
2020-11-06 05:00:00	IWM	ETF	163.36	164.28	162.99	164.06	26800.0
2020-11-06 06:00:00	IWM	ETF	164.04	164.4	163.95	164.12	29321.0
2020-11-06 07:00:00	IWM	ETF	164.19	164.43	163.47	163.52	74269.0
2020-11-06 08:00:00	IWM	ETF	163.8699	165.5	163.27	165.4	202031.0
2020-11-06 09:00:00	IWM	ETF	165.43	166.09	164.07	164.33	2776396.0
2020-11-06 10:00:00	IWM	ETF	164.32	165.37	164.28	164.54	2706323.0
2020-11-06 11:00:00	IWM	ETF	164.53	165.11	163.8	163.87	2177935.0
2020-11-06 12:00:00	IWM	ETF	163.88	164.17	163.63	163.75	1675879.0
2020-11-06 13:00:00	IWM	ETF	163.735	164.3	163.735	164.09	1293810.0
2020-11-06 14:00:00	IWM	ETF	164.09	164.18	163.53	163.66	1897676.0
2020-11-06 15:00:00	IWM	ETF	163.66	164.04	163.3	163.58	4753491.0
2020-11-06 16:00:00	IWM	ETF	163.56	164.11	163.44	164.05	1412414.0
2020-11-06 17:00:00	IWM	ETF	164.11	164.28	163.62	163.84	688071.0
2020-11-06 18:00:00	IWM	ETF	163.82	163.82	163.74	163.74	2000.0
2020-11-06 19:00:00	IWM	ETF	163.81	163.97	163.81	163.97	500.0
2020-11-06 04:00:00	DIA	ETF	282.19	282.3	281.81	281.81	1890.0
2020-11-06 05:00:00	DIA	ETF	281.0	282.29	281.0	282.29	1300.0

> showing 50 of 13,053 rows — these rows as CSV

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