PREVIEW / etf_5min / 2007-12-26

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-12-26.parquet
  size:    365 KB
  rows:    18,779

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-12-26 06:05:00	SPY	ETF	149.41	149.43	149.41	149.43	17500.0
2007-12-26 06:40:00	SPY	ETF	149.46	149.48	149.46	149.48	32500.0
2007-12-26 06:45:00	SPY	ETF	149.52	149.52	149.52	149.52	2400.0
2007-12-26 06:55:00	SPY	ETF	149.35	149.35	149.25	149.25	11800.0
2007-12-26 07:00:00	SPY	ETF	149.34	149.34	149.33	149.34	7500.0
2007-12-26 07:05:00	SPY	ETF	149.3	149.34	149.3	149.34	8200.0
2007-12-26 07:10:00	SPY	ETF	149.33	149.33	149.27	149.3	32500.0
2007-12-26 07:15:00	SPY	ETF	149.3	149.3	149.3	149.3	3000.0
2007-12-26 07:20:00	SPY	ETF	149.32	149.32	149.32	149.32	7500.0
2007-12-26 07:25:00	SPY	ETF	149.32	149.32	149.22	149.22	9800.0
2007-12-26 07:30:00	SPY	ETF	149.22	149.23	149.09	149.09	138100.0
2007-12-26 07:35:00	SPY	ETF	149.1	149.15	149.09	149.15	79100.0
2007-12-26 07:40:00	SPY	ETF	149.15	149.15	149.03	149.03	35100.0
2007-12-26 07:45:00	SPY	ETF	149.1	149.1	149.05	149.05	8000.0
2007-12-26 07:50:00	SPY	ETF	149.1	149.1	148.97	148.98	27800.0
2007-12-26 07:55:00	SPY	ETF	149.0	149.0	149.0	149.0	25300.0
2007-12-26 08:00:00	SPY	ETF	149.08	149.08	149.07	149.08	149900.0
2007-12-26 08:05:00	SPY	ETF	149.08	149.08	149.08	149.08	31100.0
2007-12-26 08:10:00	SPY	ETF	149.08	149.13	149.07	149.1	74900.0
2007-12-26 08:15:00	SPY	ETF	149.09	149.1	149.09	149.09	11000.0
2007-12-26 08:20:00	SPY	ETF	149.09	149.1	149.08	149.1	10400.0
2007-12-26 08:25:00	SPY	ETF	149.09	149.1	149.05	149.05	18400.0
2007-12-26 08:30:00	SPY	ETF	149.07	149.1	149.04	149.05	56500.0
2007-12-26 08:35:00	SPY	ETF	149.05	149.05	149.0	149.0	44100.0
2007-12-26 08:40:00	SPY	ETF	149.0	149.07	148.95	149.06	95600.0
2007-12-26 08:45:00	SPY	ETF	149.07	149.07	149.01	149.06	32000.0
2007-12-26 08:50:00	SPY	ETF	149.05	149.11	149.05	149.1	4100.0
2007-12-26 08:55:00	SPY	ETF	149.09	149.09	149.07	149.08	31000.0
2007-12-26 09:00:00	SPY	ETF	149.07	149.07	148.84	148.86	178700.0
2007-12-26 09:05:00	SPY	ETF	148.84	148.84	148.67	148.75	2343000.0
2007-12-26 09:10:00	SPY	ETF	148.76	148.83	148.7	148.7	117900.0
2007-12-26 09:15:00	SPY	ETF	148.7	148.79	148.7	148.77	341500.0
2007-12-26 09:20:00	SPY	ETF	148.77	148.8	148.61	148.62	84100.0
2007-12-26 09:25:00	SPY	ETF	148.62	148.74	148.6	148.74	132000.0
2007-12-26 09:30:00	SPY	ETF	148.8	148.92	148.74	148.81	2639242.0
2007-12-26 09:35:00	SPY	ETF	148.8	148.87	148.73	148.75	1428557.0
2007-12-26 09:40:00	SPY	ETF	148.75	148.9	148.73	148.86	780096.0
2007-12-26 09:45:00	SPY	ETF	148.85	148.9	148.74	148.79	800500.0
2007-12-26 09:50:00	SPY	ETF	148.79	148.79	148.7	148.71	666024.0
2007-12-26 09:55:00	SPY	ETF	148.71	148.71	148.5	148.65	1496889.0
2007-12-26 10:00:00	SPY	ETF	148.64	148.71	148.61	148.68	591940.0
2007-12-26 10:05:00	SPY	ETF	148.68	148.76	148.65	148.76	535800.0
2007-12-26 10:10:00	SPY	ETF	148.76	148.88	148.76	148.84	514000.0
2007-12-26 10:15:00	SPY	ETF	148.84	148.85	148.77	148.8	347900.0
2007-12-26 10:20:00	SPY	ETF	148.8	148.86	148.78	148.8401	392502.0
2007-12-26 10:25:00	SPY	ETF	148.84	149.0	148.84	148.95	2338893.0
2007-12-26 10:30:00	SPY	ETF	148.95	148.98	148.9	148.93	392400.0
2007-12-26 10:35:00	SPY	ETF	148.93	148.93	148.85	148.85	222325.0
2007-12-26 10:40:00	SPY	ETF	148.89	148.92	148.75	148.8	1278355.0
2007-12-26 10:45:00	SPY	ETF	148.78	148.89	148.78	148.89	504200.0

> showing 50 of 18,779 rows — these rows as CSV

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