PREVIEW / etf_30min / 2009-12-15

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-15.parquet
  size:    228 KB
  rows:    7,769

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
2009-12-15 04:00:00	SPY	ETF	111.61	111.61	111.55	111.59	2445.0
2009-12-15 04:30:00	SPY	ETF	111.5	111.5	111.5	111.5	100.0
2009-12-15 05:00:00	SPY	ETF	111.5	111.5	111.5	111.5	12700.0
2009-12-15 05:30:00	SPY	ETF	111.53	111.53	111.52	111.52	1100.0
2009-12-15 06:00:00	SPY	ETF	111.57	111.57	111.47	111.47	2600.0
2009-12-15 06:30:00	SPY	ETF	111.52	111.52	111.48	111.51	25100.0
2009-12-15 07:00:00	SPY	ETF	111.56	111.58	111.45	111.45	153951.0
2009-12-15 07:30:00	SPY	ETF	111.43	111.6	111.42	111.54	105009.0
2009-12-15 08:00:00	SPY	ETF	111.54	111.87	111.4	111.47	993285.0
2009-12-15 08:30:00	SPY	ETF	111.41	111.54	111.19	111.36	3000401.0
2009-12-15 09:00:00	SPY	ETF	111.36	111.51	111.33	111.45	1430642.0
2009-12-15 09:30:00	SPY	ETF	111.46	111.56	111.3	111.37	16413156.0
2009-12-15 10:00:00	SPY	ETF	111.37	111.72	111.34	111.63	13869427.0
2009-12-15 10:30:00	SPY	ETF	111.63	111.92	111.62	111.82	7783122.0
2009-12-15 11:00:00	SPY	ETF	111.82	111.86	111.69	111.71	4888290.0
2009-12-15 11:30:00	SPY	ETF	111.71	111.9024	111.64	111.69	5698765.0
2009-12-15 12:00:00	SPY	ETF	111.69	111.77	111.62	111.66	3243301.0
2009-12-15 12:30:00	SPY	ETF	111.655	111.66	111.51	111.56	4450242.0
2009-12-15 13:00:00	SPY	ETF	111.56	111.63	111.41	111.43	5888942.0
2009-12-15 13:30:00	SPY	ETF	111.43	111.57	111.39	111.5191	5058914.0
2009-12-15 14:00:00	SPY	ETF	111.51	111.58	111.48	111.52	3482099.0
2009-12-15 14:30:00	SPY	ETF	111.53	111.57	111.44	111.46	4105782.0
2009-12-15 15:00:00	SPY	ETF	111.46	111.56	111.24	111.29	9245931.0
2009-12-15 15:30:00	SPY	ETF	111.3	111.9024	111.0	111.31	19776675.0
2009-12-15 16:00:00	SPY	ETF	111.32	111.9024	111.12	111.37	7688642.0
2009-12-15 16:30:00	SPY	ETF	111.35	111.47	111.29	111.41	1022467.0
2009-12-15 17:00:00	SPY	ETF	111.43	111.44	111.3	111.3	60224.0
2009-12-15 17:30:00	SPY	ETF	111.42	111.44	111.38	111.4	53271.0
2009-12-15 18:00:00	SPY	ETF	111.4	111.41	111.36	111.37	16787.0
2009-12-15 18:30:00	SPY	ETF	111.38	111.4	111.35	111.38	7409.0
2009-12-15 19:00:00	SPY	ETF	111.42	111.42	111.35	111.38	8687.0
2009-12-15 19:30:00	SPY	ETF	111.36	111.36	111.3	111.32	26050.0
2009-12-15 04:30:00	QQQ	ETF	44.51	44.51	44.51	44.51	1000.0
2009-12-15 05:30:00	QQQ	ETF	44.48	44.48	44.48	44.48	10000.0
2009-12-15 06:00:00	QQQ	ETF	44.46	44.46	44.46	44.46	200.0
2009-12-15 07:00:00	QQQ	ETF	44.46	44.46	44.4	44.42	2360.0
2009-12-15 07:30:00	QQQ	ETF	44.4	44.45	44.4	44.45	53971.0
2009-12-15 08:00:00	QQQ	ETF	44.44	44.47	44.37	44.37	222462.0
2009-12-15 08:30:00	QQQ	ETF	44.36	44.39	44.3	44.37	1096898.0
2009-12-15 09:00:00	QQQ	ETF	44.38	44.43	44.37	44.41	439619.0
2009-12-15 09:30:00	QQQ	ETF	44.41	44.44	44.27	44.3	8387846.0
2009-12-15 10:00:00	QQQ	ETF	44.29	44.49	44.27	44.47	5325744.0
2009-12-15 10:30:00	QQQ	ETF	44.47	44.67	44.45	44.65	7036431.0
2009-12-15 11:00:00	QQQ	ETF	44.64	44.66	44.53	44.55	2341069.0
2009-12-15 11:30:00	QQQ	ETF	44.54	44.58	44.51	44.53	2793065.0
2009-12-15 12:00:00	QQQ	ETF	44.53	44.576	44.5	44.53	1075475.0
2009-12-15 12:30:00	QQQ	ETF	44.52	44.55	44.49	44.53	947511.0
2009-12-15 13:00:00	QQQ	ETF	44.54	44.57	44.45	44.47	2067189.0
2009-12-15 13:30:00	QQQ	ETF	44.465	44.575	44.41	44.46	3237441.0
2009-12-15 14:00:00	QQQ	ETF	44.47	44.49	44.44	44.45	2015910.0

> showing 50 of 7,769 rows — these rows as CSV

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