PREVIEW / etf_1hour / 2019-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-11.parquet
  size:    313 KB
  rows:    10,531

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-02-11 04:00:00	SPY	ETF	271.39	271.77	271.3	271.55	14704.0
2019-02-11 05:00:00	SPY	ETF	271.58	271.58	271.33	271.34	8942.0
2019-02-11 06:00:00	SPY	ETF	271.34	271.34	270.96	271.08	27858.0
2019-02-11 07:00:00	SPY	ETF	271.04	271.41	270.96	271.41	170633.0
2019-02-11 08:00:00	SPY	ETF	271.36	271.9	270.47	271.34	479874.0
2019-02-11 09:00:00	SPY	ETF	271.3	271.49	270.57	270.78	7260223.0
2019-02-11 10:00:00	SPY	ETF	270.78	271.13	270.32	270.63	7625639.0
2019-02-11 11:00:00	SPY	ETF	270.64	270.85	270.14	270.5193	7437345.0
2019-02-11 12:00:00	SPY	ETF	270.51	270.95	270.45	270.7917	5918866.0
2019-02-11 13:00:00	SPY	ETF	270.8	270.93	270.215	270.48	7745363.0
2019-02-11 14:00:00	SPY	ETF	270.47	270.59	270.03	270.295	7863171.0
2019-02-11 15:00:00	SPY	ETF	270.29	270.87	270.27	270.6599	14805787.0
2019-02-11 16:00:00	SPY	ETF	270.66	270.75	270.39	270.54	7522172.0
2019-02-11 17:00:00	SPY	ETF	270.54	270.58	270.44	270.47	49618.0
2019-02-11 18:00:00	SPY	ETF	270.48	270.65	270.37	270.62	78708.0
2019-02-11 19:00:00	SPY	ETF	270.63	271.34	270.6	271.14	111774.0
2019-02-11 04:00:00	QQQ	ETF	169.17	169.64	169.15	169.29	68654.0
2019-02-11 05:00:00	QQQ	ETF	169.26	169.3	169.15	169.17	18896.0
2019-02-11 06:00:00	QQQ	ETF	169.24	169.24	168.93	169.0	25222.0
2019-02-11 07:00:00	QQQ	ETF	168.96	169.36	168.89	169.34	79616.0
2019-02-11 08:00:00	QQQ	ETF	169.13	169.54	168.15	169.19	105099.0
2019-02-11 09:00:00	QQQ	ETF	169.14	169.58	168.541	168.7615	3762313.0
2019-02-11 10:00:00	QQQ	ETF	168.75	169.19	168.54	168.71	3364923.0
2019-02-11 11:00:00	QQQ	ETF	168.71	168.85	168.25	168.54	2569530.0
2019-02-11 12:00:00	QQQ	ETF	168.54	168.89	168.48	168.72	1351233.0
2019-02-11 13:00:00	QQQ	ETF	168.72	168.76	168.11	168.33	1158521.0
2019-02-11 14:00:00	QQQ	ETF	168.33	168.47	167.98	168.18	1807758.0
2019-02-11 15:00:00	QQQ	ETF	168.18	168.56	168.14	168.4	2869221.0
2019-02-11 16:00:00	QQQ	ETF	168.4	168.47	168.21	168.31	1229167.0
2019-02-11 17:00:00	QQQ	ETF	168.21	168.4	168.21	168.22	92539.0
2019-02-11 18:00:00	QQQ	ETF	168.24	168.37	168.11	168.37	27796.0
2019-02-11 19:00:00	QQQ	ETF	168.34	168.87	168.34	168.74	68355.0
2019-02-11 04:00:00	IWM	ETF	150.41	150.54	149.89	150.52	17821.0
2019-02-11 05:00:00	IWM	ETF	150.5	150.5	150.38	150.4	13000.0
2019-02-11 06:00:00	IWM	ETF	150.41	150.44	150.25	150.28	10000.0
2019-02-11 07:00:00	IWM	ETF	150.29	150.38	150.25	150.33	21825.0
2019-02-11 08:00:00	IWM	ETF	150.41	150.61	150.18	150.36	28179.0
2019-02-11 09:00:00	IWM	ETF	150.35	150.53	149.63	149.72	1446664.0
2019-02-11 10:00:00	IWM	ETF	149.7	150.66	149.685	150.57	2017030.0
2019-02-11 11:00:00	IWM	ETF	150.57	150.82	150.04	150.45	1988507.0
2019-02-11 12:00:00	IWM	ETF	150.46	150.84	150.42	150.7599	1192057.0
2019-02-11 13:00:00	IWM	ETF	150.75	150.8	150.5	150.66	1070831.0
2019-02-11 14:00:00	IWM	ETF	150.66	150.7027	150.375	150.55	1225688.0
2019-02-11 15:00:00	IWM	ETF	150.55	151.15	150.53	151.1	2606358.0
2019-02-11 16:00:00	IWM	ETF	151.11	151.13	150.98	151.08	1078590.0
2019-02-11 17:00:00	IWM	ETF	151.1	151.1	149.8063	151.05	376183.0
2019-02-11 18:00:00	IWM	ETF	151.03	151.1	150.95	151.1	4231.0
2019-02-11 19:00:00	IWM	ETF	151.1	151.43	151.1	151.35	6360.0
2019-02-11 05:00:00	DIA	ETF	252.34	252.34	252.1	252.1	302.0
2019-02-11 07:00:00	DIA	ETF	252.01	252.01	252.01	252.01	160.0

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

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