PREVIEW / etf_5min / 2022-09-20

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-09-20.parquet
  size:    1.9 MB
  rows:    92,276

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
2022-09-20 04:00:00	SPY	ETF	388.33	388.98	387.9	387.9	33232.0
2022-09-20 04:05:00	SPY	ETF	387.93	387.94	387.55	387.55	6090.0
2022-09-20 04:10:00	SPY	ETF	387.6	387.6	387.46	387.46	5702.0
2022-09-20 04:15:00	SPY	ETF	387.54	387.54	387.39	387.44	6272.0
2022-09-20 04:20:00	SPY	ETF	387.52	387.52	387.44	387.45	1390.0
2022-09-20 04:25:00	SPY	ETF	387.65	387.7	387.65	387.7	1500.0
2022-09-20 04:30:00	SPY	ETF	387.75	388.18	387.75	388.18	12866.0
2022-09-20 04:35:00	SPY	ETF	388.18	388.3	388.16	388.3	6028.0
2022-09-20 04:40:00	SPY	ETF	388.4	388.4	388.4	388.4	100.0
2022-09-20 04:45:00	SPY	ETF	388.32	388.34	388.2	388.2	2127.0
2022-09-20 04:50:00	SPY	ETF	388.13	388.16	387.91	387.91	6850.0
2022-09-20 04:55:00	SPY	ETF	387.94	387.96	387.78	387.78	3743.0
2022-09-20 05:00:00	SPY	ETF	387.96	387.96	387.8	387.8	1460.0
2022-09-20 05:05:00	SPY	ETF	387.9	387.9	387.45	387.49	13643.0
2022-09-20 05:10:00	SPY	ETF	387.41	387.42	387.39	387.41	12790.0
2022-09-20 05:15:00	SPY	ETF	387.41	387.41	387.31	387.31	3100.0
2022-09-20 05:20:00	SPY	ETF	387.24	387.24	386.95	386.96	13074.0
2022-09-20 05:25:00	SPY	ETF	386.91	387.33	386.88	387.2	5284.0
2022-09-20 05:30:00	SPY	ETF	387.46	387.51	387.42	387.42	1777.0
2022-09-20 05:35:00	SPY	ETF	387.2	387.2	387.04	387.15	1700.0
2022-09-20 05:40:00	SPY	ETF	387.13	387.2	386.86	386.86	9148.0
2022-09-20 05:45:00	SPY	ETF	386.73	386.73	386.65	386.72	5712.0
2022-09-20 05:50:00	SPY	ETF	386.77	386.77	386.51	386.62	2806.0
2022-09-20 05:55:00	SPY	ETF	386.73	386.9	386.73	386.9	1200.0
2022-09-20 06:00:00	SPY	ETF	386.79	386.79	386.5	386.59	10106.0
2022-09-20 06:05:00	SPY	ETF	386.52	386.63	386.48	386.61	17165.0
2022-09-20 06:10:00	SPY	ETF	386.65	386.67	386.44	386.57	3887.0
2022-09-20 06:15:00	SPY	ETF	386.55	386.55	386.31	386.45	7015.0
2022-09-20 06:20:00	SPY	ETF	386.38	386.62	386.35	386.62	4507.0
2022-09-20 06:25:00	SPY	ETF	386.71	386.71	386.7	386.7	3400.0
2022-09-20 06:30:00	SPY	ETF	386.89	386.99	386.85	386.99	2453.0
2022-09-20 06:35:00	SPY	ETF	386.98	387.04	386.9	386.9	1900.0
2022-09-20 06:40:00	SPY	ETF	386.93	386.95	386.7	386.7	25300.0
2022-09-20 06:45:00	SPY	ETF	386.73	386.9	386.52	386.9	5470.0
2022-09-20 06:50:00	SPY	ETF	386.9	387.01	386.9	386.94	8700.0
2022-09-20 06:55:00	SPY	ETF	386.93	387.02	386.93	387.02	35237.0
2022-09-20 07:00:00	SPY	ETF	387.03	387.339	386.95	387.289	22228.0
2022-09-20 07:05:00	SPY	ETF	387.2	387.37	387.13	387.35	14519.0
2022-09-20 07:10:00	SPY	ETF	387.2	387.2	386.71	386.86	46176.0
2022-09-20 07:15:00	SPY	ETF	386.86	387.43	386.86	387.43	40533.0
2022-09-20 07:20:00	SPY	ETF	387.37	387.41	387.04	387.11	10374.0
2022-09-20 07:25:00	SPY	ETF	387.06	387.32	387.06	387.3	10231.0
2022-09-20 07:30:00	SPY	ETF	387.15	387.15	387.0	387.05	14885.0
2022-09-20 07:35:00	SPY	ETF	387.0	387.1	387.0	387.02	1999.0
2022-09-20 07:40:00	SPY	ETF	387.01	387.01	386.72	386.88	6498.0
2022-09-20 07:45:00	SPY	ETF	386.8	386.93	386.69	386.92	19293.0
2022-09-20 07:50:00	SPY	ETF	386.96	387.07	386.85	386.85	10087.0
2022-09-20 07:55:00	SPY	ETF	386.85	386.85	386.7	386.74	7732.0
2022-09-20 08:00:00	SPY	ETF	386.9835	390.18	386.5	386.5	81587.0
2022-09-20 08:05:00	SPY	ETF	386.5	386.52	385.94	386.06	66161.0

> showing 50 of 92,276 rows — these rows as CSV

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