PREVIEW / etf_5min / 2008-06-30

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-06-30.parquet
  size:    498 KB
  rows:    23,521

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
2008-06-30 04:05:00	SPY	ETF	127.93	127.93	127.93	127.93	2000.0
2008-06-30 04:25:00	SPY	ETF	127.78	127.78	127.78	127.78	1000.0
2008-06-30 04:45:00	SPY	ETF	127.5	127.5	127.45	127.45	300.0
2008-06-30 04:50:00	SPY	ETF	127.33	127.33	127.33	127.33	100.0
2008-06-30 05:00:00	SPY	ETF	127.47	127.47	127.47	127.47	500.0
2008-06-30 05:45:00	SPY	ETF	127.56	127.56	127.56	127.56	1000.0
2008-06-30 05:50:00	SPY	ETF	127.66	127.66	127.66	127.66	1000.0
2008-06-30 06:05:00	SPY	ETF	127.87	127.87	127.87	127.87	1000.0
2008-06-30 06:25:00	SPY	ETF	127.69	127.69	127.69	127.69	100.0
2008-06-30 06:30:00	SPY	ETF	127.49	127.49	127.48	127.48	10200.0
2008-06-30 06:35:00	SPY	ETF	127.49	127.49	127.49	127.49	5000.0
2008-06-30 06:40:00	SPY	ETF	127.49	127.49	127.49	127.49	5000.0
2008-06-30 06:45:00	SPY	ETF	127.6	127.6	127.6	127.6	5000.0
2008-06-30 06:50:00	SPY	ETF	127.53	127.65	127.53	127.6	37000.0
2008-06-30 06:55:00	SPY	ETF	127.79	127.79	127.62	127.62	3500.0
2008-06-30 07:00:00	SPY	ETF	127.73	127.76	127.73	127.73	91981.0
2008-06-30 07:05:00	SPY	ETF	127.73	127.73	127.69	127.69	147419.0
2008-06-30 07:10:00	SPY	ETF	127.66	127.82	127.6	127.82	186200.0
2008-06-30 07:15:00	SPY	ETF	127.82	127.85	127.72	127.72	141000.0
2008-06-30 07:20:00	SPY	ETF	127.72	127.8	127.72	127.74	30700.0
2008-06-30 07:25:00	SPY	ETF	127.75	127.8	127.7	127.8	18800.0
2008-06-30 07:30:00	SPY	ETF	127.8	127.81	127.75	127.75	13700.0
2008-06-30 07:35:00	SPY	ETF	127.77	127.78	127.77	127.78	4100.0
2008-06-30 07:40:00	SPY	ETF	127.73	127.74	127.7	127.74	6800.0
2008-06-30 07:45:00	SPY	ETF	127.7	127.73	127.65	127.65	39546.0
2008-06-30 07:50:00	SPY	ETF	127.61	127.61	127.39	127.4	189446.0
2008-06-30 07:55:00	SPY	ETF	127.42	127.42	127.37	127.37	80034.0
2008-06-30 08:00:00	SPY	ETF	127.38	127.78	127.38	127.54	1297635.0
2008-06-30 08:05:00	SPY	ETF	127.53	127.56	127.45	127.52	107783.0
2008-06-30 08:10:00	SPY	ETF	127.49	127.62	127.49	127.58	139342.0
2008-06-30 08:15:00	SPY	ETF	127.6	127.79	127.6	127.79	327501.0
2008-06-30 08:20:00	SPY	ETF	127.8	127.95	127.8	127.89	622185.0
2008-06-30 08:25:00	SPY	ETF	127.9	127.9	127.83	127.85	159096.0
2008-06-30 08:30:00	SPY	ETF	127.86	127.88	127.79	127.88	146518.0
2008-06-30 08:35:00	SPY	ETF	127.91	127.95	127.83	127.89	203571.0
2008-06-30 08:40:00	SPY	ETF	127.89	127.94	127.82	127.84	185711.0
2008-06-30 08:45:00	SPY	ETF	127.84	127.84	127.74	127.75	84547.0
2008-06-30 08:50:00	SPY	ETF	127.75	127.85	127.73	127.84	47903.0
2008-06-30 08:55:00	SPY	ETF	127.82	127.96	127.79	127.94	499884.0
2008-06-30 09:00:00	SPY	ETF	127.94	127.96	127.89	127.89	222891.0
2008-06-30 09:05:00	SPY	ETF	127.87	127.9	127.83	127.83	208999.0
2008-06-30 09:10:00	SPY	ETF	127.84	127.89	127.77	127.8	115604.0
2008-06-30 09:15:00	SPY	ETF	127.79	127.82	127.74	127.78	350712.0
2008-06-30 09:20:00	SPY	ETF	127.77	127.82	127.75	127.81	117518.0
2008-06-30 09:25:00	SPY	ETF	127.79	127.9	127.78	127.89	385847.0
2008-06-30 09:30:00	SPY	ETF	127.89	127.98	127.76	127.98	3419245.0
2008-06-30 09:35:00	SPY	ETF	127.98	128.21	127.97	128.07	4425162.0
2008-06-30 09:40:00	SPY	ETF	128.09	128.22	127.94	128.17	4039119.0
2008-06-30 09:45:00	SPY	ETF	128.19	128.33	128.01	128.02	5334744.0
2008-06-30 09:50:00	SPY	ETF	128.02	128.03	127.77	127.9	2598520.0

> showing 50 of 23,521 rows — these rows as CSV

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