PREVIEW / etf_1hour / 2019-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-24.parquet
  size:    325 KB
  rows:    10,665

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
2019-10-24 04:00:00	SPY	ETF	300.36	300.36	299.88	300.33	6401.0
2019-10-24 05:00:00	SPY	ETF	300.39	300.45	300.3	300.42	10349.0
2019-10-24 06:00:00	SPY	ETF	300.4	300.56	300.4	300.55	25585.0
2019-10-24 07:00:00	SPY	ETF	300.51	300.78	300.47	300.76	90791.0
2019-10-24 08:00:00	SPY	ETF	300.76	300.85	300.0	300.7	284068.0
2019-10-24 09:00:00	SPY	ETF	300.72	301.07	299.81	299.88	4474011.0
2019-10-24 10:00:00	SPY	ETF	299.88	300.04	299.4601	299.92	5008310.0
2019-10-24 11:00:00	SPY	ETF	299.92	300.725	299.92	300.56	5780693.0
2019-10-24 12:00:00	SPY	ETF	300.56	300.72	299.52	300.12	4682269.0
2019-10-24 13:00:00	SPY	ETF	300.11	300.16	299.58	299.745	2491746.0
2019-10-24 14:00:00	SPY	ETF	299.745	300.22	299.69	300.15	2726066.0
2019-10-24 15:00:00	SPY	ETF	300.15	300.65	300.11	300.42	6777995.0
2019-10-24 16:00:00	SPY	ETF	300.42	300.62	299.8	299.81	2508027.0
2019-10-24 17:00:00	SPY	ETF	299.76	299.94	299.76	299.85	28149.0
2019-10-24 18:00:00	SPY	ETF	299.89	300.37	299.81	299.89	130186.0
2019-10-24 19:00:00	SPY	ETF	299.96	299.96	299.62	299.73	37432.0
2019-10-24 04:00:00	QQQ	ETF	192.95	193.06	192.79	193.06	10855.0
2019-10-24 05:00:00	QQQ	ETF	193.08	193.15	193.01	193.12	6319.0
2019-10-24 06:00:00	QQQ	ETF	193.08	193.27	193.08	193.25	12236.0
2019-10-24 07:00:00	QQQ	ETF	193.21	193.51	193.14	193.51	57926.0
2019-10-24 08:00:00	QQQ	ETF	193.15	193.6	192.85	193.45	163291.0
2019-10-24 09:00:00	QQQ	ETF	193.45	193.8	192.99	193.1	2482668.0
2019-10-24 10:00:00	QQQ	ETF	193.09	193.38	192.74	193.33	1793739.0
2019-10-24 11:00:00	QQQ	ETF	193.34	194.15	193.335	194.08	2883491.0
2019-10-24 12:00:00	QQQ	ETF	194.09	194.21	193.3	193.8375	1895633.0
2019-10-24 13:00:00	QQQ	ETF	193.835	193.86	193.43	193.5249	990396.0
2019-10-24 14:00:00	QQQ	ETF	193.53	193.91	193.46	193.79	955864.0
2019-10-24 15:00:00	QQQ	ETF	193.785	194.14	193.76	194.08	3260988.0
2019-10-24 16:00:00	QQQ	ETF	194.09	194.36	192.85	192.93	1955864.0
2019-10-24 17:00:00	QQQ	ETF	192.98	193.14	192.96	192.99	86235.0
2019-10-24 18:00:00	QQQ	ETF	192.98	193.08	192.96	193.0	62340.0
2019-10-24 19:00:00	QQQ	ETF	193.0101	193.06	192.79	192.93	22871.0
2019-10-24 04:00:00	IWM	ETF	154.54	154.66	154.54	154.66	764.0
2019-10-24 05:00:00	IWM	ETF	154.62	154.62	154.62	154.62	100.0
2019-10-24 06:00:00	IWM	ETF	154.62	154.67	154.62	154.67	13560.0
2019-10-24 07:00:00	IWM	ETF	154.62	154.77	154.62	154.77	1100.0
2019-10-24 08:00:00	IWM	ETF	154.7599	154.88	154.51	154.87	35550.0
2019-10-24 09:00:00	IWM	ETF	154.84	155.06	154.08	154.26	1192671.0
2019-10-24 10:00:00	IWM	ETF	154.26	154.34	153.68	153.89	1499450.0
2019-10-24 11:00:00	IWM	ETF	153.9	154.53	153.86	154.22	1013430.0
2019-10-24 12:00:00	IWM	ETF	154.23	154.27	153.47	153.69	842995.0
2019-10-24 13:00:00	IWM	ETF	153.7	153.88	153.6	153.82	411686.0
2019-10-24 14:00:00	IWM	ETF	153.82	154.25	153.7977	154.21	478043.0
2019-10-24 15:00:00	IWM	ETF	154.21	154.344	154.1	154.17	1246848.0
2019-10-24 16:00:00	IWM	ETF	154.19	154.35	154.09	154.17	917416.0
2019-10-24 17:00:00	IWM	ETF	154.18	154.18	154.15	154.15	2997.0
2019-10-24 18:00:00	IWM	ETF	154.18	154.19	154.09	154.09	2676.0
2019-10-24 19:00:00	IWM	ETF	154.08	154.08	153.96	153.96	3778.0
2019-10-24 05:00:00	DIA	ETF	268.7	268.7	268.7	268.7	270.0
2019-10-24 07:00:00	DIA	ETF	268.56	268.8	268.56	268.8	1500.0

> showing 50 of 10,665 rows — these rows as CSV

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