PREVIEW / etf_1hour / 2018-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-03.parquet
  size:    322 KB
  rows:    10,365

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
2018-10-03 04:00:00	SPY	ETF	292.18	292.3	292.18	292.3	12041.0
2018-10-03 05:00:00	SPY	ETF	292.27	292.27	291.99	292.21	12710.0
2018-10-03 06:00:00	SPY	ETF	292.32	292.4	292.26	292.29	37110.0
2018-10-03 07:00:00	SPY	ETF	292.3	292.59	292.28	292.53	101869.0
2018-10-03 08:00:00	SPY	ETF	291.56	292.74	291.56	292.74	332977.0
2018-10-03 09:00:00	SPY	ETF	292.71	292.88	292.48	292.5	3764790.0
2018-10-03 10:00:00	SPY	ETF	292.5	293.21	292.49	292.64	10820385.0
2018-10-03 11:00:00	SPY	ETF	292.65	292.87	292.33	292.87	7746767.0
2018-10-03 12:00:00	SPY	ETF	292.8635	292.96	292.59	292.8	3360953.0
2018-10-03 13:00:00	SPY	ETF	292.79	292.93	292.62	292.76	3510817.0
2018-10-03 14:00:00	SPY	ETF	292.76	292.94	291.59	291.91	10325380.0
2018-10-03 15:00:00	SPY	ETF	291.91	292.03	291.32	291.78	15326335.0
2018-10-03 16:00:00	SPY	ETF	291.78	291.98	291.3	291.45	7355561.0
2018-10-03 17:00:00	SPY	ETF	291.46	291.55	291.32	291.37	692890.0
2018-10-03 18:00:00	SPY	ETF	291.37	291.37	291.14	291.32	69865.0
2018-10-03 19:00:00	SPY	ETF	291.29	291.34	291.2	291.3	43530.0
2018-10-03 04:00:00	QQQ	ETF	186.12	186.29	186.12	186.29	1800.0
2018-10-03 05:00:00	QQQ	ETF	186.24	186.24	186.07	186.12	1500.0
2018-10-03 06:00:00	QQQ	ETF	186.25	186.25	186.19	186.19	15070.0
2018-10-03 07:00:00	QQQ	ETF	186.18	186.46	186.17	186.42	54772.0
2018-10-03 08:00:00	QQQ	ETF	185.75	186.63	185.75	186.63	260220.0
2018-10-03 09:00:00	QQQ	ETF	186.59	186.84	186.28	186.48	3361362.0
2018-10-03 10:00:00	QQQ	ETF	186.5	186.97	186.21	186.31	4153154.0
2018-10-03 11:00:00	QQQ	ETF	186.3	186.6679	186.0	186.66	3654899.0
2018-10-03 12:00:00	QQQ	ETF	186.67	186.78	186.28	186.56	1927832.0
2018-10-03 13:00:00	QQQ	ETF	186.56	186.83	186.42	186.5363	1975995.0
2018-10-03 14:00:00	QQQ	ETF	186.54	186.72	185.8729	186.11	4065971.0
2018-10-03 15:00:00	QQQ	ETF	186.11	186.21	185.66	186.0	4990322.0
2018-10-03 16:00:00	QQQ	ETF	186.0	186.1	185.58	185.7	616872.0
2018-10-03 17:00:00	QQQ	ETF	185.68	185.8	185.6	185.7	11617.0
2018-10-03 18:00:00	QQQ	ETF	185.7	185.7	185.53	185.61	40562.0
2018-10-03 19:00:00	QQQ	ETF	185.6	185.63	185.52	185.58	47581.0
2018-10-03 04:00:00	IWM	ETF	165.0	165.1	165.0	165.04	1500.0
2018-10-03 05:00:00	IWM	ETF	164.99	165.05	164.94	165.05	800.0
2018-10-03 06:00:00	IWM	ETF	165.05	165.1	165.02	165.08	15100.0
2018-10-03 07:00:00	IWM	ETF	165.16	165.29	165.16	165.28	38291.0
2018-10-03 08:00:00	IWM	ETF	164.53	165.31	164.53	165.2	58084.0
2018-10-03 09:00:00	IWM	ETF	165.21	165.34	164.53	164.53	2765550.0
2018-10-03 10:00:00	IWM	ETF	164.55	165.48	164.51	164.92	4086289.0
2018-10-03 11:00:00	IWM	ETF	164.92	165.75	164.83	165.69	2333218.0
2018-10-03 12:00:00	IWM	ETF	165.69	166.485	165.57	166.245	3496472.0
2018-10-03 13:00:00	IWM	ETF	166.24	166.53	166.15	166.4299	1599983.0
2018-10-03 14:00:00	IWM	ETF	166.43	166.73	165.86	166.17	3204343.0
2018-10-03 15:00:00	IWM	ETF	166.18	166.26	165.72	165.99	3540539.0
2018-10-03 16:00:00	IWM	ETF	166.0	166.4	165.91	165.96	705696.0
2018-10-03 17:00:00	IWM	ETF	166.02	166.04	165.82	165.82	4739.0
2018-10-03 18:00:00	IWM	ETF	165.91	165.97	165.81	165.89	8239.0
2018-10-03 19:00:00	IWM	ETF	165.88	165.94	165.87	165.94	8900.0
2018-10-03 04:00:00	DIA	ETF	268.21	268.21	268.1	268.17	1000.0
2018-10-03 05:00:00	DIA	ETF	268.11	268.11	268.11	268.11	500.0

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

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