PREVIEW / etf_5min / 2018-03-20

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-03-20.parquet
  size:    1.3 MB
  rows:    55,532

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-20 04:00:00	SPY	ETF	271.21	271.21	271.16	271.16	1380.0
2018-03-20 04:10:00	SPY	ETF	271.24	271.24	271.24	271.24	300.0
2018-03-20 04:15:00	SPY	ETF	271.18	271.18	271.16	271.16	520.0
2018-03-20 04:20:00	SPY	ETF	271.25	271.25	271.22	271.22	500.0
2018-03-20 04:25:00	SPY	ETF	271.22	271.26	271.16	271.16	800.0
2018-03-20 04:30:00	SPY	ETF	271.13	271.13	270.97	270.97	14800.0
2018-03-20 04:35:00	SPY	ETF	271.01	271.08	270.98	271.08	13800.0
2018-03-20 04:40:00	SPY	ETF	271.05	271.11	271.05	271.11	8500.0
2018-03-20 04:45:00	SPY	ETF	271.05	271.05	271.04	271.05	5100.0
2018-03-20 04:50:00	SPY	ETF	271.25	271.26	271.21	271.26	900.0
2018-03-20 04:55:00	SPY	ETF	271.2	271.26	271.18	271.26	2800.0
2018-03-20 05:00:00	SPY	ETF	271.21	271.21	271.16	271.16	400.0
2018-03-20 05:05:00	SPY	ETF	270.98	270.98	270.9	270.91	10650.0
2018-03-20 05:10:00	SPY	ETF	270.87	270.87	270.61	270.61	23565.0
2018-03-20 05:15:00	SPY	ETF	270.68	270.7	270.65	270.66	2700.0
2018-03-20 05:20:00	SPY	ETF	270.73	270.73	270.73	270.73	500.0
2018-03-20 05:25:00	SPY	ETF	270.7	270.7	270.68	270.68	600.0
2018-03-20 05:30:00	SPY	ETF	270.65	270.68	270.65	270.68	800.0
2018-03-20 05:35:00	SPY	ETF	270.67	270.77	270.67	270.77	1300.0
2018-03-20 05:40:00	SPY	ETF	270.78	270.78	270.69	270.69	2750.0
2018-03-20 05:45:00	SPY	ETF	270.8	270.8	270.77	270.77	5630.0
2018-03-20 05:50:00	SPY	ETF	270.73	270.89	270.73	270.89	460.0
2018-03-20 05:55:00	SPY	ETF	270.89	270.92	270.86	270.87	3720.0
2018-03-20 06:00:00	SPY	ETF	270.77	270.98	270.76	270.98	6300.0
2018-03-20 06:05:00	SPY	ETF	270.97	270.97	270.97	270.97	100.0
2018-03-20 06:10:00	SPY	ETF	270.87	270.87	270.87	270.87	100.0
2018-03-20 06:15:00	SPY	ETF	271.1	271.18	271.1	271.18	6350.0
2018-03-20 06:20:00	SPY	ETF	271.17	271.17	270.93	271.05	3200.0
2018-03-20 06:25:00	SPY	ETF	270.93	271.1	270.93	271.04	3100.0
2018-03-20 06:30:00	SPY	ETF	271.04	271.04	271.04	271.04	250.0
2018-03-20 06:35:00	SPY	ETF	271.19	271.19	271.14	271.15	1180.0
2018-03-20 06:40:00	SPY	ETF	271.21	271.34	271.21	271.24	7600.0
2018-03-20 06:45:00	SPY	ETF	271.3	271.36	271.3	271.34	2230.0
2018-03-20 06:50:00	SPY	ETF	271.28	271.39	271.28	271.39	1225.0
2018-03-20 06:55:00	SPY	ETF	271.4	271.47	271.39	271.39	6520.0
2018-03-20 07:00:00	SPY	ETF	271.38	271.42	271.33	271.34	7665.0
2018-03-20 07:05:00	SPY	ETF	271.4	271.5	271.4	271.42	2853.0
2018-03-20 07:10:00	SPY	ETF	271.45	271.45	271.38	271.38	1300.0
2018-03-20 07:15:00	SPY	ETF	271.42	271.5	271.42	271.45	6956.0
2018-03-20 07:20:00	SPY	ETF	271.44	271.45	271.4	271.44	8400.0
2018-03-20 07:25:00	SPY	ETF	271.49	271.62	271.49	271.6	22146.0
2018-03-20 07:30:00	SPY	ETF	271.61	271.71	271.61	271.65	38478.0
2018-03-20 07:35:00	SPY	ETF	271.7	271.75	271.63	271.75	33418.0
2018-03-20 07:40:00	SPY	ETF	271.7	271.78	271.69	271.74	20444.0
2018-03-20 07:45:00	SPY	ETF	271.72	271.73	271.64	271.73	5761.0
2018-03-20 07:50:00	SPY	ETF	271.69	271.71	271.62	271.68	34164.0
2018-03-20 07:55:00	SPY	ETF	271.68	271.78	271.64	271.78	14407.0
2018-03-20 08:00:00	SPY	ETF	271.45	271.84	271.39	271.77	34504.0
2018-03-20 08:05:00	SPY	ETF	271.68	271.69	271.56	271.58	40885.0
2018-03-20 08:10:00	SPY	ETF	271.6	271.62	271.51	271.52	408157.0

> showing 50 of 55,532 rows — these rows as CSV

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