PREVIEW / etf_30min / 2006-06-21

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-21.parquet
  size:    69 KB
  rows:    2,429

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-21 06:00:00	SPY	ETF	124.01	124.02	124.01	124.02	25000.0
2006-06-21 07:00:00	SPY	ETF	123.84	123.84	123.8	123.8	36400.0
2006-06-21 07:30:00	SPY	ETF	123.84	123.95	123.8	123.91	36800.0
2006-06-21 08:00:00	SPY	ETF	123.88	124.16	123.81	124.0	325800.0
2006-06-21 08:30:00	SPY	ETF	123.98	124.08	123.93	124.03	211500.0
2006-06-21 09:00:00	SPY	ETF	123.99	124.1	123.97	124.02	372000.0
2006-06-21 09:30:00	SPY	ETF	124.0	124.79	123.96	124.58	9529500.0
2006-06-21 10:00:00	SPY	ETF	124.58	124.96	124.58	124.74	6231800.0
2006-06-21 10:30:00	SPY	ETF	124.73	125.01	124.6	124.63	6228100.0
2006-06-21 11:00:00	SPY	ETF	124.62	125.17	124.62	125.14	5183200.0
2006-06-21 11:30:00	SPY	ETF	125.14	125.41	125.08	125.24	4857900.0
2006-06-21 12:00:00	SPY	ETF	125.22	125.64	125.22	125.42	8531500.0
2006-06-21 12:30:00	SPY	ETF	125.42	125.55	125.36	125.46	2754500.0
2006-06-21 13:00:00	SPY	ETF	125.46	125.54	125.34	125.37	4136700.0
2006-06-21 13:30:00	SPY	ETF	125.37	125.7	125.33	125.62	3481800.0
2006-06-21 14:00:00	SPY	ETF	125.63	125.69	125.51	125.56	2404600.0
2006-06-21 14:30:00	SPY	ETF	125.56	125.7	125.42	125.55	3525300.0
2006-06-21 15:00:00	SPY	ETF	125.5599	125.56	125.33	125.38	4061100.0
2006-06-21 15:30:00	SPY	ETF	125.37	125.64	124.96	125.13	9294900.0
2006-06-21 16:00:00	SPY	ETF	125.13	125.2	125.04	125.12	976200.0
2006-06-21 16:30:00	SPY	ETF	125.12	125.15	125.12	125.13	26500.0
2006-06-21 17:00:00	SPY	ETF	125.14	125.15	125.12	125.15	71900.0
2006-06-21 17:30:00	SPY	ETF	125.14	125.14	125.13	125.14	10900.0
2006-06-21 18:00:00	SPY	ETF	125.14	125.21	125.14	125.21	29400.0
2006-06-21 19:00:00	SPY	ETF	125.13	125.18	125.13	125.18	5700.0
2006-06-21 09:30:00	QQQ	ETF	38.14	38.35	38.13	38.31	10875400.0
2006-06-21 10:00:00	QQQ	ETF	38.31	38.54	38.3	38.5	13039400.0
2006-06-21 10:30:00	QQQ	ETF	38.51	38.62	38.48	38.51	10540800.0
2006-06-21 11:00:00	QQQ	ETF	38.51	38.72	38.5	38.7	8305900.0
2006-06-21 11:30:00	QQQ	ETF	38.7	38.79	38.68	38.7	7702800.0
2006-06-21 12:00:00	QQQ	ETF	38.7	38.87	38.7	38.82	10755500.0
2006-06-21 12:30:00	QQQ	ETF	38.83	38.85	38.75	38.77	3070000.0
2006-06-21 13:00:00	QQQ	ETF	38.77	38.82	38.76	38.77	4641700.0
2006-06-21 13:30:00	QQQ	ETF	38.77	38.95	38.76	38.91	9275300.0
2006-06-21 14:00:00	QQQ	ETF	38.91	38.99	38.9	38.94	7449200.0
2006-06-21 14:30:00	QQQ	ETF	38.94	38.95	38.81	38.91	6846200.0
2006-06-21 15:00:00	QQQ	ETF	38.91	38.95	38.82	38.84	4995500.0
2006-06-21 15:30:00	QQQ	ETF	38.84	38.84	38.63	38.69	23828900.0
2006-06-21 07:30:00	IWM	ETF	67.25	67.25	67.25	67.25	100.0
2006-06-21 08:00:00	IWM	ETF	67.22	67.4	67.2	67.3	21700.0
2006-06-21 08:30:00	IWM	ETF	67.25	67.34	67.22	67.28	153100.0
2006-06-21 09:00:00	IWM	ETF	67.28	67.4	67.23	67.37	512300.0
2006-06-21 09:30:00	IWM	ETF	67.37	68.1	67.25	67.93	14193100.0
2006-06-21 10:00:00	IWM	ETF	67.93	68.22	67.84	67.98	6794800.0
2006-06-21 10:30:00	IWM	ETF	67.97	68.23	67.93	67.96	4971300.0
2006-06-21 11:00:00	IWM	ETF	67.96	68.57	67.95	68.5	4923500.0
2006-06-21 11:30:00	IWM	ETF	68.5	68.84	68.45	68.68	7630000.0
2006-06-21 12:00:00	IWM	ETF	68.68	68.97	68.66	68.87	6172500.0
2006-06-21 12:30:00	IWM	ETF	68.87	68.95	68.77	68.87	5426200.0
2006-06-21 13:00:00	IWM	ETF	68.87	68.92	68.7301	68.7301	2282000.0

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

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