PREVIEW / etf_5min / 2006-01-27

all etf 5-min files

  file:    by_date/etf_5min/2006/2006-01-27.parquet
  size:    185 KB
  rows:    9,598

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
2006-01-27 04:20:00	SPY	ETF	127.82	127.82	127.82	127.82	50000.0
2006-01-27 04:35:00	SPY	ETF	127.75	127.75	127.75	127.75	100.0
2006-01-27 06:45:00	SPY	ETF	127.77	127.77	127.77	127.77	100.0
2006-01-27 07:00:00	SPY	ETF	127.79	127.8	127.79	127.8	3600.0
2006-01-27 07:05:00	SPY	ETF	127.81	127.83	127.81	127.83	2000.0
2006-01-27 07:15:00	SPY	ETF	127.85	127.85	127.85	127.85	2400.0
2006-01-27 07:20:00	SPY	ETF	127.81	127.81	127.81	127.81	700.0
2006-01-27 07:25:00	SPY	ETF	127.85	127.86	127.82	127.82	14000.0
2006-01-27 07:35:00	SPY	ETF	127.82	127.82	127.75	127.75	16500.0
2006-01-27 07:40:00	SPY	ETF	127.75	127.8	127.74	127.78	3800.0
2006-01-27 07:45:00	SPY	ETF	127.8	127.82	127.77	127.82	75500.0
2006-01-27 07:50:00	SPY	ETF	127.83	127.83	127.83	127.83	200.0
2006-01-27 07:55:00	SPY	ETF	127.83	127.83	127.83	127.83	200.0
2006-01-27 08:00:00	SPY	ETF	127.86	127.9	127.74	127.9	405200.0
2006-01-27 08:05:00	SPY	ETF	127.9	127.95	127.81	127.86	47700.0
2006-01-27 08:10:00	SPY	ETF	127.86	127.86	127.84	127.86	9600.0
2006-01-27 08:15:00	SPY	ETF	127.87	127.9	127.87	127.89	16900.0
2006-01-27 08:20:00	SPY	ETF	127.9	127.91	127.89	127.89	7400.0
2006-01-27 08:25:00	SPY	ETF	127.88	127.89	127.85	127.89	18500.0
2006-01-27 08:30:00	SPY	ETF	127.89	127.89	127.56	127.66	878600.0
2006-01-27 08:35:00	SPY	ETF	127.66	127.67	127.36	127.49	637500.0
2006-01-27 08:40:00	SPY	ETF	127.48	127.65	127.39	127.62	184500.0
2006-01-27 08:45:00	SPY	ETF	127.6	127.6	127.54	127.54	25000.0
2006-01-27 08:50:00	SPY	ETF	127.54	127.59	127.54	127.59	26300.0
2006-01-27 08:55:00	SPY	ETF	127.6	127.6	127.43	127.47	107000.0
2006-01-27 09:00:00	SPY	ETF	127.44	127.51	127.43	127.49	111300.0
2006-01-27 09:05:00	SPY	ETF	127.49	127.56	127.49	127.54	34600.0
2006-01-27 09:10:00	SPY	ETF	127.56	127.63	127.56	127.59	210800.0
2006-01-27 09:15:00	SPY	ETF	127.59	127.59	127.54	127.55	122800.0
2006-01-27 09:20:00	SPY	ETF	127.55	127.63	127.55	127.63	326300.0
2006-01-27 09:25:00	SPY	ETF	127.63	127.65	127.62	127.65	106400.0
2006-01-27 09:30:00	SPY	ETF	127.66	127.75	127.58	127.58	1841500.0
2006-01-27 09:35:00	SPY	ETF	127.56	127.66	127.45	127.53	1000200.0
2006-01-27 09:40:00	SPY	ETF	127.54	127.76	127.53	127.72	812700.0
2006-01-27 09:45:00	SPY	ETF	127.71	127.83	127.7	127.82	1092900.0
2006-01-27 09:50:00	SPY	ETF	127.81	127.88	127.75	127.88	1084500.0
2006-01-27 09:55:00	SPY	ETF	127.85	127.93	127.8	127.91	1372300.0
2006-01-27 10:00:00	SPY	ETF	127.88	128.12	127.86	128.11	3604900.0
2006-01-27 10:05:00	SPY	ETF	128.09	128.54	128.02	128.37	2209800.0
2006-01-27 10:10:00	SPY	ETF	128.39	128.57	128.35	128.42	1760500.0
2006-01-27 10:15:00	SPY	ETF	128.43	128.63	128.41	128.48	2101700.0
2006-01-27 10:20:00	SPY	ETF	128.48	128.5	128.38	128.42	1092700.0
2006-01-27 10:25:00	SPY	ETF	128.43	128.55	128.33	128.38	2264800.0
2006-01-27 10:30:00	SPY	ETF	128.38	128.4	128.23	128.25	2703200.0
2006-01-27 10:35:00	SPY	ETF	128.25	128.37	128.22	128.33	1046900.0
2006-01-27 10:40:00	SPY	ETF	128.35	128.38	128.27	128.36	478700.0
2006-01-27 10:45:00	SPY	ETF	128.36	128.37	128.24	128.3	613400.0
2006-01-27 10:50:00	SPY	ETF	128.31	128.42	128.28	128.28	759200.0
2006-01-27 10:55:00	SPY	ETF	128.29	128.43	128.28	128.34	800400.0
2006-01-27 11:00:00	SPY	ETF	128.33	128.4	128.25	128.3	746800.0

> showing 50 of 9,598 rows — these rows as CSV

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