PREVIEW / etf_5min / 2020-01-17

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-01-17.parquet
  size:    1.5 MB
  rows:    66,594

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
2020-01-17 04:00:00	SPY	ETF	331.4	331.46	331.4	331.46	703.0
2020-01-17 04:05:00	SPY	ETF	331.43	331.43	331.42	331.42	200.0
2020-01-17 04:10:00	SPY	ETF	331.5	331.54	331.5	331.54	400.0
2020-01-17 04:15:00	SPY	ETF	331.55	331.55	331.55	331.55	201.0
2020-01-17 04:25:00	SPY	ETF	331.54	331.54	331.54	331.54	400.0
2020-01-17 04:30:00	SPY	ETF	331.51	331.51	331.51	331.51	266.0
2020-01-17 04:35:00	SPY	ETF	331.47	331.48	331.47	331.48	500.0
2020-01-17 04:45:00	SPY	ETF	331.47	331.47	331.47	331.47	2500.0
2020-01-17 04:50:00	SPY	ETF	331.58	331.58	331.58	331.58	701.0
2020-01-17 04:55:00	SPY	ETF	331.59	331.59	331.59	331.59	100.0
2020-01-17 05:05:00	SPY	ETF	331.69	331.69	331.69	331.69	225.0
2020-01-17 05:10:00	SPY	ETF	331.66	331.66	331.66	331.66	2005.0
2020-01-17 05:15:00	SPY	ETF	331.75	331.89	331.75	331.89	2500.0
2020-01-17 05:20:00	SPY	ETF	331.79	331.79	331.74	331.74	1400.0
2020-01-17 05:30:00	SPY	ETF	331.61	331.61	331.61	331.61	200.0
2020-01-17 05:40:00	SPY	ETF	331.64	331.65	331.64	331.65	350.0
2020-01-17 05:50:00	SPY	ETF	331.67	331.67	331.67	331.67	300.0
2020-01-17 05:55:00	SPY	ETF	331.65	331.65	331.6	331.6	1100.0
2020-01-17 06:00:00	SPY	ETF	331.63	331.63	331.63	331.63	220.0
2020-01-17 06:05:00	SPY	ETF	331.64	331.66	331.64	331.66	360.0
2020-01-17 06:10:00	SPY	ETF	331.64	331.64	331.51	331.51	1600.0
2020-01-17 06:15:00	SPY	ETF	331.6	331.61	331.6	331.6	1130.0
2020-01-17 06:20:00	SPY	ETF	331.6	331.6	331.6	331.6	105.0
2020-01-17 06:25:00	SPY	ETF	331.66	331.66	331.63	331.66	406.0
2020-01-17 06:30:00	SPY	ETF	331.6	331.6	331.6	331.6	5000.0
2020-01-17 06:40:00	SPY	ETF	331.69	331.69	331.6	331.66	6565.0
2020-01-17 06:45:00	SPY	ETF	331.66	331.66	331.6	331.66	2310.0
2020-01-17 06:50:00	SPY	ETF	331.6	331.63	331.6	331.63	1846.0
2020-01-17 06:55:00	SPY	ETF	331.63	331.67	331.63	331.66	2167.0
2020-01-17 07:00:00	SPY	ETF	331.65	331.69	331.6	331.6	18117.0
2020-01-17 07:05:00	SPY	ETF	331.58	331.6	331.58	331.6	16197.0
2020-01-17 07:10:00	SPY	ETF	331.61	331.64	331.61	331.64	2030.0
2020-01-17 07:15:00	SPY	ETF	331.61	331.62	331.52	331.53	17927.0
2020-01-17 07:20:00	SPY	ETF	331.57	331.57	331.49	331.57	15378.0
2020-01-17 07:25:00	SPY	ETF	331.5	331.56	331.5	331.56	949.0
2020-01-17 07:30:00	SPY	ETF	331.55	331.58	331.54	331.58	6978.0
2020-01-17 07:35:00	SPY	ETF	331.55	331.55	331.53	331.54	16551.0
2020-01-17 07:40:00	SPY	ETF	331.49	331.49	331.49	331.49	455.0
2020-01-17 07:45:00	SPY	ETF	331.49	331.49	331.44	331.45	26172.0
2020-01-17 07:50:00	SPY	ETF	331.49	331.49	331.44	331.44	1044.0
2020-01-17 07:55:00	SPY	ETF	331.5	331.52	331.48	331.52	2552.0
2020-01-17 08:00:00	SPY	ETF	331.61	331.66	330.93	331.57	14702.0
2020-01-17 08:05:00	SPY	ETF	331.58	331.66	331.58	331.64	25263.0
2020-01-17 08:10:00	SPY	ETF	331.64	331.64	331.55	331.58	19418.0
2020-01-17 08:15:00	SPY	ETF	331.56	331.56	331.54	331.54	3111.0
2020-01-17 08:20:00	SPY	ETF	331.58	331.6	331.56	331.59	9996.0
2020-01-17 08:25:00	SPY	ETF	331.62	331.64	331.6	331.64	14305.0
2020-01-17 08:30:00	SPY	ETF	331.65	331.77	331.65	331.73	37978.0
2020-01-17 08:35:00	SPY	ETF	331.73	331.87	331.73	331.85	33697.0
2020-01-17 08:40:00	SPY	ETF	331.8699	332.0	331.83	331.95	69876.0

> showing 50 of 66,594 rows — these rows as CSV

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