PREVIEW / etf_30min / 2006-07-27

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-27.parquet
  size:    78 KB
  rows:    2,701

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-27 05:30:00	SPY	ETF	127.25	127.3	127.25	127.3	1100.0
2006-07-27 06:00:00	SPY	ETF	127.25	127.25	127.25	127.25	2500.0
2006-07-27 07:00:00	SPY	ETF	127.21	127.26	127.19	127.22	39600.0
2006-07-27 07:30:00	SPY	ETF	127.2	127.23	127.2	127.22	51700.0
2006-07-27 08:00:00	SPY	ETF	127.21	127.42	127.19	127.31	1302400.0
2006-07-27 08:30:00	SPY	ETF	127.29	127.37	127.21	127.25	690700.0
2006-07-27 09:00:00	SPY	ETF	127.24	127.45	126.95	127.33	1170200.0
2006-07-27 09:30:00	SPY	ETF	127.33	127.69	127.23	127.29	9736700.0
2006-07-27 10:00:00	SPY	ETF	127.3	127.43	127.09	127.28	10887300.0
2006-07-27 10:30:00	SPY	ETF	127.29	127.47	126.94	127.24	9188300.0
2006-07-27 11:00:00	SPY	ETF	127.23	127.51	127.1	127.46	5353000.0
2006-07-27 11:30:00	SPY	ETF	127.47	127.5	127.17	127.23	4589000.0
2006-07-27 12:00:00	SPY	ETF	127.22	127.43	127.12	127.28	1848200.0
2006-07-27 12:30:00	SPY	ETF	127.28	127.4	127.2	127.28	1917300.0
2006-07-27 13:00:00	SPY	ETF	127.28	127.31	126.98	127.03	4080700.0
2006-07-27 13:30:00	SPY	ETF	127.04	127.07	126.55	126.57	9613300.0
2006-07-27 14:00:00	SPY	ETF	126.56	126.7	126.38	126.66	7331700.0
2006-07-27 14:30:00	SPY	ETF	126.66	126.73	126.49	126.64	3108600.0
2006-07-27 15:00:00	SPY	ETF	126.64	126.73	126.22	126.25	6464700.0
2006-07-27 15:30:00	SPY	ETF	126.26	126.58	126.2	126.37	6137600.0
2006-07-27 16:00:00	SPY	ETF	126.37	127.23	126.36	126.67	750100.0
2006-07-27 16:30:00	SPY	ETF	126.67	126.67	126.36	126.64	452200.0
2006-07-27 17:00:00	SPY	ETF	126.66	126.67	126.64	126.65	1800.0
2006-07-27 17:30:00	SPY	ETF	126.65	126.68	126.65	126.65	5800.0
2006-07-27 18:00:00	SPY	ETF	126.65	126.65	126.61	126.61	800.0
2006-07-27 18:30:00	SPY	ETF	126.64	126.64	126.64	126.64	300.0
2006-07-27 19:00:00	SPY	ETF	126.64	126.64	126.64	126.64	500.0
2006-07-27 19:30:00	SPY	ETF	126.64	126.64	126.64	126.64	3200.0
2006-07-27 09:30:00	QQQ	ETF	36.74	37.04	36.73	36.87	18423200.0
2006-07-27 10:00:00	QQQ	ETF	36.87	37.0	36.74	36.84	9338300.0
2006-07-27 10:30:00	QQQ	ETF	36.84	36.9	36.66	36.76	8406800.0
2006-07-27 11:00:00	QQQ	ETF	36.76	36.89	36.71	36.87	6221400.0
2006-07-27 11:30:00	QQQ	ETF	36.87	36.88	36.76	36.78	2387000.0
2006-07-27 12:00:00	QQQ	ETF	36.78	36.88	36.75	36.83	2317300.0
2006-07-27 12:30:00	QQQ	ETF	36.83	36.85	36.75	36.76	1944300.0
2006-07-27 13:00:00	QQQ	ETF	36.76	36.77	36.57	36.6	6919500.0
2006-07-27 13:30:00	QQQ	ETF	36.6	36.61	36.33	36.33	10163300.0
2006-07-27 14:00:00	QQQ	ETF	36.34	36.43	36.25	36.39	9781100.0
2006-07-27 14:30:00	QQQ	ETF	36.39	36.43	36.31	36.41	3397800.0
2006-07-27 15:00:00	QQQ	ETF	36.41	36.45	36.29	36.3	6305000.0
2006-07-27 15:30:00	QQQ	ETF	36.31	36.43	36.28	36.35	9328100.0
2006-07-27 08:00:00	IWM	ETF	69.25	69.45	69.25	69.42	111000.0
2006-07-27 08:30:00	IWM	ETF	69.39	69.4	69.2	69.34	126500.0
2006-07-27 09:00:00	IWM	ETF	69.34	69.46	67.58	69.41	365600.0
2006-07-27 09:30:00	IWM	ETF	69.41	69.89	69.3	69.34	6767600.0
2006-07-27 10:00:00	IWM	ETF	69.33	69.41	68.99	69.07	5123800.0
2006-07-27 10:30:00	IWM	ETF	69.08	69.27	68.85	69.11	4993200.0
2006-07-27 11:00:00	IWM	ETF	69.11	69.43	68.93	69.4	5363000.0
2006-07-27 11:30:00	IWM	ETF	69.39	69.4	69.13	69.2	2159200.0
2006-07-27 12:00:00	IWM	ETF	69.2	69.44	69.13	69.34	2842500.0

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

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