PREVIEW / etf_1hour / 2018-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-02.parquet
  size:    316 KB
  rows:    10,359

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-02 04:00:00	SPY	ETF	291.33	291.33	290.69	290.8	16100.0
2018-10-02 05:00:00	SPY	ETF	290.6	290.82	290.54	290.75	7252.0
2018-10-02 06:00:00	SPY	ETF	290.86	291.15	290.81	291.15	24584.0
2018-10-02 07:00:00	SPY	ETF	291.17	291.27	290.94	291.22	118789.0
2018-10-02 08:00:00	SPY	ETF	291.73	291.73	291.02	291.4	241476.0
2018-10-02 09:00:00	SPY	ETF	291.41	291.84	291.35	291.7	4490186.0
2018-10-02 10:00:00	SPY	ETF	291.7	291.92	291.16	291.665	5911067.0
2018-10-02 11:00:00	SPY	ETF	291.67	292.26	291.62	292.21	4252750.0
2018-10-02 12:00:00	SPY	ETF	292.215	292.355	291.86	291.98	4591798.0
2018-10-02 13:00:00	SPY	ETF	291.97	292.31	291.96	292.16	3172959.0
2018-10-02 14:00:00	SPY	ETF	292.16	292.33	291.77	291.84	4434924.0
2018-10-02 15:00:00	SPY	ETF	291.84	291.84	291.14	291.57	13786825.0
2018-10-02 16:00:00	SPY	ETF	291.58	291.74	291.5439	291.74	3348810.0
2018-10-02 17:00:00	SPY	ETF	291.72	291.82	291.69	291.71	41977.0
2018-10-02 18:00:00	SPY	ETF	291.7	291.73	291.63	291.63	51401.0
2018-10-02 19:00:00	SPY	ETF	291.65	291.69	291.55	291.62	37226.0
2018-10-02 04:00:00	QQQ	ETF	185.99	185.99	185.24	185.35	17139.0
2018-10-02 05:00:00	QQQ	ETF	185.27	185.34	185.21	185.34	6057.0
2018-10-02 06:00:00	QQQ	ETF	185.4	185.65	185.4	185.64	15244.0
2018-10-02 07:00:00	QQQ	ETF	185.64	185.77	185.41	185.65	115598.0
2018-10-02 08:00:00	QQQ	ETF	185.68	185.92	185.47	185.77	118471.0
2018-10-02 09:00:00	QQQ	ETF	185.77	186.45	185.32	186.38	4180807.0
2018-10-02 10:00:00	QQQ	ETF	186.38	186.79	185.94	186.57	3880395.0
2018-10-02 11:00:00	QQQ	ETF	186.56	187.075	186.42	187.03	2627355.0
2018-10-02 12:00:00	QQQ	ETF	187.03	187.175	186.32	186.4555	2297848.0
2018-10-02 13:00:00	QQQ	ETF	186.45	186.7384	186.39	186.45	1342959.0
2018-10-02 14:00:00	QQQ	ETF	186.45	186.6	186.0316	186.1	2136196.0
2018-10-02 15:00:00	QQQ	ETF	186.09	186.09	185.33	185.75	6346985.0
2018-10-02 16:00:00	QQQ	ETF	185.75	186.8107	185.6	185.82	1003496.0
2018-10-02 17:00:00	QQQ	ETF	185.7	185.95	185.7	185.8	27842.0
2018-10-02 18:00:00	QQQ	ETF	185.77	185.83	185.73	185.82	31129.0
2018-10-02 19:00:00	QQQ	ETF	185.78	185.83	185.64	185.71	43549.0
2018-10-02 04:00:00	IWM	ETF	165.92	165.92	165.91	165.91	5000.0
2018-10-02 05:00:00	IWM	ETF	165.84	165.84	165.84	165.84	300.0
2018-10-02 06:00:00	IWM	ETF	165.99	166.16	165.99	166.16	2902.0
2018-10-02 07:00:00	IWM	ETF	166.22	166.22	166.08	166.14	21063.0
2018-10-02 08:00:00	IWM	ETF	166.33	166.33	166.04	166.05	81973.0
2018-10-02 09:00:00	IWM	ETF	166.05	166.53	165.96	166.0701	2821749.0
2018-10-02 10:00:00	IWM	ETF	166.09	166.1	165.11	165.27	3729583.0
2018-10-02 11:00:00	IWM	ETF	165.27	165.65	164.915	165.55	3063177.0
2018-10-02 12:00:00	IWM	ETF	165.55	165.63	164.9699	165.14	2504302.0
2018-10-02 13:00:00	IWM	ETF	165.13	165.2799	165.04	165.11	1267212.0
2018-10-02 14:00:00	IWM	ETF	165.11	165.19	164.64	164.71	2211746.0
2018-10-02 15:00:00	IWM	ETF	164.7	164.7	164.18	164.57	6109182.0
2018-10-02 16:00:00	IWM	ETF	164.58	166.1875	164.4963	164.67	2434012.0
2018-10-02 17:00:00	IWM	ETF	164.6	164.67	164.57	164.66	1700.0
2018-10-02 18:00:00	IWM	ETF	164.62	164.76	164.53	164.75	8660.0
2018-10-02 19:00:00	IWM	ETF	164.61	164.67	164.6	164.65	4607.0
2018-10-02 04:00:00	DIA	ETF	265.88	265.88	265.79	265.79	600.0
2018-10-02 05:00:00	DIA	ETF	265.42	265.42	265.42	265.42	100.0

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

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