PREVIEW / etf_30min / 2006-06-29

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-29.parquet
  size:    75 KB
  rows:    2,580

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-29 06:00:00	SPY	ETF	125.18	125.28	125.18	125.19	54800.0
2006-06-29 06:30:00	SPY	ETF	125.22	125.36	125.22	125.28	50300.0
2006-06-29 07:00:00	SPY	ETF	125.28	125.37	125.22	125.22	56500.0
2006-06-29 07:30:00	SPY	ETF	125.22	125.22	125.17	125.21	17700.0
2006-06-29 08:00:00	SPY	ETF	125.21	125.37	125.18	125.23	281200.0
2006-06-29 08:30:00	SPY	ETF	125.22	125.34	125.18	125.24	1587600.0
2006-06-29 09:00:00	SPY	ETF	125.24	125.25	125.17	125.2	793600.0
2006-06-29 09:30:00	SPY	ETF	125.2	125.59	125.17	125.55	8200000.0
2006-06-29 10:00:00	SPY	ETF	125.55	125.7	125.45	125.54	5342900.0
2006-06-29 10:30:00	SPY	ETF	125.54	125.76	125.49	125.67	4132900.0
2006-06-29 11:00:00	SPY	ETF	125.68	125.92	125.59	125.64	5398500.0
2006-06-29 11:30:00	SPY	ETF	125.65	125.7	125.45	125.5	2842300.0
2006-06-29 12:00:00	SPY	ETF	125.5	125.64	125.42	125.49	3063900.0
2006-06-29 12:30:00	SPY	ETF	125.5	125.52	125.27	125.32	2343800.0
2006-06-29 13:00:00	SPY	ETF	125.32	125.55	125.27	125.43	1915800.0
2006-06-29 13:30:00	SPY	ETF	125.44	125.5	125.39	125.44	1223900.0
2006-06-29 14:00:00	SPY	ETF	125.4312	127.0	125.43	126.23	19209700.0
2006-06-29 14:30:00	SPY	ETF	126.22	126.98	125.81	126.78	18849200.0
2006-06-29 15:00:00	SPY	ETF	126.78	127.11	126.72	127.08	7417900.0
2006-06-29 15:30:00	SPY	ETF	127.1	127.28	126.97	127.24	10465700.0
2006-06-29 16:00:00	SPY	ETF	127.25	127.35	126.53	127.3	2608200.0
2006-06-29 16:30:00	SPY	ETF	127.3	127.32	127.21	127.27	6750200.0
2006-06-29 17:00:00	SPY	ETF	127.27	127.27	127.21	127.24	8300.0
2006-06-29 17:30:00	SPY	ETF	127.27	127.29	127.21	127.27	4200.0
2006-06-29 18:00:00	SPY	ETF	127.25	127.25	127.19	127.2	53200.0
2006-06-29 18:30:00	SPY	ETF	127.23	127.23	127.2	127.23	7700.0
2006-06-29 19:00:00	SPY	ETF	127.25	127.25	127.18	127.18	600.0
2006-06-29 09:30:00	QQQ	ETF	37.96	38.12	37.95	38.1	15140300.0
2006-06-29 10:00:00	QQQ	ETF	38.09	38.2	38.06	38.08	10507700.0
2006-06-29 10:30:00	QQQ	ETF	38.09	38.17	38.04	38.11	5016900.0
2006-06-29 11:00:00	QQQ	ETF	38.12	38.21	38.09	38.11	6612700.0
2006-06-29 11:30:00	QQQ	ETF	38.11	38.13	38.03	38.03	5376100.0
2006-06-29 12:00:00	QQQ	ETF	38.03	38.08	37.99	38.01	3627700.0
2006-06-29 12:30:00	QQQ	ETF	38.01	38.03	37.9	37.91	3676700.0
2006-06-29 13:00:00	QQQ	ETF	37.91	37.99	37.9	37.98	3114700.0
2006-06-29 13:30:00	QQQ	ETF	37.98	38.03	37.98	37.98	3283900.0
2006-06-29 14:00:00	QQQ	ETF	37.98	38.5	37.98	38.35	29731700.0
2006-06-29 14:30:00	QQQ	ETF	38.35	38.74	38.26	38.65	35217400.0
2006-06-29 15:00:00	QQQ	ETF	38.66	38.91	38.64	38.91	23483800.0
2006-06-29 15:30:00	QQQ	ETF	38.91	38.96	38.8	38.95	23152000.0
2006-06-29 07:30:00	IWM	ETF	68.9	68.9	68.9	68.9	10500.0
2006-06-29 08:00:00	IWM	ETF	68.9	69.0	68.9	68.9	47300.0
2006-06-29 08:30:00	IWM	ETF	68.98	68.98	68.84	68.91	261100.0
2006-06-29 09:00:00	IWM	ETF	68.92	68.93	68.83	68.83	489800.0
2006-06-29 09:30:00	IWM	ETF	68.81	69.51	68.81	69.45	10662100.0
2006-06-29 10:00:00	IWM	ETF	69.43	69.62	69.29	69.36	4566400.0
2006-06-29 10:30:00	IWM	ETF	69.36	69.56	69.31	69.49	2387300.0
2006-06-29 11:00:00	IWM	ETF	69.5	69.64	69.41	69.49	3666200.0
2006-06-29 11:30:00	IWM	ETF	69.49	69.5	69.28	69.29	3113700.0
2006-06-29 12:00:00	IWM	ETF	69.28	69.36	69.2	69.26	2037600.0

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

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