PREVIEW / etf_1hour / 2018-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-02.parquet
  size:    292 KB
  rows:    9,674

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-05-02 04:00:00	SPY	ETF	265.2	265.44	265.2	265.33	9135.0
2018-05-02 05:00:00	SPY	ETF	265.45	265.65	265.45	265.5	4742.0
2018-05-02 06:00:00	SPY	ETF	265.41	265.42	264.97	265.36	20247.0
2018-05-02 07:00:00	SPY	ETF	265.33	265.58	265.07	265.07	109885.0
2018-05-02 08:00:00	SPY	ETF	265.2299	265.4	264.68	264.84	292841.0
2018-05-02 09:00:00	SPY	ETF	264.85	264.94	264.09	264.14	6086270.0
2018-05-02 10:00:00	SPY	ETF	264.15	264.765	264.06	264.49	9277178.0
2018-05-02 11:00:00	SPY	ETF	264.49	264.9	263.87	264.18	10418564.0
2018-05-02 12:00:00	SPY	ETF	264.17	264.66	264.01	264.525	4157385.0
2018-05-02 13:00:00	SPY	ETF	264.51	264.99	264.51	264.79	3298807.0
2018-05-02 14:00:00	SPY	ETF	264.82	265.68	264.39	264.54	11412204.0
2018-05-02 15:00:00	SPY	ETF	264.55	264.8363	262.76	263.2	24910817.0
2018-05-02 16:00:00	SPY	ETF	263.2	263.2	262.35	262.48	13784280.0
2018-05-02 17:00:00	SPY	ETF	262.46	263.2	262.44	262.55	284035.0
2018-05-02 18:00:00	SPY	ETF	262.56	263.17	262.42	262.9	755417.0
2018-05-02 19:00:00	SPY	ETF	262.84	262.86	262.67	262.71	43355.0
2018-05-02 04:00:00	QQQ	ETF	163.61	163.61	163.4	163.49	4775.0
2018-05-02 05:00:00	QQQ	ETF	163.46	163.75	163.46	163.63	23878.0
2018-05-02 06:00:00	QQQ	ETF	163.64	163.64	163.18	163.42	9800.0
2018-05-02 07:00:00	QQQ	ETF	163.4	163.62	163.23	163.24	114049.0
2018-05-02 08:00:00	QQQ	ETF	163.3899	163.46	162.84	163.1	258875.0
2018-05-02 09:00:00	QQQ	ETF	163.11	163.2	162.23	162.68	3993461.0
2018-05-02 10:00:00	QQQ	ETF	162.7	163.29	162.55	162.66	4431431.0
2018-05-02 11:00:00	QQQ	ETF	162.69	163.045	161.89	162.245	3277849.0
2018-05-02 12:00:00	QQQ	ETF	162.24	162.63	162.08	162.51	2809469.0
2018-05-02 13:00:00	QQQ	ETF	162.51	162.91	162.51	162.7834	1756554.0
2018-05-02 14:00:00	QQQ	ETF	162.8	163.57	162.49	162.68	5777545.0
2018-05-02 15:00:00	QQQ	ETF	162.69	163.01	161.63	161.81	6906973.0
2018-05-02 16:00:00	QQQ	ETF	161.82	161.84	161.32	161.38	2064671.0
2018-05-02 17:00:00	QQQ	ETF	161.54	163.15	161.43	161.5	109218.0
2018-05-02 18:00:00	QQQ	ETF	161.45	161.7	161.4	161.64	24687.0
2018-05-02 19:00:00	QQQ	ETF	161.61	161.63	161.48	161.55	22771.0
2018-05-02 06:00:00	IWM	ETF	154.16	154.19	154.16	154.19	2600.0
2018-05-02 07:00:00	IWM	ETF	154.29	154.4	154.21	154.21	2197.0
2018-05-02 08:00:00	IWM	ETF	154.24	154.29	153.79	153.88	24496.0
2018-05-02 09:00:00	IWM	ETF	153.81	154.3	153.66	154.1	1412482.0
2018-05-02 10:00:00	IWM	ETF	154.11	155.1	154.03	154.99	2423712.0
2018-05-02 11:00:00	IWM	ETF	155.0	155.23	154.59	154.9	1519219.0
2018-05-02 12:00:00	IWM	ETF	154.89	155.08	154.83	155.02	576591.0
2018-05-02 13:00:00	IWM	ETF	155.01	155.2359	154.965	155.2	789926.0
2018-05-02 14:00:00	IWM	ETF	155.16	155.78	155.14	155.31	2276788.0
2018-05-02 15:00:00	IWM	ETF	155.32	155.49	154.44	154.64	3685612.0
2018-05-02 16:00:00	IWM	ETF	154.63	154.74	154.15	154.15	1134751.0
2018-05-02 17:00:00	IWM	ETF	154.2	154.32	154.2	154.26	1473.0
2018-05-02 18:00:00	IWM	ETF	154.25	154.45	154.25	154.45	12633.0
2018-05-02 19:00:00	IWM	ETF	154.36	154.4	154.36	154.39	2069.0
2018-05-02 04:00:00	DIA	ETF	240.8	240.8	240.8	240.8	600.0
2018-05-02 05:00:00	DIA	ETF	241.52	241.52	241.52	241.52	100.0
2018-05-02 07:00:00	DIA	ETF	241.49	241.54	241.25	241.25	17209.0
2018-05-02 08:00:00	DIA	ETF	241.21	241.25	240.57	240.57	27613.0

> showing 50 of 9,674 rows — these rows as CSV

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