PREVIEW / etf_30min / 2006-07-19

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-19.parquet
  size:    79 KB
  rows:    2,684

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-07-19 06:00:00	SPY	ETF	123.97	123.97	123.97	123.97	100.0
2006-07-19 06:30:00	SPY	ETF	124.02	124.02	124.02	124.02	2500.0
2006-07-19 07:00:00	SPY	ETF	124.06	124.06	123.9	123.96	255600.0
2006-07-19 07:30:00	SPY	ETF	123.95	123.98	123.93	123.93	55900.0
2006-07-19 08:00:00	SPY	ETF	123.92	124.53	123.9	124.32	5273700.0
2006-07-19 08:30:00	SPY	ETF	124.31	124.35	123.79	124.21	7993800.0
2006-07-19 09:00:00	SPY	ETF	124.22	124.3	124.04	124.19	2253900.0
2006-07-19 09:30:00	SPY	ETF	124.18	124.75	124.15	124.7	14397000.0
2006-07-19 10:00:00	SPY	ETF	124.7	125.51	124.61	125.08	25835900.0
2006-07-19 10:30:00	SPY	ETF	125.08	125.82	125.03	125.64	18445600.0
2006-07-19 11:00:00	SPY	ETF	125.64	125.74	125.49	125.59	6387800.0
2006-07-19 11:30:00	SPY	ETF	125.6	125.7	125.44	125.51	5182000.0
2006-07-19 12:00:00	SPY	ETF	125.51	125.62	125.32	125.5	4753400.0
2006-07-19 12:30:00	SPY	ETF	125.5	125.7	125.42	125.66	2596800.0
2006-07-19 13:00:00	SPY	ETF	125.64	126.08	125.61	125.94	7106000.0
2006-07-19 13:30:00	SPY	ETF	125.94	126.0	125.72	125.8	5129400.0
2006-07-19 14:00:00	SPY	ETF	125.82	126.1	125.75	125.97	4039900.0
2006-07-19 14:30:00	SPY	ETF	125.98	126.26	125.95	126.13	4665400.0
2006-07-19 15:00:00	SPY	ETF	126.14	126.18	125.92	126.13	4222200.0
2006-07-19 15:30:00	SPY	ETF	126.13	126.24	125.89	125.98	8876200.0
2006-07-19 16:00:00	SPY	ETF	125.97	126.2097	125.55	125.69	1211300.0
2006-07-19 16:30:00	SPY	ETF	125.69	125.84	125.59	125.84	223000.0
2006-07-19 17:00:00	SPY	ETF	125.84	125.88	125.79	125.82	71200.0
2006-07-19 17:30:00	SPY	ETF	125.82	125.87	125.82	125.87	175100.0
2006-07-19 18:00:00	SPY	ETF	125.86	125.93	125.0943	125.93	637400.0
2006-07-19 18:30:00	SPY	ETF	125.94	125.94	125.86	125.88	13500.0
2006-07-19 19:00:00	SPY	ETF	125.84	125.84	125.84	125.84	100.0
2006-07-19 09:30:00	QQQ	ETF	36.1	36.34	36.09	36.3	18511600.0
2006-07-19 10:00:00	QQQ	ETF	36.3	36.56	36.15	36.28	38104300.0
2006-07-19 10:30:00	QQQ	ETF	36.28	39.5	36.25	36.43	21405200.0
2006-07-19 11:00:00	QQQ	ETF	36.43	36.58	36.4	36.51	8744200.0
2006-07-19 11:30:00	QQQ	ETF	36.5	36.6	36.44	36.5	7828100.0
2006-07-19 12:00:00	QQQ	ETF	36.49	36.49	36.37	36.45	8666900.0
2006-07-19 12:30:00	QQQ	ETF	36.45	36.62	36.45	36.61	11434100.0
2006-07-19 13:00:00	QQQ	ETF	36.6	36.77	36.58	36.71	12415400.0
2006-07-19 13:30:00	QQQ	ETF	36.71	36.78	36.64	36.67	8064200.0
2006-07-19 14:00:00	QQQ	ETF	36.66	36.81	36.61	36.78	6392900.0
2006-07-19 14:30:00	QQQ	ETF	36.77	36.83	36.72	36.76	6187200.0
2006-07-19 15:00:00	QQQ	ETF	36.77	36.79	36.64	36.74	7416200.0
2006-07-19 15:30:00	QQQ	ETF	36.73	36.76	36.57	36.59	13060700.0
2006-07-19 07:30:00	IWM	ETF	67.8	67.87	67.8	67.86	2000.0
2006-07-19 08:00:00	IWM	ETF	67.85	68.36	67.85	68.31	1214300.0
2006-07-19 08:30:00	IWM	ETF	68.25	68.28	67.55	68.02	1605400.0
2006-07-19 09:00:00	IWM	ETF	68.01	68.01	67.57	67.82	250000.0
2006-07-19 09:30:00	IWM	ETF	67.84	68.71	67.78	68.64	13100200.0
2006-07-19 10:00:00	IWM	ETF	68.66	69.52	68.5	69.3	23577200.0
2006-07-19 10:30:00	IWM	ETF	69.3	69.63	69.1	69.38	10881800.0
2006-07-19 11:00:00	IWM	ETF	69.37	69.5	69.15	69.41	3814800.0
2006-07-19 11:30:00	IWM	ETF	69.41	69.51	69.29	69.38	3297100.0
2006-07-19 12:00:00	IWM	ETF	69.37	69.39	69.14	69.3	4204600.0

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

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