PREVIEW / etf_30min / 2013-03-01

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-01.parquet
  size:    305 KB
  rows:    10,422

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
2013-03-01 04:00:00	SPY	ETF	151.6	151.74	151.57	151.57	7700.0
2013-03-01 04:30:00	SPY	ETF	151.49	151.54	151.29	151.29	16632.0
2013-03-01 05:00:00	SPY	ETF	151.32	151.37	151.22	151.34	36900.0
2013-03-01 05:30:00	SPY	ETF	151.36	151.41	151.34	151.34	94958.0
2013-03-01 06:00:00	SPY	ETF	151.34	151.34	151.1	151.17	41300.0
2013-03-01 06:30:00	SPY	ETF	151.15	151.22	151.15	151.2	131301.0
2013-03-01 07:00:00	SPY	ETF	151.21	151.22	150.88	150.94	317423.0
2013-03-01 07:30:00	SPY	ETF	150.89	151.12	150.85	150.92	223660.0
2013-03-01 08:00:00	SPY	ETF	150.9	151.78	150.79	150.95	1206644.0
2013-03-01 08:30:00	SPY	ETF	150.95	151.17	150.8	151.13	971348.0
2013-03-01 09:00:00	SPY	ETF	151.13	151.61	150.97	151.1	1455114.0
2013-03-01 09:30:00	SPY	ETF	151.09	151.12	150.41	150.9	24638700.0
2013-03-01 10:00:00	SPY	ETF	150.9	151.44	150.895	151.38	19823419.0
2013-03-01 10:30:00	SPY	ETF	151.3899	152.01	151.34	152.01	13002616.0
2013-03-01 11:00:00	SPY	ETF	152.01	152.17	151.68	151.71	12504396.0
2013-03-01 11:30:00	SPY	ETF	151.71	151.82	151.36	151.64	10220603.0
2013-03-01 12:00:00	SPY	ETF	151.63	152.24	151.62	152.09	7639921.0
2013-03-01 12:30:00	SPY	ETF	152.09	152.33	152.05	152.27	5499470.0
2013-03-01 13:00:00	SPY	ETF	152.26	152.34	152.05	152.16	6114598.0
2013-03-01 13:30:00	SPY	ETF	152.16	152.23	151.86	152.07	4768436.0
2013-03-01 14:00:00	SPY	ETF	152.07	152.28	151.93	152.02	4692946.0
2013-03-01 14:30:00	SPY	ETF	152.02	152.16	151.86	152.08	5800567.0
2013-03-01 15:00:00	SPY	ETF	152.08	152.19	152.01	152.025	8558636.0
2013-03-01 15:30:00	SPY	ETF	152.025	152.2	151.86	152.13	22932040.0
2013-03-01 16:00:00	SPY	ETF	152.13	152.23	151.3	152.05	14860408.0
2013-03-01 16:30:00	SPY	ETF	152.05	152.1	152.02	152.03	423987.0
2013-03-01 17:00:00	SPY	ETF	152.03	152.12	151.99	152.04	378492.0
2013-03-01 17:30:00	SPY	ETF	152.08	152.11	152.08	152.08	19709.0
2013-03-01 18:00:00	SPY	ETF	152.08	152.08	152.06	152.06	6747.0
2013-03-01 18:30:00	SPY	ETF	152.05	152.11	152.05	152.11	4614.0
2013-03-01 19:00:00	SPY	ETF	152.11	152.14	152.08	152.1	7385.0
2013-03-01 19:30:00	SPY	ETF	152.12	152.13	152.03	152.03	10201.0
2013-03-01 04:00:00	QQQ	ETF	67.2	67.27	67.2	67.27	2500.0
2013-03-01 05:30:00	QQQ	ETF	67.08	67.08	67.05	67.05	1200.0
2013-03-01 06:00:00	QQQ	ETF	67.01	67.01	66.98	66.98	7300.0
2013-03-01 06:30:00	QQQ	ETF	66.99	66.99	66.97	66.97	300.0
2013-03-01 07:00:00	QQQ	ETF	66.99	66.99	66.84	66.84	2850.0
2013-03-01 07:30:00	QQQ	ETF	66.87	66.92	66.85	66.87	15693.0
2013-03-01 08:00:00	QQQ	ETF	66.82	66.92	66.8	66.8	460330.0
2013-03-01 08:30:00	QQQ	ETF	66.84	66.92	66.83	66.9	109032.0
2013-03-01 09:00:00	QQQ	ETF	66.9	66.91	66.86	66.88	159075.0
2013-03-01 09:30:00	QQQ	ETF	66.86	66.89	66.54	66.6954	5095233.0
2013-03-01 10:00:00	QQQ	ETF	66.7	67.0	66.673	66.88	4363542.0
2013-03-01 10:30:00	QQQ	ETF	66.88	67.32	66.86	67.31	2654680.0
2013-03-01 11:00:00	QQQ	ETF	67.32	67.43	67.13	67.21	3089575.0
2013-03-01 11:30:00	QQQ	ETF	67.2101	67.2585	67.03	67.17	1513905.0
2013-03-01 12:00:00	QQQ	ETF	67.16	67.49	67.16	67.42	1805982.0
2013-03-01 12:30:00	QQQ	ETF	67.4199	67.5	67.36	67.45	1033194.0
2013-03-01 13:00:00	QQQ	ETF	67.44	67.49	67.36	67.42	1452846.0
2013-03-01 13:30:00	QQQ	ETF	67.42	67.45	67.28	67.38	825064.0

> showing 50 of 10,422 rows — these rows as CSV

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