PREVIEW / etf_30min / 2010-02-18

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-18.parquet
  size:    252 KB
  rows:    8,398

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
2010-02-18 04:00:00	SPY	ETF	110.01	110.01	109.93	110.0	700.0
2010-02-18 04:30:00	SPY	ETF	110.04	110.04	110.04	110.04	100.0
2010-02-18 05:00:00	SPY	ETF	110.21	110.35	110.18	110.35	2300.0
2010-02-18 06:00:00	SPY	ETF	110.28	110.33	110.28	110.29	1200.0
2010-02-18 06:30:00	SPY	ETF	110.27	110.27	110.18	110.25	4850.0
2010-02-18 07:00:00	SPY	ETF	110.21	110.3	110.11	110.27	149562.0
2010-02-18 07:30:00	SPY	ETF	110.25	110.26	110.16	110.21	308234.0
2010-02-18 08:00:00	SPY	ETF	110.21	110.34	110.04	110.31	619003.0
2010-02-18 08:30:00	SPY	ETF	110.31	110.31	109.78	109.9	4596539.0
2010-02-18 09:00:00	SPY	ETF	109.89	110.11	109.88	110.08	1827447.0
2010-02-18 09:30:00	SPY	ETF	110.08	110.57	110.035	110.44	23352171.0
2010-02-18 10:00:00	SPY	ETF	110.44	110.66	110.2	110.27	16072262.0
2010-02-18 10:30:00	SPY	ETF	110.26	110.53	110.1	110.44	10887555.0
2010-02-18 11:00:00	SPY	ETF	110.44	110.52	110.34	110.38	8862784.0
2010-02-18 11:30:00	SPY	ETF	110.39	110.5	110.25	110.39	8170421.0
2010-02-18 12:00:00	SPY	ETF	110.39	110.45	110.28	110.38	6043801.0
2010-02-18 12:30:00	SPY	ETF	110.37	110.38	110.27	110.34	4268972.0
2010-02-18 13:00:00	SPY	ETF	110.34	110.45	110.31	110.37	5588814.0
2010-02-18 13:30:00	SPY	ETF	110.38	110.61	110.35	110.54	7921360.0
2010-02-18 14:00:00	SPY	ETF	110.54	110.89	110.48	110.81	13063298.0
2010-02-18 14:30:00	SPY	ETF	110.81	111.03	110.4	110.99	14705415.0
2010-02-18 15:00:00	SPY	ETF	110.99	111.06	110.87	110.92	14122809.0
2010-02-18 15:30:00	SPY	ETF	110.92	111.14	110.89	110.96	23500147.0
2010-02-18 16:00:00	SPY	ETF	110.96	111.05	110.14	111.02	9678074.0
2010-02-18 16:30:00	SPY	ETF	111.04	111.05	109.91	110.09	12439244.0
2010-02-18 17:00:00	SPY	ETF	110.13	110.3	110.05	110.2488	1626362.0
2010-02-18 17:30:00	SPY	ETF	110.25	110.3	110.23	110.24	220141.0
2010-02-18 18:00:00	SPY	ETF	110.23	110.26	109.98	110.05	517333.0
2010-02-18 18:30:00	SPY	ETF	110.11	110.18	109.91	109.99	93876.0
2010-02-18 19:00:00	SPY	ETF	109.99	110.13	109.9	110.13	149160.0
2010-02-18 19:30:00	SPY	ETF	110.12	110.25	110.08	110.12	98945.0
2010-02-18 04:00:00	QQQ	ETF	44.5	44.52	44.5	44.52	8000.0
2010-02-18 04:30:00	QQQ	ETF	44.54	44.58	44.54	44.58	12000.0
2010-02-18 05:00:00	QQQ	ETF	44.6	44.66	44.6	44.66	16100.0
2010-02-18 06:00:00	QQQ	ETF	44.65	44.65	44.65	44.65	1000.0
2010-02-18 07:00:00	QQQ	ETF	44.65	44.67	44.6	44.67	226200.0
2010-02-18 07:30:00	QQQ	ETF	44.65	44.67	44.6	44.67	311522.0
2010-02-18 08:00:00	QQQ	ETF	44.61	44.67	44.61	44.65	438410.0
2010-02-18 08:30:00	QQQ	ETF	44.65	44.66	44.44	44.48	1580176.0
2010-02-18 09:00:00	QQQ	ETF	44.49	44.55	44.47	44.54	614757.0
2010-02-18 09:30:00	QQQ	ETF	44.54	44.6	44.45	44.565	8611512.0
2010-02-18 10:00:00	QQQ	ETF	44.58	44.69	44.5101	44.57	6926835.0
2010-02-18 10:30:00	QQQ	ETF	44.57	44.73	44.5	44.7	5514464.0
2010-02-18 11:00:00	QQQ	ETF	44.69	44.74	44.66	44.66	4006578.0
2010-02-18 11:30:00	QQQ	ETF	44.66	44.76	44.62	44.68	2694287.0
2010-02-18 12:00:00	QQQ	ETF	44.68	44.71	44.63	44.67	2093591.0
2010-02-18 12:30:00	QQQ	ETF	44.66	44.67	44.5974	44.63	1551301.0
2010-02-18 13:00:00	QQQ	ETF	44.63	44.68	44.61	44.65	1483386.0
2010-02-18 13:30:00	QQQ	ETF	44.6505	44.72	44.65	44.7	2636951.0
2010-02-18 14:00:00	QQQ	ETF	44.7	44.84	44.66	44.81	4252356.0

> showing 50 of 8,398 rows — these rows as CSV

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