PREVIEW / etf_5min / 2018-05-04

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-05-04.parquet
  size:    1.3 MB
  rows:    54,615

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-04 04:00:00	SPY	ETF	262.96	263.18	262.96	263.06	1257.0
2018-05-04 04:05:00	SPY	ETF	263.12	263.12	262.96	263.0	1010.0
2018-05-04 04:10:00	SPY	ETF	263.07	263.1	263.07	263.1	700.0
2018-05-04 04:15:00	SPY	ETF	263.04	263.04	263.04	263.04	100.0
2018-05-04 04:20:00	SPY	ETF	262.94	262.94	262.9	262.91	2270.0
2018-05-04 04:25:00	SPY	ETF	262.89	262.89	262.85	262.85	500.0
2018-05-04 04:30:00	SPY	ETF	262.84	262.85	262.84	262.85	1350.0
2018-05-04 04:35:00	SPY	ETF	262.8	262.8	262.62	262.62	350.0
2018-05-04 04:40:00	SPY	ETF	262.6	262.6	262.6	262.6	451.0
2018-05-04 04:45:00	SPY	ETF	262.65	262.8	262.65	262.8	900.0
2018-05-04 04:50:00	SPY	ETF	262.8	262.8	262.8	262.8	501.0
2018-05-04 05:00:00	SPY	ETF	262.85	262.85	262.7	262.7	1120.0
2018-05-04 05:05:00	SPY	ETF	262.79	262.84	262.77	262.84	920.0
2018-05-04 05:10:00	SPY	ETF	262.76	262.76	262.67	262.67	700.0
2018-05-04 05:25:00	SPY	ETF	262.65	262.65	262.65	262.65	100.0
2018-05-04 05:30:00	SPY	ETF	262.51	262.54	262.51	262.54	1300.0
2018-05-04 05:35:00	SPY	ETF	262.54	262.54	262.54	262.54	700.0
2018-05-04 05:45:00	SPY	ETF	262.65	262.65	262.65	262.65	100.0
2018-05-04 05:50:00	SPY	ETF	262.75	262.75	262.7	262.75	700.0
2018-05-04 05:55:00	SPY	ETF	262.79	262.87	262.79	262.87	200.0
2018-05-04 06:00:00	SPY	ETF	262.85	263.01	262.85	263.01	1400.0
2018-05-04 06:10:00	SPY	ETF	262.83	262.83	262.83	262.83	100.0
2018-05-04 06:15:00	SPY	ETF	262.9	263.01	262.89	263.01	1750.0
2018-05-04 06:20:00	SPY	ETF	262.79	262.81	262.79	262.79	24281.0
2018-05-04 06:25:00	SPY	ETF	262.79	262.79	262.77	262.77	16519.0
2018-05-04 06:30:00	SPY	ETF	262.73	262.73	262.67	262.68	1800.0
2018-05-04 06:40:00	SPY	ETF	262.7	262.73	262.67	262.67	1200.0
2018-05-04 06:45:00	SPY	ETF	262.66	262.66	262.49	262.49	3480.0
2018-05-04 06:50:00	SPY	ETF	262.51	262.53	262.51	262.51	2400.0
2018-05-04 06:55:00	SPY	ETF	262.48	262.54	262.48	262.54	1100.0
2018-05-04 07:00:00	SPY	ETF	262.53	262.61	262.49	262.55	2912.0
2018-05-04 07:05:00	SPY	ETF	262.58	262.62	262.53	262.58	6859.0
2018-05-04 07:10:00	SPY	ETF	262.53	262.53	262.43	262.43	1741.0
2018-05-04 07:15:00	SPY	ETF	262.5	262.54	262.5	262.54	205.0
2018-05-04 07:20:00	SPY	ETF	262.55	262.55	262.51	262.51	1349.0
2018-05-04 07:25:00	SPY	ETF	262.55	262.57	262.51	262.51	25500.0
2018-05-04 07:30:00	SPY	ETF	262.59	262.59	262.52	262.57	3329.0
2018-05-04 07:35:00	SPY	ETF	262.54	262.54	262.5	262.5	2232.0
2018-05-04 07:40:00	SPY	ETF	262.52	262.52	262.48	262.48	2070.0
2018-05-04 07:45:00	SPY	ETF	262.45	262.45	262.36	262.42	2961.0
2018-05-04 07:50:00	SPY	ETF	262.45	262.45	262.31	262.34	12322.0
2018-05-04 07:55:00	SPY	ETF	262.33	262.33	262.18	262.26	37259.0
2018-05-04 08:00:00	SPY	ETF	262.27	263.14	262.22	262.46	24964.0
2018-05-04 08:05:00	SPY	ETF	262.44	262.45	262.2	262.2	23386.0
2018-05-04 08:10:00	SPY	ETF	262.2	262.2	262.09	262.1	64255.0
2018-05-04 08:15:00	SPY	ETF	262.12	262.12	261.89	261.98	48038.0
2018-05-04 08:20:00	SPY	ETF	261.99	262.2	261.98	262.2	59773.0
2018-05-04 08:25:00	SPY	ETF	262.19	262.2	262.06	262.08	44300.0
2018-05-04 08:30:00	SPY	ETF	262.16	262.85	262.01	262.46	387017.0
2018-05-04 08:35:00	SPY	ETF	262.46	262.55	262.02	262.09	125753.0

> showing 50 of 54,615 rows — these rows as CSV

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