PREVIEW / etf_5min / 2007-10-31

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-10-31.parquet
  size:    404 KB
  rows:    19,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-10-31 04:30:00	SPY	ETF	153.28	153.28	153.28	153.28	100.0
2007-10-31 05:35:00	SPY	ETF	153.46	153.46	153.46	153.46	7000.0
2007-10-31 06:30:00	SPY	ETF	153.61	153.61	153.6	153.6	12500.0
2007-10-31 06:35:00	SPY	ETF	153.51	153.51	153.51	153.51	1500.0
2007-10-31 06:45:00	SPY	ETF	153.58	153.58	153.58	153.58	15000.0
2007-10-31 06:55:00	SPY	ETF	153.53	153.53	153.53	153.53	1000.0
2007-10-31 07:00:00	SPY	ETF	153.53	153.55	153.53	153.55	5500.0
2007-10-31 07:05:00	SPY	ETF	153.53	153.63	153.53	153.62	14200.0
2007-10-31 07:10:00	SPY	ETF	153.62	153.68	153.61	153.68	37100.0
2007-10-31 07:15:00	SPY	ETF	153.63	153.67	153.63	153.63	248000.0
2007-10-31 07:20:00	SPY	ETF	153.66	153.66	153.62	153.63	95900.0
2007-10-31 07:25:00	SPY	ETF	153.64	153.76	153.64	153.69	162000.0
2007-10-31 07:30:00	SPY	ETF	153.71	153.73	153.66	153.66	61300.0
2007-10-31 07:35:00	SPY	ETF	153.7	153.7	153.63	153.66	12800.0
2007-10-31 07:40:00	SPY	ETF	153.62	153.66	153.6	153.65	198800.0
2007-10-31 07:45:00	SPY	ETF	153.59	153.59	153.53	153.55	100600.0
2007-10-31 07:50:00	SPY	ETF	153.58	153.6	153.58	153.6	27500.0
2007-10-31 07:55:00	SPY	ETF	153.58	153.6	153.56	153.6	91800.0
2007-10-31 08:00:00	SPY	ETF	153.62	153.62	153.3	153.55	64700.0
2007-10-31 08:05:00	SPY	ETF	153.56	153.69	153.54	153.69	88000.0
2007-10-31 08:10:00	SPY	ETF	153.68	153.68	153.62	153.62	166700.0
2007-10-31 08:15:00	SPY	ETF	153.67	153.75	153.65	153.7	235600.0
2007-10-31 08:20:00	SPY	ETF	153.65	153.68	153.65	153.65	39600.0
2007-10-31 08:25:00	SPY	ETF	153.63	153.66	153.59	153.6	143500.0
2007-10-31 08:30:00	SPY	ETF	153.65	153.85	153.5	153.7	731000.0
2007-10-31 08:35:00	SPY	ETF	153.67	153.71	153.59	153.69	123900.0
2007-10-31 08:40:00	SPY	ETF	153.64	153.67	153.62	153.67	133500.0
2007-10-31 08:45:00	SPY	ETF	153.65	153.73	153.65	153.71	167900.0
2007-10-31 08:50:00	SPY	ETF	153.72	153.83	153.71	153.83	930500.0
2007-10-31 08:55:00	SPY	ETF	153.82	153.89	153.81	153.88	272800.0
2007-10-31 09:00:00	SPY	ETF	153.86	153.98	153.86	153.9	1000300.0
2007-10-31 09:05:00	SPY	ETF	153.9	153.92	153.87	153.88	74900.0
2007-10-31 09:10:00	SPY	ETF	153.87	153.89	153.84	153.87	260600.0
2007-10-31 09:15:00	SPY	ETF	153.88	153.91	153.85	153.89	109800.0
2007-10-31 09:20:00	SPY	ETF	153.86	153.96	153.74	153.91	704100.0
2007-10-31 09:25:00	SPY	ETF	153.9	153.98	153.9	153.98	114700.0
2007-10-31 09:30:00	SPY	ETF	153.98	153.99	153.78	153.82	1511151.0
2007-10-31 09:35:00	SPY	ETF	153.8201	153.91	153.79	153.86	1184300.0
2007-10-31 09:40:00	SPY	ETF	153.84	153.9	153.58	153.66	4328478.0
2007-10-31 09:45:00	SPY	ETF	153.7	153.85	153.65	153.75	2506800.0
2007-10-31 09:50:00	SPY	ETF	153.75	153.77	153.53	153.53	2209300.0
2007-10-31 09:55:00	SPY	ETF	153.53	153.68	153.5199	153.68	1224176.0
2007-10-31 10:00:00	SPY	ETF	153.67	153.76	153.66	153.67	1202277.0
2007-10-31 10:05:00	SPY	ETF	153.67	153.79	153.63	153.7	1035699.0
2007-10-31 10:10:00	SPY	ETF	153.69	153.82	153.69	153.78	1100306.0
2007-10-31 10:15:00	SPY	ETF	153.78	153.8	153.71	153.71	783183.0
2007-10-31 10:20:00	SPY	ETF	153.71	153.81	153.68	153.8	840900.0
2007-10-31 10:25:00	SPY	ETF	153.8	153.9	153.79	153.86	1276174.0
2007-10-31 10:30:00	SPY	ETF	153.85	153.88	153.75	153.84	1878315.0
2007-10-31 10:35:00	SPY	ETF	153.84	153.98	153.78	153.95	1968867.0

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

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