PREVIEW / etf_5min / 2007-01-22

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-01-22.parquet
  size:    281 KB
  rows:    13,696

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-22 07:00:00	SPY	ETF	143.1	143.1	143.1	143.1	7000.0
2007-01-22 07:05:00	SPY	ETF	143.11	143.11	143.11	143.11	4900.0
2007-01-22 07:15:00	SPY	ETF	143.1	143.13	143.1	143.13	3100.0
2007-01-22 08:00:00	SPY	ETF	143.12	143.15	143.1	143.12	26200.0
2007-01-22 08:05:00	SPY	ETF	143.1	143.1	143.1	143.1	3200.0
2007-01-22 08:10:00	SPY	ETF	143.04	143.04	143.04	143.04	100.0
2007-01-22 08:15:00	SPY	ETF	143.06	143.1	143.06	143.1	75300.0
2007-01-22 08:20:00	SPY	ETF	143.12	143.13	143.06	143.06	11200.0
2007-01-22 08:25:00	SPY	ETF	143.07	143.08	143.07	143.08	900.0
2007-01-22 08:30:00	SPY	ETF	143.06	143.1	143.04	143.09	15900.0
2007-01-22 08:35:00	SPY	ETF	143.05	143.11	143.05	143.07	250500.0
2007-01-22 08:40:00	SPY	ETF	143.05	143.05	143.05	143.05	100.0
2007-01-22 08:45:00	SPY	ETF	143.06	143.08	143.06	143.08	9100.0
2007-01-22 08:55:00	SPY	ETF	143.07	143.07	143.07	143.07	200.0
2007-01-22 09:00:00	SPY	ETF	143.1	143.1	143.07	143.1	30400.0
2007-01-22 09:05:00	SPY	ETF	143.09	143.09	143.06	143.08	16700.0
2007-01-22 09:10:00	SPY	ETF	143.06	143.07	143.06	143.07	400.0
2007-01-22 09:15:00	SPY	ETF	143.06	143.07	143.04	143.04	20200.0
2007-01-22 09:20:00	SPY	ETF	143.04	143.04	143.04	143.04	2000.0
2007-01-22 09:25:00	SPY	ETF	143.04	143.06	143.04	143.06	23500.0
2007-01-22 09:30:00	SPY	ETF	143.07	143.1	142.95	142.95	862300.0
2007-01-22 09:35:00	SPY	ETF	142.95	143.0	142.89	142.92	678800.0
2007-01-22 09:40:00	SPY	ETF	142.92	142.95	142.79	142.88	1193800.0
2007-01-22 09:45:00	SPY	ETF	142.88	142.92	142.81	142.88	460000.0
2007-01-22 09:50:00	SPY	ETF	142.89	142.89	142.76	142.85	793400.0
2007-01-22 09:55:00	SPY	ETF	142.84	142.89	142.78	142.83	690100.0
2007-01-22 10:00:00	SPY	ETF	142.84	142.85	142.65	142.65	942800.0
2007-01-22 10:05:00	SPY	ETF	142.66	142.7	142.51	142.52	1117000.0
2007-01-22 10:10:00	SPY	ETF	142.52	142.56	142.31	142.36	1276200.0
2007-01-22 10:15:00	SPY	ETF	142.36	142.43	142.33	142.42	1087700.0
2007-01-22 10:20:00	SPY	ETF	142.42	142.47	142.25	142.26	802400.0
2007-01-22 10:25:00	SPY	ETF	142.27	142.41	142.23	142.37	710900.0
2007-01-22 10:30:00	SPY	ETF	142.37	142.4	142.27	142.33	675700.0
2007-01-22 10:35:00	SPY	ETF	142.33	142.38	142.22	142.35	703800.0
2007-01-22 10:40:00	SPY	ETF	142.36	142.42	142.27	142.3	596600.0
2007-01-22 10:45:00	SPY	ETF	142.31	142.34	142.1	142.16	2699800.0
2007-01-22 10:50:00	SPY	ETF	142.16	142.28	142.15	142.23	1984500.0
2007-01-22 10:55:00	SPY	ETF	142.24	142.29	142.19	142.26	568200.0
2007-01-22 11:00:00	SPY	ETF	142.25	142.26	142.15	142.15	669600.0
2007-01-22 11:05:00	SPY	ETF	142.15	142.19	142.02	142.12	2156300.0
2007-01-22 11:10:00	SPY	ETF	142.12	142.19	142.12	142.18	736300.0
2007-01-22 11:15:00	SPY	ETF	142.19	142.25	142.18	142.2	1516700.0
2007-01-22 11:20:00	SPY	ETF	142.21	142.21	142.15	142.18	351600.0
2007-01-22 11:25:00	SPY	ETF	142.18	142.2	142.1	142.19	256100.0
2007-01-22 11:30:00	SPY	ETF	142.1899	142.19	142.09	142.14	396300.0
2007-01-22 11:35:00	SPY	ETF	142.15	142.23	142.09	142.22	883800.0
2007-01-22 11:40:00	SPY	ETF	142.22	142.28	142.07	142.18	1023300.0
2007-01-22 11:45:00	SPY	ETF	142.18	142.19	142.09	142.16	567700.0
2007-01-22 11:50:00	SPY	ETF	142.16	142.27	142.15	142.2401	583900.0
2007-01-22 11:55:00	SPY	ETF	142.2401	142.26	142.09	142.12	351200.0

> showing 50 of 13,696 rows — these rows as CSV

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