PREVIEW / etf_5min / 2007-11-06

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-11-06.parquet
  size:    401 KB
  rows:    19,718

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-11-06 05:45:00	SPY	ETF	150.47	150.47	150.47	150.47	3000.0
2007-11-06 06:10:00	SPY	ETF	150.51	150.51	150.51	150.51	3000.0
2007-11-06 06:20:00	SPY	ETF	150.49	150.49	150.49	150.49	5000.0
2007-11-06 06:45:00	SPY	ETF	150.62	150.65	150.62	150.65	3000.0
2007-11-06 06:50:00	SPY	ETF	150.64	150.8	150.64	150.8	80000.0
2007-11-06 06:55:00	SPY	ETF	150.74	150.77	150.74	150.77	16000.0
2007-11-06 07:00:00	SPY	ETF	150.75	150.85	150.7	150.85	143600.0
2007-11-06 07:05:00	SPY	ETF	150.81	150.95	150.8	150.93	125400.0
2007-11-06 07:10:00	SPY	ETF	150.9	150.99	150.85	150.95	41200.0
2007-11-06 07:15:00	SPY	ETF	150.94	151.0	150.94	150.98	37700.0
2007-11-06 07:20:00	SPY	ETF	150.99	150.99	150.9	150.9	44600.0
2007-11-06 07:25:00	SPY	ETF	150.9	150.9	150.85	150.85	27500.0
2007-11-06 07:30:00	SPY	ETF	150.88	150.88	150.8	150.85	35800.0
2007-11-06 07:35:00	SPY	ETF	150.85	150.88	150.72	150.78	89400.0
2007-11-06 07:40:00	SPY	ETF	150.79	150.88	150.79	150.83	128500.0
2007-11-06 07:45:00	SPY	ETF	150.79	150.83	150.79	150.83	22900.0
2007-11-06 07:50:00	SPY	ETF	150.82	150.82	150.77	150.77	81100.0
2007-11-06 07:55:00	SPY	ETF	150.77	150.82	150.77	150.82	90800.0
2007-11-06 08:00:00	SPY	ETF	150.82	150.82	150.2	150.8	651900.0
2007-11-06 08:05:00	SPY	ETF	150.75	150.78	150.75	150.77	34900.0
2007-11-06 08:10:00	SPY	ETF	150.77	150.91	150.74	150.81	404400.0
2007-11-06 08:15:00	SPY	ETF	150.82	150.87	150.82	150.85	18400.0
2007-11-06 08:20:00	SPY	ETF	150.87	150.89	150.79	150.79	59400.0
2007-11-06 08:25:00	SPY	ETF	150.78	150.87	150.77	150.79	171900.0
2007-11-06 08:30:00	SPY	ETF	150.85	150.89	150.85	150.88	141700.0
2007-11-06 08:35:00	SPY	ETF	150.87	150.91	150.87	150.89	327300.0
2007-11-06 08:40:00	SPY	ETF	150.87	150.87	150.55	150.75	169200.0
2007-11-06 08:45:00	SPY	ETF	150.75	150.76	150.68	150.73	83000.0
2007-11-06 08:50:00	SPY	ETF	150.71	150.72	150.67	150.71	513000.0
2007-11-06 08:55:00	SPY	ETF	150.69	150.71	150.68	150.7	20300.0
2007-11-06 09:00:00	SPY	ETF	150.71	150.75	150.71	150.73	22400.0
2007-11-06 09:05:00	SPY	ETF	150.73	150.81	150.72	150.81	46400.0
2007-11-06 09:10:00	SPY	ETF	150.8	150.82	150.78	150.8	34500.0
2007-11-06 09:15:00	SPY	ETF	150.8	150.81	150.77	150.8	162700.0
2007-11-06 09:20:00	SPY	ETF	150.81	150.84	150.78	150.83	311200.0
2007-11-06 09:25:00	SPY	ETF	150.83	150.85	150.76	150.84	1238200.0
2007-11-06 09:30:00	SPY	ETF	150.86	151.13	150.84	151.13	4084604.0
2007-11-06 09:35:00	SPY	ETF	151.13	151.14	150.91	150.91	3275658.0
2007-11-06 09:40:00	SPY	ETF	150.9	151.13	150.84	150.96	2771544.0
2007-11-06 09:45:00	SPY	ETF	150.97	150.98	150.77	150.95	2733198.0
2007-11-06 09:50:00	SPY	ETF	150.95	150.95	150.71	150.72	1266200.0
2007-11-06 09:55:00	SPY	ETF	150.71	151.03	150.71	150.96	1519249.0
2007-11-06 10:00:00	SPY	ETF	150.96	151.2	150.91	151.12	3075391.0
2007-11-06 10:05:00	SPY	ETF	151.12	151.18	151.0	151.05	1458139.0
2007-11-06 10:10:00	SPY	ETF	151.05	151.08	150.9	150.91	2006345.0
2007-11-06 10:15:00	SPY	ETF	150.91	151.11	150.89	151.06	1316176.0
2007-11-06 10:20:00	SPY	ETF	151.0601	151.07	150.64	150.76	2820044.0
2007-11-06 10:25:00	SPY	ETF	150.76	150.85	150.64	150.79	2500183.0
2007-11-06 10:30:00	SPY	ETF	150.79	150.79	150.5	150.57	2483074.0
2007-11-06 10:35:00	SPY	ETF	150.57	150.65	150.45	150.65	3185189.0

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

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