PREVIEW / etf_5min / 2020-08-05

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-08-05.parquet
  size:    1.6 MB
  rows:    76,023

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-08-05 04:00:00	SPY	ETF	331.85	331.87	331.79	331.79	2530.0
2020-08-05 04:05:00	SPY	ETF	331.74	331.74	331.63	331.64	1859.0
2020-08-05 04:10:00	SPY	ETF	331.66	331.69	331.63	331.67	11405.0
2020-08-05 04:15:00	SPY	ETF	331.62	331.67	331.46	331.46	661.0
2020-08-05 04:20:00	SPY	ETF	331.45	331.45	331.14	331.14	834.0
2020-08-05 04:30:00	SPY	ETF	331.16	331.16	331.0	331.0	1844.0
2020-08-05 04:40:00	SPY	ETF	331.21	331.4	331.21	331.34	4716.0
2020-08-05 04:45:00	SPY	ETF	331.4	331.57	331.39	331.51	4665.0
2020-08-05 04:50:00	SPY	ETF	331.67	331.8	331.67	331.8	3364.0
2020-08-05 04:55:00	SPY	ETF	331.81	331.86	331.77	331.81	3648.0
2020-08-05 05:00:00	SPY	ETF	331.82	331.82	331.76	331.76	270.0
2020-08-05 05:05:00	SPY	ETF	331.81	331.81	331.78	331.78	210.0
2020-08-05 05:10:00	SPY	ETF	331.74	331.74	331.74	331.74	1100.0
2020-08-05 05:15:00	SPY	ETF	331.95	332.0	331.67	331.67	2485.0
2020-08-05 05:25:00	SPY	ETF	331.76	331.76	331.76	331.76	100.0
2020-08-05 05:30:00	SPY	ETF	331.57	331.57	331.47	331.47	816.0
2020-08-05 05:35:00	SPY	ETF	331.71	331.72	331.63	331.67	2360.0
2020-08-05 05:40:00	SPY	ETF	331.74	331.79	331.71	331.79	714.0
2020-08-05 05:45:00	SPY	ETF	331.89	331.93	331.89	331.9	1312.0
2020-08-05 05:50:00	SPY	ETF	331.91	331.91	331.82	331.86	2357.0
2020-08-05 05:55:00	SPY	ETF	331.82	331.86	331.82	331.86	700.0
2020-08-05 06:00:00	SPY	ETF	331.98	332.1	331.82	331.82	4353.0
2020-08-05 06:05:00	SPY	ETF	331.86	331.86	331.79	331.79	2186.0
2020-08-05 06:10:00	SPY	ETF	331.85	331.85	331.85	331.85	200.0
2020-08-05 06:15:00	SPY	ETF	331.92	331.95	331.75	331.77	1392.0
2020-08-05 06:20:00	SPY	ETF	331.74	331.79	331.74	331.78	4000.0
2020-08-05 06:25:00	SPY	ETF	331.84	331.87	331.78	331.78	4356.0
2020-08-05 06:30:00	SPY	ETF	331.8	331.8	331.79	331.79	1360.0
2020-08-05 06:35:00	SPY	ETF	331.7	331.82	331.7	331.82	336.0
2020-08-05 06:40:00	SPY	ETF	331.88	331.91	331.88	331.89	1105.0
2020-08-05 06:45:00	SPY	ETF	331.84	331.84	331.71	331.72	3506.0
2020-08-05 06:50:00	SPY	ETF	331.72	331.84	331.69	331.84	4424.0
2020-08-05 06:55:00	SPY	ETF	331.9	331.95	331.9	331.95	1270.0
2020-08-05 07:00:00	SPY	ETF	331.81	331.81	331.68	331.77	9684.0
2020-08-05 07:05:00	SPY	ETF	331.77	331.91	331.72	331.91	9438.0
2020-08-05 07:10:00	SPY	ETF	331.91	331.94	331.85	331.9	4928.0
2020-08-05 07:15:00	SPY	ETF	331.94	331.97	331.83	331.83	10661.0
2020-08-05 07:20:00	SPY	ETF	331.83	331.86	331.74	331.86	16836.0
2020-08-05 07:25:00	SPY	ETF	331.85	331.89	331.81	331.84	8170.0
2020-08-05 07:30:00	SPY	ETF	331.81	331.95	331.8	331.95	21742.0
2020-08-05 07:35:00	SPY	ETF	331.96	332.0	331.91	331.93	21861.0
2020-08-05 07:40:00	SPY	ETF	331.92	332.0	331.91	332.0	15333.0
2020-08-05 07:45:00	SPY	ETF	331.97	332.08	331.8	331.92	15710.0
2020-08-05 07:50:00	SPY	ETF	331.91	332.08	331.91	332.03	12226.0
2020-08-05 07:55:00	SPY	ETF	332.03	332.16	332.03	332.16	111690.0
2020-08-05 08:00:00	SPY	ETF	332.21	332.21	330.0	331.79	53401.0
2020-08-05 08:05:00	SPY	ETF	331.8	331.93	331.78	331.85	12390.0
2020-08-05 08:10:00	SPY	ETF	331.87	331.87	331.7	331.75	7826.0
2020-08-05 08:15:00	SPY	ETF	331.67	331.67	331.12	331.4	176612.0
2020-08-05 08:20:00	SPY	ETF	331.42	331.67	331.36	331.65	28335.0

> showing 50 of 76,023 rows — these rows as CSV

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