PREVIEW / etf_30min / 2003-09-19

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-09-19.parquet
  size:    23 KB
  rows:    730

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
2003-09-19 08:00:00	SPY	ETF	104.06	104.11	104.03	104.11	22300.0
2003-09-19 08:30:00	SPY	ETF	104.13	104.26	104.09	104.21	50800.0
2003-09-19 09:00:00	SPY	ETF	104.33	104.34	104.19	104.25	38900.0
2003-09-19 09:30:00	SPY	ETF	104.27	104.27	103.82	103.92	3946600.0
2003-09-19 10:00:00	SPY	ETF	103.89	104.16	103.77	103.98	2741800.0
2003-09-19 10:30:00	SPY	ETF	103.95	103.98	103.57	103.69	3018900.0
2003-09-19 11:00:00	SPY	ETF	103.71	103.82	103.66	103.74	1547000.0
2003-09-19 11:30:00	SPY	ETF	103.75	103.93	103.71	103.82	1037500.0
2003-09-19 12:00:00	SPY	ETF	103.82	103.9	103.75	103.79	814200.0
2003-09-19 12:30:00	SPY	ETF	103.77	103.96	103.649	103.68	858100.0
2003-09-19 13:00:00	SPY	ETF	103.67	103.77	103.63	103.68	629100.0
2003-09-19 13:30:00	SPY	ETF	103.67	103.76	103.53	103.57	1058700.0
2003-09-19 14:00:00	SPY	ETF	103.57	103.58	103.4	103.52	1376600.0
2003-09-19 14:30:00	SPY	ETF	103.51	103.8	103.459	103.79	1310800.0
2003-09-19 15:00:00	SPY	ETF	103.78	103.85	103.68	103.84	1011500.0
2003-09-19 15:30:00	SPY	ETF	103.85	103.98	103.76	103.86	2385100.0
2003-09-19 16:00:00	SPY	ETF	103.84	104.1	103.66	103.7	6394400.0
2003-09-19 16:30:00	SPY	ETF	103.7	103.7	103.58	103.58	39000.0
2003-09-19 17:00:00	SPY	ETF	103.58	103.65	103.51	103.65	44800.0
2003-09-19 17:30:00	SPY	ETF	103.66	103.73	103.65	103.69	3600.0
2003-09-19 18:00:00	SPY	ETF	103.69	103.7	103.65	103.7	15900.0
2003-09-19 18:30:00	SPY	ETF	103.71	103.71	103.7	103.7	1900.0
2003-09-19 19:00:00	SPY	ETF	103.7	103.7	103.68	103.68	2700.0
2003-09-19 19:30:00	SPY	ETF	103.68	103.68	103.67	103.67	700.0
2003-09-19 08:00:00	QQQ	ETF	34.71	34.71	34.67	34.71	26400.0
2003-09-19 08:30:00	QQQ	ETF	34.71	34.77	34.69	34.77	44900.0
2003-09-19 09:00:00	QQQ	ETF	34.77	34.81	34.74	34.8	225400.0
2003-09-19 09:30:00	QQQ	ETF	34.79	34.84	34.58	34.635	7954800.0
2003-09-19 10:00:00	QQQ	ETF	34.64	34.79	34.58	34.71	5859300.0
2003-09-19 10:30:00	QQQ	ETF	34.7	34.72	34.47	34.54	11553600.0
2003-09-19 11:00:00	QQQ	ETF	34.54	34.61	34.48	34.533	3673300.0
2003-09-19 11:30:00	QQQ	ETF	34.52	34.653	34.51	34.61	3146900.0
2003-09-19 12:00:00	QQQ	ETF	34.61	34.67	34.58	34.62	2728400.0
2003-09-19 12:30:00	QQQ	ETF	34.619	34.68	34.55	34.57	3279100.0
2003-09-19 13:00:00	QQQ	ETF	34.57	34.6	34.55	34.57	2357600.0
2003-09-19 13:30:00	QQQ	ETF	34.58	34.59	34.4	34.44	3696100.0
2003-09-19 14:00:00	QQQ	ETF	34.46	34.48	34.36	34.448	4538400.0
2003-09-19 14:30:00	QQQ	ETF	34.448	34.6	34.42	34.576	3370900.0
2003-09-19 15:00:00	QQQ	ETF	34.57	34.64	34.51	34.62	3631400.0
2003-09-19 15:30:00	QQQ	ETF	34.625	34.67	34.58	34.6	4341300.0
2003-09-19 16:00:00	QQQ	ETF	34.6	34.64	34.53	34.58	1746300.0
2003-09-19 16:30:00	QQQ	ETF	34.57	34.58	34.5	34.53	64400.0
2003-09-19 17:00:00	QQQ	ETF	34.51	34.54	34.48	34.53	65300.0
2003-09-19 17:30:00	QQQ	ETF	34.53	34.57	34.51	34.57	28200.0
2003-09-19 18:00:00	QQQ	ETF	34.54	34.54	34.52	34.52	2500.0
2003-09-19 18:30:00	QQQ	ETF	34.55	34.55	34.47	34.47	4300.0
2003-09-19 19:00:00	QQQ	ETF	34.54	34.54	34.48	34.48	500.0
2003-09-19 19:30:00	QQQ	ETF	34.54	34.55	34.54	34.55	1600.0
2003-09-19 09:30:00	IWM	ETF	51.95	51.95	51.545	51.62	404800.0
2003-09-19 10:00:00	IWM	ETF	51.64	51.85	51.615	51.715	431800.0

> showing 50 of 730 rows — these rows as CSV

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