PREVIEW / etf_30min / 2005-08-01

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-08-01.parquet
  size:    45 KB
  rows:    1,606

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-08-01 06:00:00	SPY	ETF	123.78	123.8	123.78	123.8	25000.0
2005-08-01 06:30:00	SPY	ETF	123.78	123.78	123.78	123.78	40000.0
2005-08-01 07:00:00	SPY	ETF	123.84	123.84	123.84	123.84	100.0
2005-08-01 07:30:00	SPY	ETF	123.85	123.87	123.76	123.76	6100.0
2005-08-01 08:00:00	SPY	ETF	123.78	123.85	123.78	123.85	62100.0
2005-08-01 08:30:00	SPY	ETF	123.84	123.86	123.8	123.83	176000.0
2005-08-01 09:00:00	SPY	ETF	123.84	123.85	123.8	123.82	42000.0
2005-08-01 09:30:00	SPY	ETF	123.83	123.95	123.73	123.88	4886300.0
2005-08-01 10:00:00	SPY	ETF	123.88	123.96	123.68	123.89	7083500.0
2005-08-01 10:30:00	SPY	ETF	123.89	123.93	123.53	123.66	4975200.0
2005-08-01 11:00:00	SPY	ETF	123.66	123.69	123.45	123.58	2623700.0
2005-08-01 11:30:00	SPY	ETF	123.58	123.87	123.58	123.67	971800.0
2005-08-01 12:00:00	SPY	ETF	123.67	123.82	123.65	123.68	1114900.0
2005-08-01 12:30:00	SPY	ETF	123.69	123.73	123.66	123.68	697500.0
2005-08-01 13:00:00	SPY	ETF	123.681	123.73	123.48	123.57	2249700.0
2005-08-01 13:30:00	SPY	ETF	123.57	123.66	123.55	123.62	1021000.0
2005-08-01 14:00:00	SPY	ETF	123.62	124.03	123.62	123.94	4227300.0
2005-08-01 14:30:00	SPY	ETF	123.94	124.04	123.82	123.83	2102900.0
2005-08-01 15:00:00	SPY	ETF	123.83	123.94	123.81	123.87	1512100.0
2005-08-01 15:30:00	SPY	ETF	123.87	123.92	123.55	123.55	4084100.0
2005-08-01 16:00:00	SPY	ETF	123.54	123.66	123.45	123.6	1190100.0
2005-08-01 16:30:00	SPY	ETF	123.58	123.65	123.58	123.65	2177000.0
2005-08-01 17:00:00	SPY	ETF	123.64	123.72	123.64	123.69	330600.0
2005-08-01 17:30:00	SPY	ETF	123.66	123.66	123.66	123.66	2000.0
2005-08-01 18:00:00	SPY	ETF	123.68	123.7	123.67	123.67	9400.0
2005-08-01 18:30:00	SPY	ETF	123.7	123.7	123.7	123.7	1500.0
2005-08-01 19:00:00	SPY	ETF	123.69	123.69	123.69	123.69	400.0
2005-08-01 09:30:00	QQQ	ETF	39.64	39.74	39.63	39.71	8441300.0
2005-08-01 10:00:00	QQQ	ETF	39.71	39.74	39.65	39.71	4526200.0
2005-08-01 10:30:00	QQQ	ETF	39.7	39.72	39.52	39.58	11929200.0
2005-08-01 11:00:00	QQQ	ETF	39.57	39.62	39.52	39.59	3318500.0
2005-08-01 11:30:00	QQQ	ETF	39.6	39.65	39.59	39.63	2095800.0
2005-08-01 12:00:00	QQQ	ETF	39.63	39.71	39.63	39.66	2695600.0
2005-08-01 12:30:00	QQQ	ETF	39.66	39.67	39.61	39.62	1924800.0
2005-08-01 13:00:00	QQQ	ETF	39.62	39.65	39.55	39.6	2026000.0
2005-08-01 13:30:00	QQQ	ETF	39.59	39.65	39.58	39.62	1264600.0
2005-08-01 14:00:00	QQQ	ETF	39.62	39.8	39.62	39.78	6370400.0
2005-08-01 14:30:00	QQQ	ETF	39.77	39.83	39.71	39.71	3976400.0
2005-08-01 15:00:00	QQQ	ETF	39.72	39.79	39.71	39.76	2018100.0
2005-08-01 15:30:00	QQQ	ETF	39.75	39.77	39.64	39.65	5233700.0
2005-08-01 08:30:00	IWM	ETF	67.94	67.94	67.94	67.94	1000.0
2005-08-01 09:00:00	IWM	ETF	67.86	67.93	67.85	67.93	3500.0
2005-08-01 09:30:00	IWM	ETF	67.94	68.2	67.86	68.15	2316300.0
2005-08-01 10:00:00	IWM	ETF	68.15	68.23	68.0	68.15	1928800.0
2005-08-01 10:30:00	IWM	ETF	68.15	68.19	67.8	67.88	2872900.0
2005-08-01 11:00:00	IWM	ETF	67.88	67.93	67.72	67.91	1217200.0
2005-08-01 11:30:00	IWM	ETF	67.91	68.03	67.89	68.0	658000.0
2005-08-01 12:00:00	IWM	ETF	68.0	68.06	67.88	67.91	507700.0
2005-08-01 12:30:00	IWM	ETF	67.91	67.94	67.85	67.89	260000.0
2005-08-01 13:00:00	IWM	ETF	67.89	67.9	67.76	67.84	693800.0

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

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