PREVIEW / etf_30min / 2005-07-29

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-29.parquet
  size:    45 KB
  rows:    1,594

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
2005-07-29 07:30:00	SPY	ETF	124.7	124.7	124.64	124.65	4200.0
2005-07-29 08:00:00	SPY	ETF	124.7	124.7	124.63	124.67	138200.0
2005-07-29 08:30:00	SPY	ETF	124.65	124.7	124.52	124.54	206400.0
2005-07-29 09:00:00	SPY	ETF	124.54	124.66	124.38	124.41	373700.0
2005-07-29 09:30:00	SPY	ETF	124.41	124.52	124.33	124.51	4208700.0
2005-07-29 10:00:00	SPY	ETF	124.53	124.63	124.18	124.28	7424700.0
2005-07-29 10:30:00	SPY	ETF	124.26	124.29	124.06	124.11	3036000.0
2005-07-29 11:00:00	SPY	ETF	124.11	124.19	123.99	124.07	5006000.0
2005-07-29 11:30:00	SPY	ETF	124.07	124.14	123.86	123.93	6209300.0
2005-07-29 12:00:00	SPY	ETF	123.93	123.99	123.82	123.831	2291700.0
2005-07-29 12:30:00	SPY	ETF	123.81	124.03	123.78	123.93	5553000.0
2005-07-29 13:00:00	SPY	ETF	123.92	124.04	123.88	123.92	1953900.0
2005-07-29 13:30:00	SPY	ETF	123.91	124.07	123.77	124.0	2533200.0
2005-07-29 14:00:00	SPY	ETF	123.99	124.21	123.93	124.09	2221800.0
2005-07-29 14:30:00	SPY	ETF	124.09	124.15	123.96	124.01	1954500.0
2005-07-29 15:00:00	SPY	ETF	124.01	124.07	123.63	123.66	4836900.0
2005-07-29 15:30:00	SPY	ETF	123.65	123.75	123.5	123.56	7799400.0
2005-07-29 16:00:00	SPY	ETF	123.61	124.53	123.53	123.76	3041200.0
2005-07-29 16:30:00	SPY	ETF	123.76	123.8	123.53	123.75	744800.0
2005-07-29 17:00:00	SPY	ETF	123.82	123.84	123.58	123.72	23600.0
2005-07-29 17:30:00	SPY	ETF	123.78	123.79	123.73	123.78	5000.0
2005-07-29 18:30:00	SPY	ETF	123.72	123.72	123.72	123.72	500.0
2005-07-29 19:00:00	SPY	ETF	123.72	123.79	123.72	123.79	1400.0
2005-07-29 19:30:00	SPY	ETF	123.8	123.8	123.8	123.8	500.0
2005-07-29 09:30:00	QQQ	ETF	39.87	39.89	39.8	39.88	8399100.0
2005-07-29 10:00:00	QQQ	ETF	39.89	39.92	39.78	39.81	6312300.0
2005-07-29 10:30:00	QQQ	ETF	39.82	39.82	39.69	39.71	6198500.0
2005-07-29 11:00:00	QQQ	ETF	39.71	39.74	39.65	39.67	6054800.0
2005-07-29 11:30:00	QQQ	ETF	39.68	39.71	39.6	39.63	5628500.0
2005-07-29 12:00:00	QQQ	ETF	39.63	39.65	39.55	39.56	4144100.0
2005-07-29 12:30:00	QQQ	ETF	39.56	39.73	39.54	39.6	5653400.0
2005-07-29 13:00:00	QQQ	ETF	39.6	39.68	39.59	39.63	2783600.0
2005-07-29 13:30:00	QQQ	ETF	39.63	39.69	39.59	39.68	3744800.0
2005-07-29 14:00:00	QQQ	ETF	39.68	39.76	39.66	39.72	5659400.0
2005-07-29 14:30:00	QQQ	ETF	39.72	39.75	39.69	39.71	2581500.0
2005-07-29 15:00:00	QQQ	ETF	39.7	39.72	39.58	39.59	4887300.0
2005-07-29 15:30:00	QQQ	ETF	39.59	39.63	39.52	39.57	8460200.0
2005-07-29 08:00:00	IWM	ETF	68.05	68.05	68.04	68.04	12300.0
2005-07-29 08:30:00	IWM	ETF	68.11	68.11	68.06	68.06	1000.0
2005-07-29 09:00:00	IWM	ETF	68.02	68.02	67.9	68.02	44800.0
2005-07-29 09:30:00	IWM	ETF	68.0	68.18	67.92	68.18	2000600.0
2005-07-29 10:00:00	IWM	ETF	68.18	68.26	67.89	67.92	2184700.0
2005-07-29 10:30:00	IWM	ETF	67.92	67.93	67.77	67.83	1510900.0
2005-07-29 11:00:00	IWM	ETF	67.83	67.94	67.76	67.82	1159100.0
2005-07-29 11:30:00	IWM	ETF	67.83	67.89	67.64	67.67	2322800.0
2005-07-29 12:00:00	IWM	ETF	67.69	67.74	67.58	67.63	730600.0
2005-07-29 12:30:00	IWM	ETF	67.62	67.74	67.48	67.53	3069500.0
2005-07-29 13:00:00	IWM	ETF	67.53	67.65	67.49	67.57	1547200.0
2005-07-29 13:30:00	IWM	ETF	67.56	67.65	67.44	67.64	1362100.0
2005-07-29 14:00:00	IWM	ETF	67.64	67.92	67.6	67.77	1015100.0

> showing 50 of 1,594 rows — these rows as CSV

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