PREVIEW / etf_5min / 2007-08-09

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-08-09.parquet
  size:    416 KB
  rows:    19,615

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-08-09 04:05:00	SPY	ETF	149.11	149.11	149.02	149.02	9000.0
2007-08-09 04:10:00	SPY	ETF	149.03	149.03	149.03	149.03	1000.0
2007-08-09 04:15:00	SPY	ETF	149.03	149.03	148.92	148.92	400.0
2007-08-09 04:20:00	SPY	ETF	148.95	148.98	148.94	148.94	800.0
2007-08-09 04:35:00	SPY	ETF	148.83	148.83	148.82	148.82	3400.0
2007-08-09 04:40:00	SPY	ETF	148.85	148.85	148.79	148.79	1600.0
2007-08-09 04:45:00	SPY	ETF	148.9	148.9	148.88	148.88	1500.0
2007-08-09 04:55:00	SPY	ETF	148.66	148.7	148.66	148.68	17300.0
2007-08-09 05:05:00	SPY	ETF	148.63	148.63	148.63	148.63	200.0
2007-08-09 05:10:00	SPY	ETF	148.59	148.59	148.5	148.5	25900.0
2007-08-09 05:20:00	SPY	ETF	148.72	148.72	148.72	148.72	1000.0
2007-08-09 05:30:00	SPY	ETF	148.99	148.99	148.99	148.99	4900.0
2007-08-09 05:35:00	SPY	ETF	148.95	148.95	148.95	148.95	1000.0
2007-08-09 05:55:00	SPY	ETF	148.6	148.6	148.6	148.6	1000.0
2007-08-09 06:05:00	SPY	ETF	148.69	148.72	148.69	148.72	12000.0
2007-08-09 06:10:00	SPY	ETF	148.69	148.69	148.69	148.69	8000.0
2007-08-09 06:15:00	SPY	ETF	148.81	148.81	148.81	148.81	5000.0
2007-08-09 06:35:00	SPY	ETF	148.64	148.64	148.64	148.64	5000.0
2007-08-09 06:45:00	SPY	ETF	148.62	148.62	148.61	148.61	13500.0
2007-08-09 06:50:00	SPY	ETF	148.39	148.39	148.39	148.39	1500.0
2007-08-09 06:55:00	SPY	ETF	148.32	148.39	148.23	148.29	32900.0
2007-08-09 07:00:00	SPY	ETF	148.24	148.35	148.23	148.32	440000.0
2007-08-09 07:05:00	SPY	ETF	148.4	148.49	148.35	148.49	311100.0
2007-08-09 07:10:00	SPY	ETF	148.47	148.54	148.44	148.53	61100.0
2007-08-09 07:15:00	SPY	ETF	148.55	148.66	148.53	148.6	137100.0
2007-08-09 07:20:00	SPY	ETF	148.66	148.66	148.45	148.45	231000.0
2007-08-09 07:25:00	SPY	ETF	148.45	148.49	148.26	148.32	248600.0
2007-08-09 07:30:00	SPY	ETF	148.3	148.48	148.3	148.4	82300.0
2007-08-09 07:35:00	SPY	ETF	148.4	148.45	148.2	148.3	346300.0
2007-08-09 07:40:00	SPY	ETF	148.26	148.28	148.2	148.25	375100.0
2007-08-09 07:45:00	SPY	ETF	148.27	148.32	148.17	148.32	108500.0
2007-08-09 07:50:00	SPY	ETF	148.3	148.45	148.28	148.36	109700.0
2007-08-09 07:55:00	SPY	ETF	148.38	148.56	148.32	148.52	164400.0
2007-08-09 08:00:00	SPY	ETF	148.48	148.68	148.25	148.66	2021500.0
2007-08-09 08:05:00	SPY	ETF	148.66	148.66	148.54	148.56	555500.0
2007-08-09 08:10:00	SPY	ETF	148.61	148.63	148.47	148.48	655400.0
2007-08-09 08:15:00	SPY	ETF	148.48	148.65	148.48	148.5	330800.0
2007-08-09 08:20:00	SPY	ETF	148.5	148.65	148.22	148.23	511500.0
2007-08-09 08:25:00	SPY	ETF	148.23	148.42	148.23	148.28	323500.0
2007-08-09 08:30:00	SPY	ETF	148.27	148.57	148.2	148.48	509800.0
2007-08-09 08:35:00	SPY	ETF	148.49	148.49	148.15	148.16	304700.0
2007-08-09 08:40:00	SPY	ETF	148.17	148.22	147.96	148.06	879600.0
2007-08-09 08:45:00	SPY	ETF	148.07	148.07	147.8	147.91	1148000.0
2007-08-09 08:50:00	SPY	ETF	147.93	147.96	147.54	147.65	1521300.0
2007-08-09 08:55:00	SPY	ETF	147.65	147.76	147.62	147.63	1136300.0
2007-08-09 09:00:00	SPY	ETF	147.63	147.7	147.23	147.36	1263000.0
2007-08-09 09:05:00	SPY	ETF	147.36	147.37	146.95	147.21	1473100.0
2007-08-09 09:10:00	SPY	ETF	147.23	147.29	147.03	147.13	2854500.0
2007-08-09 09:15:00	SPY	ETF	147.13	147.41	147.11	147.25	959600.0
2007-08-09 09:20:00	SPY	ETF	147.24	147.24	147.05	147.22	1057200.0

> showing 50 of 19,615 rows — these rows as CSV

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