PREVIEW / etf_30min / 2006-03-20

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-03-20.parquet
  size:    58 KB
  rows:    2,216

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-03-20 06:30:00	SPY	ETF	131.39	131.39	131.39	131.39	700.0
2006-03-20 07:00:00	SPY	ETF	130.76	130.81	130.76	130.79	4900.0
2006-03-20 07:30:00	SPY	ETF	130.82	130.85	130.79	130.81	41600.0
2006-03-20 08:00:00	SPY	ETF	130.76	130.85	130.68	130.77	641600.0
2006-03-20 08:30:00	SPY	ETF	130.78	130.8	130.73	130.75	167600.0
2006-03-20 09:00:00	SPY	ETF	130.75	130.78	130.65	130.65	209600.0
2006-03-20 09:30:00	SPY	ETF	130.64	130.9	130.59	130.7	4966400.0
2006-03-20 10:00:00	SPY	ETF	130.7	130.76	130.44	130.49	5113200.0
2006-03-20 10:30:00	SPY	ETF	130.46	130.54	130.21	130.4	8110500.0
2006-03-20 11:00:00	SPY	ETF	130.41	130.54	130.35	130.42	3870200.0
2006-03-20 11:30:00	SPY	ETF	130.43	130.6	130.37	130.57	1786200.0
2006-03-20 12:00:00	SPY	ETF	130.55	130.59	130.37	130.4299	1611600.0
2006-03-20 12:30:00	SPY	ETF	130.43	130.66	130.43	130.63	2695800.0
2006-03-20 13:00:00	SPY	ETF	130.62	130.63	130.49	130.59	915700.0
2006-03-20 13:30:00	SPY	ETF	130.57	130.57	130.31	130.37	2053800.0
2006-03-20 14:00:00	SPY	ETF	130.34	130.5	130.31	130.37	1620600.0
2006-03-20 14:30:00	SPY	ETF	130.37	130.41	130.28	130.35	1365600.0
2006-03-20 15:00:00	SPY	ETF	130.37	130.48	130.29	130.33	1753600.0
2006-03-20 15:30:00	SPY	ETF	130.31	130.55	130.3	130.4	3360700.0
2006-03-20 16:00:00	SPY	ETF	130.39	130.494	130.37	130.4	1073400.0
2006-03-20 16:30:00	SPY	ETF	130.4	130.41	130.36	130.37	20900.0
2006-03-20 17:00:00	SPY	ETF	130.42	130.45	130.31	130.44	704900.0
2006-03-20 17:30:00	SPY	ETF	130.41	130.41	130.4	130.4	500.0
2006-03-20 18:00:00	SPY	ETF	130.4	130.4	130.36	130.36	1200.0
2006-03-20 18:30:00	SPY	ETF	130.36	130.36	130.36	130.36	1500.0
2006-03-20 19:00:00	SPY	ETF	130.35	130.36	130.34	130.36	15000.0
2006-03-20 19:30:00	SPY	ETF	130.35	130.35	130.33	130.33	1300.0
2006-03-20 09:30:00	QQQ	ETF	41.58	41.68	41.51	41.58	8343200.0
2006-03-20 10:00:00	QQQ	ETF	41.57	41.61	41.48	41.49	4557000.0
2006-03-20 10:30:00	QQQ	ETF	41.49	41.54	41.4	41.45	7472200.0
2006-03-20 11:00:00	QQQ	ETF	41.45	41.52	41.42	41.48	4314700.0
2006-03-20 11:30:00	QQQ	ETF	41.47	41.58	41.45	41.56	3475300.0
2006-03-20 12:00:00	QQQ	ETF	41.56	41.57	41.47	41.48	2843200.0
2006-03-20 12:30:00	QQQ	ETF	41.49	41.66	41.49	41.64	5193800.0
2006-03-20 13:00:00	QQQ	ETF	41.64	41.65	41.59	41.62	1992000.0
2006-03-20 13:30:00	QQQ	ETF	41.62	41.63	41.46	41.52	4562000.0
2006-03-20 14:00:00	QQQ	ETF	41.52	41.58	41.5	41.55	2409800.0
2006-03-20 14:30:00	QQQ	ETF	41.54	41.55	41.48	41.49	2035600.0
2006-03-20 15:00:00	QQQ	ETF	41.5	41.55	41.46	41.5	1876900.0
2006-03-20 15:30:00	QQQ	ETF	41.49	41.6	41.49	41.56	6208400.0
2006-03-20 07:30:00	IWM	ETF	74.17	74.17	74.17	74.17	100.0
2006-03-20 08:00:00	IWM	ETF	74.16	74.22	74.16	74.22	10200.0
2006-03-20 08:30:00	IWM	ETF	74.2	74.22	74.15	74.2	568900.0
2006-03-20 09:00:00	IWM	ETF	74.2	74.22	74.16	74.17	60600.0
2006-03-20 09:30:00	IWM	ETF	74.19	74.33	74.05	74.16	1840400.0
2006-03-20 10:00:00	IWM	ETF	74.17	74.23	73.92	73.92	1809000.0
2006-03-20 10:30:00	IWM	ETF	73.93	73.97	73.75	73.88	2688600.0
2006-03-20 11:00:00	IWM	ETF	73.88	73.93	73.71	73.84	2284000.0
2006-03-20 11:30:00	IWM	ETF	73.84	74.05	73.78	74.0	1452500.0
2006-03-20 12:00:00	IWM	ETF	74.0	74.05	73.9	73.93	1100400.0

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

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