PREVIEW / etf_5min / 2019-01-29

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-01-29.parquet
  size:    1.4 MB
  rows:    62,214

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
2019-01-29 04:00:00	SPY	ETF	263.37	263.37	263.32	263.32	529.0
2019-01-29 04:05:00	SPY	ETF	263.45	263.45	263.36	263.36	580.0
2019-01-29 04:10:00	SPY	ETF	263.36	263.51	263.36	263.51	1010.0
2019-01-29 04:15:00	SPY	ETF	263.61	263.68	263.56	263.65	950.0
2019-01-29 04:20:00	SPY	ETF	263.56	263.56	263.53	263.53	1602.0
2019-01-29 04:25:00	SPY	ETF	263.53	263.53	263.53	263.53	908.0
2019-01-29 04:35:00	SPY	ETF	263.57	263.57	263.53	263.55	750.0
2019-01-29 04:40:00	SPY	ETF	263.4	263.45	263.4	263.45	350.0
2019-01-29 04:45:00	SPY	ETF	263.35	263.35	263.35	263.35	100.0
2019-01-29 04:50:00	SPY	ETF	263.4	263.4	263.4	263.4	110.0
2019-01-29 04:55:00	SPY	ETF	263.52	263.57	263.52	263.57	800.0
2019-01-29 05:00:00	SPY	ETF	263.57	263.57	263.45	263.45	350.0
2019-01-29 05:05:00	SPY	ETF	263.5	263.76	263.5	263.76	4103.0
2019-01-29 05:10:00	SPY	ETF	263.74	263.76	263.71	263.71	1000.0
2019-01-29 05:20:00	SPY	ETF	263.73	263.77	263.73	263.73	1800.0
2019-01-29 05:25:00	SPY	ETF	263.7	263.73	263.68	263.73	1050.0
2019-01-29 05:30:00	SPY	ETF	263.78	263.78	263.73	263.73	3300.0
2019-01-29 05:35:00	SPY	ETF	263.75	263.82	263.73	263.73	1761.0
2019-01-29 05:40:00	SPY	ETF	263.67	263.7	263.66	263.66	2755.0
2019-01-29 05:45:00	SPY	ETF	263.66	263.7	263.66	263.7	600.0
2019-01-29 05:50:00	SPY	ETF	263.67	263.67	263.67	263.67	310.0
2019-01-29 05:55:00	SPY	ETF	263.65	263.65	263.58	263.58	900.0
2019-01-29 06:00:00	SPY	ETF	263.62	263.62	263.58	263.58	550.0
2019-01-29 06:05:00	SPY	ETF	263.61	263.61	263.61	263.61	100.0
2019-01-29 06:15:00	SPY	ETF	263.57	263.62	263.57	263.62	500.0
2019-01-29 06:20:00	SPY	ETF	263.51	263.51	263.51	263.51	1010.0
2019-01-29 06:25:00	SPY	ETF	263.37	263.37	263.37	263.37	700.0
2019-01-29 06:30:00	SPY	ETF	263.42	263.55	263.42	263.53	4700.0
2019-01-29 06:35:00	SPY	ETF	263.49	263.56	263.49	263.53	2856.0
2019-01-29 06:40:00	SPY	ETF	263.62	263.62	263.58	263.58	1100.0
2019-01-29 06:45:00	SPY	ETF	263.55	263.56	263.55	263.56	2500.0
2019-01-29 06:55:00	SPY	ETF	263.66	263.83	263.64	263.81	4234.0
2019-01-29 07:00:00	SPY	ETF	263.81	263.85	263.72	263.78	28492.0
2019-01-29 07:05:00	SPY	ETF	263.81	263.83	263.76	263.82	2939.0
2019-01-29 07:10:00	SPY	ETF	263.87	263.87	263.79	263.8	3740.0
2019-01-29 07:15:00	SPY	ETF	263.8	263.82	263.74	263.82	5494.0
2019-01-29 07:20:00	SPY	ETF	263.85	263.87	263.7	263.7	16550.0
2019-01-29 07:25:00	SPY	ETF	263.71	263.71	263.65	263.67	20498.0
2019-01-29 07:30:00	SPY	ETF	263.66	263.7	263.65	263.68	9374.0
2019-01-29 07:35:00	SPY	ETF	263.71	263.83	263.7	263.83	5345.0
2019-01-29 07:40:00	SPY	ETF	263.79	263.85	263.75	263.85	35521.0
2019-01-29 07:45:00	SPY	ETF	263.89	264.12	263.89	264.09	26071.0
2019-01-29 07:50:00	SPY	ETF	264.03	264.15	264.03	264.08	28576.0
2019-01-29 07:55:00	SPY	ETF	264.06	264.06	263.98	264.02	4786.0
2019-01-29 08:00:00	SPY	ETF	263.76	264.08	262.85	264.04	15567.0
2019-01-29 08:05:00	SPY	ETF	264.04	264.05	263.98	264.0	17441.0
2019-01-29 08:10:00	SPY	ETF	264.05	264.1	263.96	263.96	18465.0
2019-01-29 08:15:00	SPY	ETF	263.95	264.01	263.94	263.98	17050.0
2019-01-29 08:20:00	SPY	ETF	264.01	264.24	263.96	264.24	53267.0
2019-01-29 08:25:00	SPY	ETF	264.21	264.21	264.09	264.09	19950.0

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

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