PREVIEW / etf_30min / 2003-06-13

all etf 30-min files

  file:    by_date/etf_30min/2003/2003-06-13.parquet
  size:    24 KB
  rows:    736

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-06-13 08:00:00	SPY	ETF	100.5	100.63	100.5	100.63	13400.0
2003-06-13 08:30:00	SPY	ETF	100.62	100.77	100.55	100.72	24300.0
2003-06-13 09:00:00	SPY	ETF	100.7	100.75	100.55	100.59	31600.0
2003-06-13 09:30:00	SPY	ETF	100.61	100.74	99.97	100.12	8497300.0
2003-06-13 10:00:00	SPY	ETF	100.12	100.21	99.51	99.79	6516800.0
2003-06-13 10:30:00	SPY	ETF	99.79	99.81	99.43	99.47	2669300.0
2003-06-13 11:00:00	SPY	ETF	99.47	99.53	99.14	99.3	4048700.0
2003-06-13 11:30:00	SPY	ETF	99.32	99.46	99.27	99.32	1850400.0
2003-06-13 12:00:00	SPY	ETF	99.32	99.41	99.16	99.34	2232000.0
2003-06-13 12:30:00	SPY	ETF	99.34	99.51	99.3	99.37	1017600.0
2003-06-13 13:00:00	SPY	ETF	99.37	99.47	99.17	99.24	774300.0
2003-06-13 13:30:00	SPY	ETF	99.25	99.27	98.95	99.02	3006800.0
2003-06-13 14:00:00	SPY	ETF	99.02	99.32	98.96	99.28	1094900.0
2003-06-13 14:30:00	SPY	ETF	99.27	99.37	99.12	99.19	1527100.0
2003-06-13 15:00:00	SPY	ETF	99.17	99.51	99.03	99.49	1708300.0
2003-06-13 15:30:00	SPY	ETF	99.48	99.62	99.29	99.43	3186400.0
2003-06-13 16:00:00	SPY	ETF	99.44	99.59	99.2	99.57	5461000.0
2003-06-13 16:30:00	SPY	ETF	99.54	99.59	99.52	99.59	139000.0
2003-06-13 17:00:00	SPY	ETF	99.52	99.55	99.4	99.42	13600.0
2003-06-13 17:30:00	SPY	ETF	99.41	99.41	99.38	99.38	5700.0
2003-06-13 18:00:00	SPY	ETF	99.43	99.46	99.43	99.46	1200.0
2003-06-13 18:30:00	SPY	ETF	99.46	99.46	99.4	99.4	1400.0
2003-06-13 19:00:00	SPY	ETF	99.4	99.4	99.32	99.32	3600.0
2003-06-13 19:30:00	SPY	ETF	99.45	99.45	99.45	99.45	500.0
2003-06-13 20:00:00	SPY	ETF	99.46	99.46	99.46	99.46	100.0
2003-06-13 08:00:00	QQQ	ETF	30.61	30.67	30.6	30.64	30800.0
2003-06-13 08:30:00	QQQ	ETF	30.66	30.67	30.62	30.64	34700.0
2003-06-13 09:00:00	QQQ	ETF	30.66	30.68	30.62	30.62	132300.0
2003-06-13 09:30:00	QQQ	ETF	30.65	30.73	30.37	30.44	11030800.0
2003-06-13 10:00:00	QQQ	ETF	30.44	30.48	30.06	30.18	13365100.0
2003-06-13 10:30:00	QQQ	ETF	30.18	30.21	30.05	30.08	6817100.0
2003-06-13 11:00:00	QQQ	ETF	30.08	30.14	29.92	30.0	6913200.0
2003-06-13 11:30:00	QQQ	ETF	30.0	30.08	29.96	30.02	3350000.0
2003-06-13 12:00:00	QQQ	ETF	30.02	30.06	29.97	30.04	2056500.0
2003-06-13 12:30:00	QQQ	ETF	30.03	30.1	30.0	30.03	2380800.0
2003-06-13 13:00:00	QQQ	ETF	30.04	30.07	29.97	30.0	1520300.0
2003-06-13 13:30:00	QQQ	ETF	29.99	30.0	29.88	29.92	3684800.0
2003-06-13 14:00:00	QQQ	ETF	29.92	30.01	29.88	29.99	3254000.0
2003-06-13 14:30:00	QQQ	ETF	29.99	30.04	29.9	29.92	3898100.0
2003-06-13 15:00:00	QQQ	ETF	29.93	30.04	29.86	30.04	4753700.0
2003-06-13 15:30:00	QQQ	ETF	30.02	30.1	29.86	29.98	6899600.0
2003-06-13 16:00:00	QQQ	ETF	29.94	30.01	29.92	29.98	1505800.0
2003-06-13 16:30:00	QQQ	ETF	29.98	30.0	29.96	29.98	90400.0
2003-06-13 17:00:00	QQQ	ETF	29.97	29.98	29.96	29.97	15300.0
2003-06-13 17:30:00	QQQ	ETF	29.96	30.0	29.96	29.96	14600.0
2003-06-13 18:00:00	QQQ	ETF	29.96	30.01	29.96	29.98	9800.0
2003-06-13 18:30:00	QQQ	ETF	29.97	30.0	29.92	29.97	27900.0
2003-06-13 19:00:00	QQQ	ETF	29.97	29.97	29.93	29.96	3700.0
2003-06-13 19:30:00	QQQ	ETF	29.93	29.97	29.93	29.96	7600.0
2003-06-13 09:30:00	IWM	ETF	45.675	45.695	45.3	45.395	239800.0

> showing 50 of 736 rows — these rows as CSV

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