PREVIEW / etf_30min / 2006-06-26

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-26.parquet
  size:    67 KB
  rows:    2,393

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-06-26 05:00:00	SPY	ETF	124.78	124.78	124.78	124.78	200.0
2006-06-26 05:30:00	SPY	ETF	124.64	124.64	124.64	124.64	100.0
2006-06-26 07:00:00	SPY	ETF	124.69	124.69	124.51	124.51	13200.0
2006-06-26 07:30:00	SPY	ETF	124.51	124.61	124.51	124.61	69400.0
2006-06-26 08:00:00	SPY	ETF	124.71	124.71	124.51	124.63	48000.0
2006-06-26 08:30:00	SPY	ETF	124.63	124.65	124.56	124.6	136900.0
2006-06-26 09:00:00	SPY	ETF	124.57	124.63	124.51	124.52	172300.0
2006-06-26 09:30:00	SPY	ETF	124.54	124.68	124.25	124.51	5154800.0
2006-06-26 10:00:00	SPY	ETF	124.52	124.69	124.35	124.66	3470000.0
2006-06-26 10:30:00	SPY	ETF	124.66	124.75	124.46	124.52	2641100.0
2006-06-26 11:00:00	SPY	ETF	124.5205	124.63	124.46	124.52	1711100.0
2006-06-26 11:30:00	SPY	ETF	124.51	124.61	124.3	124.41	1519900.0
2006-06-26 12:00:00	SPY	ETF	124.41	124.55	124.26	124.35	2056700.0
2006-06-26 12:30:00	SPY	ETF	124.35	124.69	124.31	124.66	2214700.0
2006-06-26 13:00:00	SPY	ETF	124.66	124.83	124.55	124.59	2254000.0
2006-06-26 13:30:00	SPY	ETF	124.59	124.68	124.56	124.65	663900.0
2006-06-26 14:00:00	SPY	ETF	124.65	124.73	124.5	124.6	3314300.0
2006-06-26 14:30:00	SPY	ETF	124.59	124.88	124.53	124.74	3635000.0
2006-06-26 15:00:00	SPY	ETF	124.75	124.84	124.65	124.8	1600500.0
2006-06-26 15:30:00	SPY	ETF	124.81	125.05	124.78	125.04	4457700.0
2006-06-26 16:00:00	SPY	ETF	125.03	125.06	124.629	125.0	1098800.0
2006-06-26 16:30:00	SPY	ETF	125.01	125.04	124.99	125.04	31400.0
2006-06-26 17:00:00	SPY	ETF	125.05	125.06	124.91	124.91	64600.0
2006-06-26 17:30:00	SPY	ETF	124.92	124.95	124.92	124.95	18600.0
2006-06-26 18:00:00	SPY	ETF	124.92	124.95	124.87	124.91	40300.0
2006-06-26 18:30:00	SPY	ETF	124.91	124.91	124.91	124.91	100.0
2006-06-26 19:00:00	SPY	ETF	124.94	124.94	124.94	124.94	300.0
2006-06-26 19:30:00	SPY	ETF	124.94	124.94	124.94	124.94	500.0
2006-06-26 09:30:00	QQQ	ETF	38.17	38.29	38.13	38.22	10190300.0
2006-06-26 10:00:00	QQQ	ETF	38.22	38.37	38.14	38.34	8973700.0
2006-06-26 10:30:00	QQQ	ETF	38.34	38.39	38.24	38.26	5970100.0
2006-06-26 11:00:00	QQQ	ETF	38.26	38.31	38.23	38.24	3250400.0
2006-06-26 11:30:00	QQQ	ETF	38.24	38.27	38.14	38.18	3387000.0
2006-06-26 12:00:00	QQQ	ETF	38.19	38.21	38.07	38.11	4106100.0
2006-06-26 12:30:00	QQQ	ETF	38.11	38.21	38.09	38.2	3280000.0
2006-06-26 13:00:00	QQQ	ETF	38.2	38.25	38.15	38.18	4348200.0
2006-06-26 13:30:00	QQQ	ETF	38.17	38.19	38.13	38.17	1213700.0
2006-06-26 14:00:00	QQQ	ETF	38.17	38.21	38.11	38.14	4137300.0
2006-06-26 14:30:00	QQQ	ETF	38.14	38.26	38.13	38.19	3541000.0
2006-06-26 15:00:00	QQQ	ETF	38.19	38.24	38.17	38.22	2057600.0
2006-06-26 15:30:00	QQQ	ETF	38.22	38.29	38.2	38.23	6074600.0
2006-06-26 08:00:00	IWM	ETF	69.2	69.2	69.03	69.03	31100.0
2006-06-26 08:30:00	IWM	ETF	69.06	69.11	69.01	69.03	56600.0
2006-06-26 09:00:00	IWM	ETF	69.04	69.04	68.99	69.03	972900.0
2006-06-26 09:30:00	IWM	ETF	69.02	69.21	68.96	69.11	5329100.0
2006-06-26 10:00:00	IWM	ETF	69.11	69.38	69.0	69.17	3375800.0
2006-06-26 10:30:00	IWM	ETF	69.17	69.27	68.98	69.04	2573200.0
2006-06-26 11:00:00	IWM	ETF	69.05	69.17	69.01	69.05	965900.0
2006-06-26 11:30:00	IWM	ETF	69.04	69.08	68.95	69.02	3114200.0
2006-06-26 12:00:00	IWM	ETF	69.03	69.09	69.0	69.02	1615200.0

> showing 50 of 2,393 rows — these rows as CSV

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