PREVIEW / etf_5min / 2018-03-23

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-03-23.parquet
  size:    1.5 MB
  rows:    62,768

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-03-23 04:00:00	SPY	ETF	263.39	263.86	263.3	263.37	11235.0
2018-03-23 04:05:00	SPY	ETF	263.49	263.52	263.24	263.38	7002.0
2018-03-23 04:10:00	SPY	ETF	263.47	263.53	263.27	263.27	1325.0
2018-03-23 04:15:00	SPY	ETF	263.17	263.17	263.01	263.16	2285.0
2018-03-23 04:20:00	SPY	ETF	263.16	263.21	262.97	263.0	4700.0
2018-03-23 04:25:00	SPY	ETF	262.89	262.89	262.79	262.79	3301.0
2018-03-23 04:30:00	SPY	ETF	262.86	262.86	262.86	262.86	1100.0
2018-03-23 04:35:00	SPY	ETF	262.56	262.79	262.56	262.7	6525.0
2018-03-23 04:40:00	SPY	ETF	262.5	262.65	262.47	262.65	1400.0
2018-03-23 04:45:00	SPY	ETF	262.43	262.66	262.43	262.45	3100.0
2018-03-23 04:50:00	SPY	ETF	262.5	262.5	262.45	262.45	800.0
2018-03-23 04:55:00	SPY	ETF	262.45	262.56	262.45	262.56	1132.0
2018-03-23 05:00:00	SPY	ETF	262.5	262.66	262.5	262.62	3200.0
2018-03-23 05:05:00	SPY	ETF	262.5	262.71	262.35	262.71	4033.0
2018-03-23 05:10:00	SPY	ETF	262.55	262.55	262.23	262.23	903.0
2018-03-23 05:15:00	SPY	ETF	262.15	262.48	262.15	262.41	6160.0
2018-03-23 05:20:00	SPY	ETF	262.37	262.37	262.07	262.07	1600.0
2018-03-23 05:25:00	SPY	ETF	262.07	262.18	261.99	261.99	7478.0
2018-03-23 05:30:00	SPY	ETF	261.99	262.11	261.97	262.11	3132.0
2018-03-23 05:35:00	SPY	ETF	262.1	262.1	261.89	262.03	6199.0
2018-03-23 05:40:00	SPY	ETF	262.0	262.0	261.82	261.87	7321.0
2018-03-23 05:45:00	SPY	ETF	261.87	261.9	261.8	261.8	6187.0
2018-03-23 05:50:00	SPY	ETF	261.79	261.8	261.66	261.79	2934.0
2018-03-23 05:55:00	SPY	ETF	261.74	261.9	261.74	261.86	8888.0
2018-03-23 06:00:00	SPY	ETF	261.84	261.95	261.76	261.95	2475.0
2018-03-23 06:05:00	SPY	ETF	261.84	261.84	261.63	261.73	2948.0
2018-03-23 06:10:00	SPY	ETF	261.69	262.29	261.69	262.29	8506.0
2018-03-23 06:15:00	SPY	ETF	262.26	262.33	262.09	262.25	25888.0
2018-03-23 06:20:00	SPY	ETF	262.25	262.26	262.0	262.0	3273.0
2018-03-23 06:25:00	SPY	ETF	261.96	262.3	261.92	262.29	2770.0
2018-03-23 06:30:00	SPY	ETF	262.33	262.55	262.33	262.55	7700.0
2018-03-23 06:35:00	SPY	ETF	262.55	262.67	262.52	262.66	16323.0
2018-03-23 06:40:00	SPY	ETF	262.7	262.78	262.61	262.69	5287.0
2018-03-23 06:45:00	SPY	ETF	262.73	262.85	262.61	262.85	8342.0
2018-03-23 06:50:00	SPY	ETF	262.87	262.89	262.73	262.73	9169.0
2018-03-23 06:55:00	SPY	ETF	262.73	262.9	262.6	262.85	6225.0
2018-03-23 07:00:00	SPY	ETF	262.88	262.96	262.73	262.95	15293.0
2018-03-23 07:05:00	SPY	ETF	262.97	263.06	262.89	262.95	49001.0
2018-03-23 07:10:00	SPY	ETF	262.9	262.92	262.64	262.92	19110.0
2018-03-23 07:15:00	SPY	ETF	262.88	262.97	262.87	262.9	11032.0
2018-03-23 07:20:00	SPY	ETF	262.97	263.06	262.91	263.02	11995.0
2018-03-23 07:25:00	SPY	ETF	263.0	263.0	262.85	262.85	7477.0
2018-03-23 07:30:00	SPY	ETF	262.8	262.86	262.68	262.8	45433.0
2018-03-23 07:35:00	SPY	ETF	262.86	263.07	262.82	262.84	21815.0
2018-03-23 07:40:00	SPY	ETF	262.9	262.93	262.8	262.82	40564.0
2018-03-23 07:45:00	SPY	ETF	262.82	263.26	262.77	263.26	105893.0
2018-03-23 07:50:00	SPY	ETF	263.23	263.33	263.14	263.33	84342.0
2018-03-23 07:55:00	SPY	ETF	263.3	263.56	263.25	263.52	59192.0
2018-03-23 08:00:00	SPY	ETF	263.5	264.13	261.72	264.12	919163.0
2018-03-23 08:05:00	SPY	ETF	264.12	264.3	263.93	264.15	276339.0

> showing 50 of 62,768 rows — these rows as CSV

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