PREVIEW / etf_5min / 2020-07-17

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-07-17.parquet
  size:    1.5 MB
  rows:    69,897

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-07-17 04:00:00	SPY	ETF	319.66	319.76	319.6	319.76	2002.0
2020-07-17 04:05:00	SPY	ETF	319.9	319.9	319.89	319.9	915.0
2020-07-17 04:10:00	SPY	ETF	319.97	320.0	319.97	320.0	1760.0
2020-07-17 04:15:00	SPY	ETF	320.0	320.13	320.0	320.1	1038.0
2020-07-17 04:20:00	SPY	ETF	320.15	320.27	320.15	320.15	6253.0
2020-07-17 04:25:00	SPY	ETF	320.1	320.1	320.07	320.07	700.0
2020-07-17 04:30:00	SPY	ETF	320.2	320.2	320.2	320.2	1539.0
2020-07-17 04:35:00	SPY	ETF	320.21	320.41	320.21	320.41	625.0
2020-07-17 04:40:00	SPY	ETF	320.33	320.33	320.33	320.33	105.0
2020-07-17 04:45:00	SPY	ETF	320.35	320.37	320.35	320.37	1150.0
2020-07-17 04:50:00	SPY	ETF	320.3	320.3	320.3	320.3	799.0
2020-07-17 04:55:00	SPY	ETF	320.25	320.37	320.25	320.3	841.0
2020-07-17 05:00:00	SPY	ETF	320.15	320.15	319.97	320.07	2877.0
2020-07-17 05:10:00	SPY	ETF	320.35	320.53	320.35	320.53	2314.0
2020-07-17 05:20:00	SPY	ETF	320.43	320.52	320.43	320.52	1001.0
2020-07-17 05:25:00	SPY	ETF	320.65	320.65	320.58	320.58	270.0
2020-07-17 05:30:00	SPY	ETF	320.55	320.55	320.55	320.55	500.0
2020-07-17 05:40:00	SPY	ETF	320.5	320.5	320.4	320.4	460.0
2020-07-17 05:45:00	SPY	ETF	320.42	320.64	320.4	320.64	6666.0
2020-07-17 05:50:00	SPY	ETF	320.4	320.4	320.35	320.35	1380.0
2020-07-17 05:55:00	SPY	ETF	320.42	320.42	320.32	320.32	523.0
2020-07-17 06:00:00	SPY	ETF	320.4	320.4	320.35	320.4	810.0
2020-07-17 06:05:00	SPY	ETF	320.37	320.37	320.37	320.37	20055.0
2020-07-17 06:10:00	SPY	ETF	320.45	320.51	320.45	320.5	1380.0
2020-07-17 06:15:00	SPY	ETF	320.5	320.5	320.5	320.5	406.0
2020-07-17 06:20:00	SPY	ETF	320.66	320.86	320.65	320.85	32502.0
2020-07-17 06:25:00	SPY	ETF	320.86	321.0	320.86	320.96	21169.0
2020-07-17 06:30:00	SPY	ETF	320.98	321.01	320.94	320.97	3188.0
2020-07-17 06:35:00	SPY	ETF	321.02	321.02	320.89	320.89	4313.0
2020-07-17 06:40:00	SPY	ETF	320.92	321.03	320.92	321.03	2207.0
2020-07-17 06:45:00	SPY	ETF	320.91	320.91	320.88	320.88	2180.0
2020-07-17 06:50:00	SPY	ETF	320.9	320.93	320.9	320.91	3150.0
2020-07-17 06:55:00	SPY	ETF	321.0	321.0	320.95	320.95	1302.0
2020-07-17 07:00:00	SPY	ETF	320.97	320.97	320.86	320.86	13702.0
2020-07-17 07:05:00	SPY	ETF	320.85	320.85	320.7	320.76	10509.0
2020-07-17 07:10:00	SPY	ETF	320.78	320.78	320.71	320.71	2213.0
2020-07-17 07:15:00	SPY	ETF	320.75	320.76	320.71	320.71	640.0
2020-07-17 07:20:00	SPY	ETF	320.7	320.73	320.64	320.73	2892.0
2020-07-17 07:25:00	SPY	ETF	320.899	320.91	320.76	320.76	2440.0
2020-07-17 07:30:00	SPY	ETF	320.77	320.84	320.73	320.81	26389.0
2020-07-17 07:35:00	SPY	ETF	320.83	320.9	320.72	320.72	12722.0
2020-07-17 07:40:00	SPY	ETF	320.7	320.7	320.62	320.64	12697.0
2020-07-17 07:45:00	SPY	ETF	320.61	320.7	320.61	320.68	17443.0
2020-07-17 07:50:00	SPY	ETF	320.75	320.79	320.7	320.76	6885.0
2020-07-17 07:55:00	SPY	ETF	320.74	320.97	320.74	320.88	4961.0
2020-07-17 08:00:00	SPY	ETF	320.815	321.2	320.0	321.15	48490.0
2020-07-17 08:05:00	SPY	ETF	321.18	321.29	320.0	321.1	92181.0
2020-07-17 08:10:00	SPY	ETF	321.16	321.51	321.1599	321.4	94651.0
2020-07-17 08:15:00	SPY	ETF	321.43	321.63	321.34	321.63	30041.0
2020-07-17 08:20:00	SPY	ETF	321.64	321.73	321.56	321.56	69782.0

> showing 50 of 69,897 rows — these rows as CSV

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