PREVIEW / etf_5min / 2019-07-26

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-26.parquet
  size:    1.3 MB
  rows:    58,550

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-07-26 04:00:00	SPY	ETF	300.33	300.6	300.33	300.6	1110.0
2019-07-26 04:05:00	SPY	ETF	300.63	300.63	300.6	300.6	2100.0
2019-07-26 04:20:00	SPY	ETF	300.61	300.61	300.55	300.55	400.0
2019-07-26 04:30:00	SPY	ETF	300.55	300.55	300.55	300.55	2000.0
2019-07-26 04:40:00	SPY	ETF	300.55	300.55	300.53	300.53	1567.0
2019-07-26 04:45:00	SPY	ETF	300.55	300.57	300.55	300.57	907.0
2019-07-26 04:50:00	SPY	ETF	300.55	300.57	300.53	300.57	1254.0
2019-07-26 05:00:00	SPY	ETF	300.52	300.52	300.52	300.52	325.0
2019-07-26 05:10:00	SPY	ETF	300.55	300.55	300.55	300.55	200.0
2019-07-26 05:20:00	SPY	ETF	300.68	300.72	300.68	300.7	638.0
2019-07-26 05:25:00	SPY	ETF	300.67	300.75	300.67	300.75	2376.0
2019-07-26 05:30:00	SPY	ETF	300.78	300.85	300.78	300.85	269.0
2019-07-26 05:35:00	SPY	ETF	300.82	300.82	300.82	300.82	169.0
2019-07-26 05:40:00	SPY	ETF	300.84	300.84	300.84	300.84	219.0
2019-07-26 05:45:00	SPY	ETF	300.92	300.92	300.9	300.9	469.0
2019-07-26 05:55:00	SPY	ETF	300.89	300.9	300.85	300.85	400.0
2019-07-26 06:00:00	SPY	ETF	300.95	300.95	300.95	300.95	126.0
2019-07-26 06:05:00	SPY	ETF	300.97	300.97	300.97	300.97	200.0
2019-07-26 06:10:00	SPY	ETF	300.92	300.95	300.92	300.95	500.0
2019-07-26 06:15:00	SPY	ETF	300.97	300.97	300.97	300.97	169.0
2019-07-26 06:20:00	SPY	ETF	300.95	300.97	300.95	300.97	1771.0
2019-07-26 06:25:00	SPY	ETF	300.97	301.0	300.97	301.0	1060.0
2019-07-26 06:30:00	SPY	ETF	300.92	300.92	300.91	300.91	19350.0
2019-07-26 06:35:00	SPY	ETF	300.91	300.99	300.91	300.99	7872.0
2019-07-26 06:40:00	SPY	ETF	300.89	300.89	300.89	300.89	220.0
2019-07-26 06:55:00	SPY	ETF	300.83	300.83	300.83	300.83	169.0
2019-07-26 07:00:00	SPY	ETF	300.82	300.84	300.76	300.84	6218.0
2019-07-26 07:05:00	SPY	ETF	300.79	300.79	300.74	300.79	4800.0
2019-07-26 07:10:00	SPY	ETF	300.78	300.8	300.78	300.8	5520.0
2019-07-26 07:15:00	SPY	ETF	300.78	300.78	300.78	300.78	678.0
2019-07-26 07:20:00	SPY	ETF	300.77	300.88	300.77	300.88	10930.0
2019-07-26 07:25:00	SPY	ETF	300.87	300.88	300.79	300.79	5874.0
2019-07-26 07:30:00	SPY	ETF	300.83	300.87	300.83	300.83	16200.0
2019-07-26 07:35:00	SPY	ETF	300.81	300.87	300.81	300.83	8289.0
2019-07-26 07:40:00	SPY	ETF	300.81	300.81	300.8	300.8	2530.0
2019-07-26 07:45:00	SPY	ETF	300.8	300.83	300.8	300.82	37830.0
2019-07-26 07:50:00	SPY	ETF	300.83	300.83	300.82	300.82	600.0
2019-07-26 07:55:00	SPY	ETF	300.78	300.82	300.76	300.8	42750.0
2019-07-26 08:00:00	SPY	ETF	300.82	300.82	300.37	300.82	8332.0
2019-07-26 08:05:00	SPY	ETF	300.79	300.86	300.4863	300.74	104471.0
2019-07-26 08:10:00	SPY	ETF	300.75	300.76	300.0	300.7	5230.0
2019-07-26 08:15:00	SPY	ETF	300.6399	300.67	300.6399	300.64	11525.0
2019-07-26 08:20:00	SPY	ETF	300.62	300.62	300.43	300.52	14251.0
2019-07-26 08:25:00	SPY	ETF	300.47	300.56	300.47	300.54	38358.0
2019-07-26 08:30:00	SPY	ETF	300.5	300.66	300.29	300.49	214214.0
2019-07-26 08:35:00	SPY	ETF	300.46	300.74	300.46	300.65	32562.0
2019-07-26 08:40:00	SPY	ETF	300.65	300.7	300.62	300.7	10221.0
2019-07-26 08:45:00	SPY	ETF	300.69	300.74	300.65	300.69	2525.0
2019-07-26 08:50:00	SPY	ETF	300.67	300.77	300.65	300.77	3177.0
2019-07-26 08:55:00	SPY	ETF	300.77	300.77	300.71	300.73	3550.0

> showing 50 of 58,550 rows — these rows as CSV

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