PREVIEW / etf_5min / 2007-10-22

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-10-22.parquet
  size:    422 KB
  rows:    20,257

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-10-22 04:15:00	SPY	ETF	149.25	149.25	149.17	149.17	200.0
2007-10-22 04:20:00	SPY	ETF	149.18	149.2	149.18	149.2	25000.0
2007-10-22 04:30:00	SPY	ETF	149.15	149.15	149.1	149.1	6000.0
2007-10-22 04:35:00	SPY	ETF	149.03	149.03	149.03	149.03	100.0
2007-10-22 04:45:00	SPY	ETF	149.01	149.01	149.0	149.0	800.0
2007-10-22 05:10:00	SPY	ETF	148.88	148.88	148.88	148.88	8500.0
2007-10-22 05:55:00	SPY	ETF	148.76	148.76	148.76	148.76	5000.0
2007-10-22 06:00:00	SPY	ETF	148.75	148.75	148.75	148.75	5000.0
2007-10-22 06:05:00	SPY	ETF	148.75	148.75	148.75	148.75	2000.0
2007-10-22 06:15:00	SPY	ETF	148.73	148.73	148.73	148.73	2000.0
2007-10-22 06:20:00	SPY	ETF	148.7	148.7	148.7	148.7	3000.0
2007-10-22 06:25:00	SPY	ETF	148.81	148.81	148.81	148.81	1000.0
2007-10-22 06:35:00	SPY	ETF	148.72	148.76	148.71	148.71	11000.0
2007-10-22 06:40:00	SPY	ETF	148.53	148.53	148.51	148.51	3000.0
2007-10-22 06:45:00	SPY	ETF	148.51	148.51	148.5	148.5	77500.0
2007-10-22 06:50:00	SPY	ETF	148.5	148.58	148.5	148.56	3500.0
2007-10-22 06:55:00	SPY	ETF	148.61	148.61	148.53	148.6	61400.0
2007-10-22 07:00:00	SPY	ETF	148.61	148.71	148.56	148.68	197600.0
2007-10-22 07:05:00	SPY	ETF	148.7	148.83	148.66	148.83	116900.0
2007-10-22 07:10:00	SPY	ETF	148.83	148.83	148.67	148.68	245400.0
2007-10-22 07:15:00	SPY	ETF	148.72	148.75	148.61	148.65	122200.0
2007-10-22 07:20:00	SPY	ETF	148.69	148.78	148.68	148.76	76600.0
2007-10-22 07:25:00	SPY	ETF	148.76	148.79	148.63	148.63	154300.0
2007-10-22 07:30:00	SPY	ETF	148.63	148.7	148.6	148.67	142900.0
2007-10-22 07:35:00	SPY	ETF	148.69	148.7	148.66	148.69	93400.0
2007-10-22 07:40:00	SPY	ETF	148.67	148.69	148.65	148.68	30400.0
2007-10-22 07:45:00	SPY	ETF	148.69	148.69	148.54	148.54	141500.0
2007-10-22 07:50:00	SPY	ETF	148.54	148.62	148.51	148.59	155500.0
2007-10-22 07:55:00	SPY	ETF	148.56	148.59	148.55	148.55	88000.0
2007-10-22 08:00:00	SPY	ETF	148.58	148.79	148.53	148.65	2084700.0
2007-10-22 08:05:00	SPY	ETF	148.67	148.75	148.63	148.73	91700.0
2007-10-22 08:10:00	SPY	ETF	148.76	148.85	148.73	148.76	233900.0
2007-10-22 08:15:00	SPY	ETF	148.75	148.88	148.74	148.82	184400.0
2007-10-22 08:20:00	SPY	ETF	148.83	149.05	148.79	149.03	574700.0
2007-10-22 08:25:00	SPY	ETF	149.02	149.02	148.82	148.93	618600.0
2007-10-22 08:30:00	SPY	ETF	148.88	148.98	148.84	148.9	151000.0
2007-10-22 08:35:00	SPY	ETF	148.88	149.04	148.87	149.03	304500.0
2007-10-22 08:40:00	SPY	ETF	149.01	149.02	148.95	148.98	373000.0
2007-10-22 08:45:00	SPY	ETF	148.98	149.09	148.96	149.07	616600.0
2007-10-22 08:50:00	SPY	ETF	149.08	149.2	149.07	149.13	910500.0
2007-10-22 08:55:00	SPY	ETF	149.13	149.15	149.03	149.06	646500.0
2007-10-22 09:00:00	SPY	ETF	149.08	149.09	148.83	148.9	391300.0
2007-10-22 09:05:00	SPY	ETF	148.89	148.89	148.73	148.76	526280.0
2007-10-22 09:10:00	SPY	ETF	148.76	148.88	148.75	148.84	1110010.0
2007-10-22 09:15:00	SPY	ETF	148.85	148.89	148.8	148.88	454100.0
2007-10-22 09:20:00	SPY	ETF	148.88	148.92	148.79	148.83	433209.0
2007-10-22 09:25:00	SPY	ETF	148.82	148.88	148.79	148.83	604534.0
2007-10-22 09:30:00	SPY	ETF	148.84	148.93	148.66	148.91	4025653.0
2007-10-22 09:35:00	SPY	ETF	148.91	149.28	148.83	149.28	8076469.0
2007-10-22 09:40:00	SPY	ETF	149.28	149.59	149.25	149.4	11151800.0

> showing 50 of 20,257 rows — these rows as CSV

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