PREVIEW / etf_30min / 2013-09-18

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-18.parquet
  size:    336 KB
  rows:    11,173

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-09-18 04:00:00	SPY	ETF	171.11	171.28	171.11	171.26	14000.0
2013-09-18 04:30:00	SPY	ETF	171.26	171.31	171.22	171.31	2900.0
2013-09-18 05:00:00	SPY	ETF	171.28	171.37	171.25	171.34	2200.0
2013-09-18 05:30:00	SPY	ETF	171.37	171.37	171.25	171.25	2277.0
2013-09-18 06:00:00	SPY	ETF	171.23	171.32	171.21	171.25	10073.0
2013-09-18 06:30:00	SPY	ETF	171.22	171.27	171.18	171.25	45784.0
2013-09-18 07:00:00	SPY	ETF	171.28	171.28	171.19	171.22	85190.0
2013-09-18 07:30:00	SPY	ETF	171.22	171.25	171.16	171.18	66893.0
2013-09-18 08:00:00	SPY	ETF	171.16	171.25	171.11	171.15	62407.0
2013-09-18 08:30:00	SPY	ETF	171.12	171.17	171.07	171.1	227342.0
2013-09-18 09:00:00	SPY	ETF	171.1	171.13	170.96	171.0	593208.0
2013-09-18 09:30:00	SPY	ETF	171.01	171.13	170.92	171.0	7704544.0
2013-09-18 10:00:00	SPY	ETF	171.0	171.16	170.79	170.821	5852004.0
2013-09-18 10:30:00	SPY	ETF	170.83	170.87	170.71	170.83	6463685.0
2013-09-18 11:00:00	SPY	ETF	170.83	170.89	170.74	170.825	4345699.0
2013-09-18 11:30:00	SPY	ETF	170.83	171.0128	170.66	170.67	5536979.0
2013-09-18 12:00:00	SPY	ETF	170.67	170.7	170.58	170.61	5941568.0
2013-09-18 12:30:00	SPY	ETF	170.61	170.79	170.6	170.75	3068730.0
2013-09-18 13:00:00	SPY	ETF	170.75	170.98	170.73	170.91	4460350.0
2013-09-18 13:30:00	SPY	ETF	170.91	170.94	170.76	170.819	6291813.0
2013-09-18 14:00:00	SPY	ETF	170.86	172.92	170.82	172.59	50172764.0
2013-09-18 14:30:00	SPY	ETF	172.59	173.47	172.43	173.45	21728166.0
2013-09-18 15:00:00	SPY	ETF	173.45	173.52	172.89	172.94	17991268.0
2013-09-18 15:30:00	SPY	ETF	172.94	173.17	172.85	173.1	26776887.0
2013-09-18 16:00:00	SPY	ETF	173.09	173.14	171.0128	173.0	12102777.0
2013-09-18 16:30:00	SPY	ETF	172.99	173.07	171.0128	173.05	10110077.0
2013-09-18 17:00:00	SPY	ETF	173.06	173.1	172.3508	173.06	6756340.0
2013-09-18 17:30:00	SPY	ETF	173.07	173.09	173.04	173.07	91639.0
2013-09-18 18:00:00	SPY	ETF	173.07	173.13	173.06	173.11	152265.0
2013-09-18 18:30:00	SPY	ETF	173.11	173.15	173.07	173.15	27566.0
2013-09-18 19:00:00	SPY	ETF	173.15	173.25	173.12	173.23	94112.0
2013-09-18 19:30:00	SPY	ETF	173.26	173.26	173.15	173.16	106945.0
2013-09-18 04:30:00	QQQ	ETF	78.54	78.54	78.54	78.54	2000.0
2013-09-18 05:00:00	QQQ	ETF	78.54	78.59	78.53	78.59	12800.0
2013-09-18 05:30:00	QQQ	ETF	78.57	78.57	78.57	78.57	1500.0
2013-09-18 06:00:00	QQQ	ETF	78.55	78.57	78.55	78.57	2800.0
2013-09-18 06:30:00	QQQ	ETF	78.55	78.57	78.53	78.57	5800.0
2013-09-18 07:00:00	QQQ	ETF	78.55	78.55	78.55	78.55	1400.0
2013-09-18 07:30:00	QQQ	ETF	78.55	78.57	78.53	78.53	23398.0
2013-09-18 08:00:00	QQQ	ETF	78.53	78.57	78.52	78.53	73600.0
2013-09-18 08:30:00	QQQ	ETF	78.51	78.52	78.47	78.49	16725.0
2013-09-18 09:00:00	QQQ	ETF	78.48	78.55	78.48	78.49	98387.0
2013-09-18 09:30:00	QQQ	ETF	78.49	78.59	78.46	78.51	1978455.0
2013-09-18 10:00:00	QQQ	ETF	78.52	78.6001	78.45	78.5	1951381.0
2013-09-18 10:30:00	QQQ	ETF	78.5	78.54	78.45	78.519	1513925.0
2013-09-18 11:00:00	QQQ	ETF	78.51	78.5491	78.42	78.45	781335.0
2013-09-18 11:30:00	QQQ	ETF	78.45	78.49	78.349	78.349	404008.0
2013-09-18 12:00:00	QQQ	ETF	78.34	78.4199	78.33	78.37	635796.0
2013-09-18 12:30:00	QQQ	ETF	78.37	78.46	78.36	78.44	385815.0
2013-09-18 13:00:00	QQQ	ETF	78.44	78.51	78.4	78.47	1014869.0

> showing 50 of 11,173 rows — these rows as CSV

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