PREVIEW / etf_5min / 2019-12-16

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-12-16.parquet
  size:    1.5 MB
  rows:    65,603

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-12-16 04:00:00	SPY	ETF	318.41	318.57	318.41	318.53	6882.0
2019-12-16 04:05:00	SPY	ETF	318.53	318.53	318.42	318.45	6930.0
2019-12-16 04:10:00	SPY	ETF	318.42	318.51	318.42	318.49	9900.0
2019-12-16 04:15:00	SPY	ETF	318.49	318.52	318.49	318.49	4802.0
2019-12-16 04:20:00	SPY	ETF	318.47	318.5	318.45	318.5	1868.0
2019-12-16 04:25:00	SPY	ETF	318.46	318.55	318.46	318.52	5430.0
2019-12-16 04:30:00	SPY	ETF	318.42	318.46	318.4	318.46	2038.0
2019-12-16 04:35:00	SPY	ETF	318.45	318.5	318.45	318.5	900.0
2019-12-16 04:40:00	SPY	ETF	318.5	318.6	318.5	318.6	3800.0
2019-12-16 04:45:00	SPY	ETF	318.6	318.6	318.56	318.57	11700.0
2019-12-16 04:50:00	SPY	ETF	318.57	318.57	318.53	318.53	2900.0
2019-12-16 04:55:00	SPY	ETF	318.57	318.59	318.54	318.54	3560.0
2019-12-16 05:00:00	SPY	ETF	318.55	318.55	318.54	318.55	8750.0
2019-12-16 05:05:00	SPY	ETF	318.55	318.58	318.55	318.57	5110.0
2019-12-16 05:10:00	SPY	ETF	318.52	318.52	318.47	318.47	1450.0
2019-12-16 05:15:00	SPY	ETF	318.42	318.43	318.4	318.4	1300.0
2019-12-16 05:20:00	SPY	ETF	318.38	318.47	318.38	318.47	5476.0
2019-12-16 05:25:00	SPY	ETF	318.5	318.5	318.49	318.49	4582.0
2019-12-16 05:30:00	SPY	ETF	318.55	318.55	318.55	318.55	300.0
2019-12-16 05:35:00	SPY	ETF	318.55	318.6	318.55	318.55	2736.0
2019-12-16 05:40:00	SPY	ETF	318.55	318.61	318.55	318.58	1120.0
2019-12-16 05:45:00	SPY	ETF	318.46	318.48	318.4	318.4	4402.0
2019-12-16 05:50:00	SPY	ETF	318.43	318.43	318.36	318.41	5620.0
2019-12-16 05:55:00	SPY	ETF	318.45	318.47	318.45	318.46	620.0
2019-12-16 06:00:00	SPY	ETF	318.48	318.55	318.48	318.55	1200.0
2019-12-16 06:05:00	SPY	ETF	318.56	318.73	318.53	318.61	6920.0
2019-12-16 06:15:00	SPY	ETF	318.7	318.73	318.7	318.73	800.0
2019-12-16 06:20:00	SPY	ETF	318.68	318.69	318.67	318.69	6500.0
2019-12-16 06:25:00	SPY	ETF	318.69	318.69	318.63	318.66	1420.0
2019-12-16 06:30:00	SPY	ETF	318.64	318.64	318.64	318.64	350.0
2019-12-16 06:35:00	SPY	ETF	318.64	318.65	318.64	318.64	512.0
2019-12-16 06:40:00	SPY	ETF	318.69	318.75	318.69	318.75	3806.0
2019-12-16 06:45:00	SPY	ETF	318.69	318.79	318.69	318.79	3670.0
2019-12-16 06:50:00	SPY	ETF	318.8	318.8	318.67	318.7	9256.0
2019-12-16 06:55:00	SPY	ETF	318.67	318.72	318.61	318.61	4320.0
2019-12-16 07:00:00	SPY	ETF	318.61	318.69	318.61	318.63	12321.0
2019-12-16 07:05:00	SPY	ETF	318.63	318.67	318.62	318.66	19323.0
2019-12-16 07:10:00	SPY	ETF	318.67	318.72	318.67	318.72	11299.0
2019-12-16 07:15:00	SPY	ETF	318.71	318.76	318.68	318.76	10575.0
2019-12-16 07:20:00	SPY	ETF	318.73	318.82	318.73	318.79	31120.0
2019-12-16 07:25:00	SPY	ETF	318.77	318.79	318.72	318.79	5684.0
2019-12-16 07:30:00	SPY	ETF	318.79	318.87	318.75	318.76	23445.0
2019-12-16 07:35:00	SPY	ETF	318.8	318.83	318.78	318.8	9492.0
2019-12-16 07:40:00	SPY	ETF	318.8	318.95	318.8	318.8	12154.0
2019-12-16 07:45:00	SPY	ETF	318.79	318.93	318.78	318.93	11475.0
2019-12-16 07:50:00	SPY	ETF	318.87	318.91	318.87	318.91	5932.0
2019-12-16 07:55:00	SPY	ETF	318.92	318.92	318.92	318.92	550.0
2019-12-16 08:00:00	SPY	ETF	318.95	319.0	318.3	318.99	24897.0
2019-12-16 08:05:00	SPY	ETF	319.0	319.0	318.92	318.95	14743.0
2019-12-16 08:10:00	SPY	ETF	318.95	319.0	318.93	319.0	12598.0

> showing 50 of 65,603 rows — these rows as CSV

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