PREVIEW / etf_5min / 2018-08-10

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-08-10.parquet
  size:    1.3 MB
  rows:    57,226

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-08-10 04:00:00	SPY	ETF	284.02	284.09	283.68	283.84	34874.0
2018-08-10 04:05:00	SPY	ETF	283.86	283.93	283.8	283.81	4389.0
2018-08-10 04:10:00	SPY	ETF	283.78	283.78	283.75	283.75	1002.0
2018-08-10 04:15:00	SPY	ETF	283.86	283.89	283.83	283.89	1429.0
2018-08-10 04:20:00	SPY	ETF	283.9	283.91	283.87	283.91	6430.0
2018-08-10 04:25:00	SPY	ETF	283.83	283.85	283.8	283.81	3200.0
2018-08-10 04:35:00	SPY	ETF	283.95	283.99	283.95	283.99	800.0
2018-08-10 04:40:00	SPY	ETF	283.83	283.87	283.83	283.85	1232.0
2018-08-10 04:45:00	SPY	ETF	283.82	283.82	283.82	283.82	300.0
2018-08-10 04:50:00	SPY	ETF	283.68	283.74	283.68	283.74	3600.0
2018-08-10 04:55:00	SPY	ETF	283.69	283.8	283.69	283.78	15800.0
2018-08-10 05:00:00	SPY	ETF	283.75	283.75	283.75	283.75	880.0
2018-08-10 05:05:00	SPY	ETF	283.9	283.93	283.9	283.93	1550.0
2018-08-10 05:10:00	SPY	ETF	284.0	284.0	284.0	284.0	100.0
2018-08-10 05:15:00	SPY	ETF	283.98	284.08	283.98	283.99	4502.0
2018-08-10 05:20:00	SPY	ETF	283.9	283.9	283.86	283.88	402.0
2018-08-10 05:25:00	SPY	ETF	283.85	283.85	283.85	283.85	2000.0
2018-08-10 05:30:00	SPY	ETF	283.88	283.93	283.88	283.92	2000.0
2018-08-10 05:35:00	SPY	ETF	283.88	283.88	283.88	283.88	200.0
2018-08-10 05:40:00	SPY	ETF	283.83	283.83	283.67	283.7	3937.0
2018-08-10 05:45:00	SPY	ETF	283.71	283.73	283.62	283.62	3800.0
2018-08-10 05:50:00	SPY	ETF	283.61	283.61	283.58	283.58	4460.0
2018-08-10 05:55:00	SPY	ETF	283.56	283.56	283.4	283.49	15107.0
2018-08-10 06:00:00	SPY	ETF	283.56	283.56	283.48	283.51	7291.0
2018-08-10 06:05:00	SPY	ETF	283.58	283.59	283.56	283.58	6100.0
2018-08-10 06:10:00	SPY	ETF	283.56	283.64	283.56	283.64	1952.0
2018-08-10 06:15:00	SPY	ETF	283.69	283.71	283.69	283.69	1100.0
2018-08-10 06:20:00	SPY	ETF	283.73	283.84	283.73	283.84	2752.0
2018-08-10 06:25:00	SPY	ETF	283.86	283.89	283.83	283.89	3250.0
2018-08-10 06:30:00	SPY	ETF	283.88	283.88	283.86	283.86	1500.0
2018-08-10 06:35:00	SPY	ETF	283.9	283.9	283.88	283.88	1357.0
2018-08-10 06:40:00	SPY	ETF	283.88	283.95	283.88	283.93	2502.0
2018-08-10 06:45:00	SPY	ETF	283.98	283.98	283.92	283.92	2700.0
2018-08-10 06:50:00	SPY	ETF	283.88	283.89	283.88	283.88	2450.0
2018-08-10 06:55:00	SPY	ETF	283.88	283.95	283.8	283.95	6738.0
2018-08-10 07:00:00	SPY	ETF	283.95	283.99	283.84	283.89	25685.0
2018-08-10 07:05:00	SPY	ETF	283.87	283.91	283.85	283.85	12153.0
2018-08-10 07:10:00	SPY	ETF	283.85	283.87	283.82	283.85	19962.0
2018-08-10 07:15:00	SPY	ETF	283.83	283.9	283.82	283.82	15012.0
2018-08-10 07:20:00	SPY	ETF	283.84	284.0	283.82	284.0	26913.0
2018-08-10 07:25:00	SPY	ETF	283.98	283.98	283.94	283.94	2385.0
2018-08-10 07:30:00	SPY	ETF	283.95	283.97	283.95	283.97	14566.0
2018-08-10 07:35:00	SPY	ETF	283.98	283.98	283.89	283.91	33847.0
2018-08-10 07:40:00	SPY	ETF	283.9	283.95	283.89	283.9	9850.0
2018-08-10 07:45:00	SPY	ETF	283.93	283.93	283.87	283.87	11200.0
2018-08-10 07:50:00	SPY	ETF	283.9	283.91	283.83	283.91	23125.0
2018-08-10 07:55:00	SPY	ETF	283.89	283.89	283.75	283.77	14329.0
2018-08-10 08:00:00	SPY	ETF	283.77	284.09	283.57	283.57	171860.0
2018-08-10 08:05:00	SPY	ETF	283.58	283.65	283.58	283.63	33275.0
2018-08-10 08:10:00	SPY	ETF	283.64	283.86	283.63	283.84	109303.0

> showing 50 of 57,226 rows — these rows as CSV

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