PREVIEW / etf_5min / 2007-06-29

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-06-29.parquet
  size:    344 KB
  rows:    16,883

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-06-29 05:25:00	SPY	ETF	150.35	150.35	150.35	150.35	16900.0
2007-06-29 06:20:00	SPY	ETF	150.2	150.2	150.2	150.2	15000.0
2007-06-29 06:40:00	SPY	ETF	150.03	150.03	150.03	150.03	200.0
2007-06-29 06:45:00	SPY	ETF	150.02	150.02	150.02	150.02	10000.0
2007-06-29 06:50:00	SPY	ETF	149.9	150.03	149.9	150.03	3500.0
2007-06-29 07:00:00	SPY	ETF	149.93	149.99	149.93	149.99	60400.0
2007-06-29 07:05:00	SPY	ETF	149.97	150.02	149.96	150.02	105900.0
2007-06-29 07:10:00	SPY	ETF	150.0	150.05	150.0	150.05	115500.0
2007-06-29 07:15:00	SPY	ETF	150.08	150.13	150.07	150.13	25500.0
2007-06-29 07:20:00	SPY	ETF	150.11	150.13	150.11	150.11	1700.0
2007-06-29 07:25:00	SPY	ETF	150.1	150.1	150.1	150.1	2000.0
2007-06-29 07:30:00	SPY	ETF	150.15	150.15	150.12	150.12	6000.0
2007-06-29 07:35:00	SPY	ETF	150.12	150.15	150.12	150.15	13900.0
2007-06-29 07:40:00	SPY	ETF	150.15	150.15	150.15	150.15	1300.0
2007-06-29 07:45:00	SPY	ETF	150.11	150.12	150.1	150.1	29000.0
2007-06-29 07:55:00	SPY	ETF	150.1	150.12	150.08	150.08	16900.0
2007-06-29 08:00:00	SPY	ETF	150.12	150.15	150.12	150.15	50300.0
2007-06-29 08:05:00	SPY	ETF	150.15	150.22	150.14	150.22	28400.0
2007-06-29 08:10:00	SPY	ETF	150.2	150.2	150.15	150.15	53900.0
2007-06-29 08:15:00	SPY	ETF	150.16	150.31	150.14	150.27	55100.0
2007-06-29 08:20:00	SPY	ETF	150.29	150.38	150.27	150.38	380300.0
2007-06-29 08:25:00	SPY	ETF	150.38	150.38	150.25	150.26	164700.0
2007-06-29 08:30:00	SPY	ETF	150.3	150.69	150.3	150.62	1463400.0
2007-06-29 08:35:00	SPY	ETF	150.63	150.7	150.62	150.68	427900.0
2007-06-29 08:40:00	SPY	ETF	150.69	150.7	150.66	150.69	98200.0
2007-06-29 08:45:00	SPY	ETF	150.69	150.7	150.59	150.59	238100.0
2007-06-29 08:50:00	SPY	ETF	150.59	150.64	150.57	150.64	110900.0
2007-06-29 08:55:00	SPY	ETF	150.62	150.7	150.62	150.7	190600.0
2007-06-29 09:00:00	SPY	ETF	150.7	150.77	150.69	150.77	124600.0
2007-06-29 09:05:00	SPY	ETF	150.76	150.85	150.74	150.85	664700.0
2007-06-29 09:10:00	SPY	ETF	150.84	150.87	150.79	150.83	579000.0
2007-06-29 09:15:00	SPY	ETF	150.83	150.89	150.83	150.88	140300.0
2007-06-29 09:20:00	SPY	ETF	150.89	150.95	150.87	150.92	466600.0
2007-06-29 09:25:00	SPY	ETF	150.91	150.93	150.82	150.83	666400.0
2007-06-29 09:30:00	SPY	ETF	150.83	150.91	150.8	150.86	3249100.0
2007-06-29 09:35:00	SPY	ETF	150.86	150.91	150.78	150.84	2076400.0
2007-06-29 09:40:00	SPY	ETF	150.84	151.12	150.8	151.02	2912021.0
2007-06-29 09:45:00	SPY	ETF	151.01	151.2	150.99	151.16	3474685.0
2007-06-29 09:50:00	SPY	ETF	151.17	151.38	151.12	151.37	2611616.0
2007-06-29 09:55:00	SPY	ETF	151.37	151.47	151.24	151.27	2977368.0
2007-06-29 10:00:00	SPY	ETF	151.26	151.65	151.26	151.58	5571021.0
2007-06-29 10:05:00	SPY	ETF	151.58	151.61	151.44	151.51	1499218.0
2007-06-29 10:10:00	SPY	ETF	151.52	151.56	151.31	151.38	1968314.0
2007-06-29 10:15:00	SPY	ETF	151.375	151.38	151.21	151.24	1232193.0
2007-06-29 10:20:00	SPY	ETF	151.24	151.38	151.12	151.18	2192000.0
2007-06-29 10:25:00	SPY	ETF	151.18	151.31	151.17	151.29	1299400.0
2007-06-29 10:30:00	SPY	ETF	151.29	151.31	151.17	151.21	836585.0
2007-06-29 10:35:00	SPY	ETF	151.21	151.27	151.16	151.26	834900.0
2007-06-29 10:40:00	SPY	ETF	151.26	151.33	151.22	151.3	1329900.0
2007-06-29 10:45:00	SPY	ETF	151.3	151.3	151.2	151.26	491216.0

> showing 50 of 16,883 rows — these rows as CSV

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