PREVIEW / etf_5min / 2007-01-23

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-01-23.parquet
  size:    292 KB
  rows:    14,010

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
2007-01-23 06:20:00	SPY	ETF	142.18	142.18	142.18	142.18	19900.0
2007-01-23 07:00:00	SPY	ETF	142.17	142.17	142.17	142.17	10000.0
2007-01-23 07:05:00	SPY	ETF	142.17	142.17	142.17	142.17	7700.0
2007-01-23 07:10:00	SPY	ETF	142.22	142.22	142.22	142.22	22400.0
2007-01-23 07:15:00	SPY	ETF	142.22	142.22	142.2	142.2	38200.0
2007-01-23 07:20:00	SPY	ETF	142.17	142.17	142.16	142.17	47400.0
2007-01-23 07:25:00	SPY	ETF	142.17	142.17	142.15	142.15	10200.0
2007-01-23 07:30:00	SPY	ETF	142.15	142.19	142.15	142.19	1100.0
2007-01-23 07:40:00	SPY	ETF	142.2	142.2	142.2	142.2	2000.0
2007-01-23 07:45:00	SPY	ETF	142.16	142.16	142.16	142.16	1500.0
2007-01-23 07:50:00	SPY	ETF	142.16	142.16	142.15	142.16	1300.0
2007-01-23 07:55:00	SPY	ETF	142.16	142.16	142.16	142.16	600.0
2007-01-23 08:00:00	SPY	ETF	142.22	142.22	142.14	142.18	9100.0
2007-01-23 08:05:00	SPY	ETF	142.18	142.18	142.15	142.15	6100.0
2007-01-23 08:10:00	SPY	ETF	142.19	142.21	142.17	142.2	40000.0
2007-01-23 08:15:00	SPY	ETF	142.2	142.23	142.17	142.17	213200.0
2007-01-23 08:20:00	SPY	ETF	142.19	142.19	142.19	142.19	900.0
2007-01-23 08:25:00	SPY	ETF	142.16	142.26	142.16	142.26	29200.0
2007-01-23 08:30:00	SPY	ETF	142.25	142.3	142.25	142.25	25700.0
2007-01-23 08:35:00	SPY	ETF	142.27	142.27	142.26	142.27	9500.0
2007-01-23 08:40:00	SPY	ETF	142.27	142.27	142.24	142.26	17300.0
2007-01-23 08:45:00	SPY	ETF	142.24	142.27	142.24	142.27	10100.0
2007-01-23 08:50:00	SPY	ETF	142.27	142.28	142.27	142.28	9000.0
2007-01-23 08:55:00	SPY	ETF	142.25	142.25	142.21	142.21	59200.0
2007-01-23 09:00:00	SPY	ETF	142.22	142.23	142.19	142.22	44500.0
2007-01-23 09:05:00	SPY	ETF	142.24	142.25	142.23	142.23	14300.0
2007-01-23 09:10:00	SPY	ETF	142.24	142.27	142.24	142.27	8900.0
2007-01-23 09:15:00	SPY	ETF	142.27	142.29	142.27	142.29	128500.0
2007-01-23 09:20:00	SPY	ETF	142.3	142.31	142.3	142.3	3700.0
2007-01-23 09:25:00	SPY	ETF	142.31	142.31	142.22	142.25	25000.0
2007-01-23 09:30:00	SPY	ETF	142.26	142.42	142.19	142.4	1200000.0
2007-01-23 09:35:00	SPY	ETF	142.4	142.4	142.17	142.22	1020700.0
2007-01-23 09:40:00	SPY	ETF	142.21	142.24	142.06	142.08	863600.0
2007-01-23 09:45:00	SPY	ETF	142.08	142.29	142.07	142.2499	748100.0
2007-01-23 09:50:00	SPY	ETF	142.26	142.42	142.24	142.35	1039700.0
2007-01-23 09:55:00	SPY	ETF	142.35	142.52	142.26	142.41	1505600.0
2007-01-23 10:00:00	SPY	ETF	142.4	142.46	142.32	142.34	1390900.0
2007-01-23 10:05:00	SPY	ETF	142.34	142.42	142.24	142.38	1137200.0
2007-01-23 10:10:00	SPY	ETF	142.38	142.49	142.22	142.29	747900.0
2007-01-23 10:15:00	SPY	ETF	142.299	142.38	142.27	142.37	549700.0
2007-01-23 10:20:00	SPY	ETF	142.39	142.41	142.23	142.28	818300.0
2007-01-23 10:25:00	SPY	ETF	142.29	142.32	142.23	142.32	403200.0
2007-01-23 10:30:00	SPY	ETF	142.32	142.37	142.29	142.36	636700.0
2007-01-23 10:35:00	SPY	ETF	142.36	142.45	142.31	142.38	1173800.0
2007-01-23 10:40:00	SPY	ETF	142.37	142.4	142.26	142.27	374600.0
2007-01-23 10:45:00	SPY	ETF	142.28	142.37	142.26	142.31	247400.0
2007-01-23 10:50:00	SPY	ETF	142.32	142.42	142.29	142.3899	391000.0
2007-01-23 10:55:00	SPY	ETF	142.38	142.41	142.32	142.34	274900.0
2007-01-23 11:00:00	SPY	ETF	142.34	142.46	142.32	142.45	658900.0
2007-01-23 11:05:00	SPY	ETF	142.44	142.58	142.43	142.57	1159000.0

> showing 50 of 14,010 rows — these rows as CSV

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