PREVIEW / etf_30min / 2013-07-18

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-18.parquet
  size:    317 KB
  rows:    10,772

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-07-18 04:00:00	SPY	ETF	167.98	168.08	167.98	168.08	1200.0
2013-07-18 04:30:00	SPY	ETF	168.08	168.1	168.08	168.1	300.0
2013-07-18 05:00:00	SPY	ETF	168.05	168.05	168.05	168.05	700.0
2013-07-18 05:30:00	SPY	ETF	168.1	168.15	168.1	168.15	500.0
2013-07-18 06:00:00	SPY	ETF	168.1	168.16	168.09	168.16	10000.0
2013-07-18 06:30:00	SPY	ETF	168.14	168.14	168.09	168.14	11530.0
2013-07-18 07:00:00	SPY	ETF	168.15	168.22	168.09	168.2	43263.0
2013-07-18 07:30:00	SPY	ETF	168.17	168.21	168.12	168.13	64932.0
2013-07-18 08:00:00	SPY	ETF	168.14	168.62	168.08	168.2	91203.0
2013-07-18 08:30:00	SPY	ETF	168.52	170.46	168.15	168.35	474225.0
2013-07-18 09:00:00	SPY	ETF	168.35	168.43	168.27	168.3	405150.0
2013-07-18 09:30:00	SPY	ETF	168.31	168.66	168.2	168.54	9774753.0
2013-07-18 10:00:00	SPY	ETF	168.54	169.13	168.515	169.1	12184014.0
2013-07-18 10:30:00	SPY	ETF	169.09	169.27	168.98	169.19	7615149.0
2013-07-18 11:00:00	SPY	ETF	169.19	169.25	169.06	169.1	5113403.0
2013-07-18 11:30:00	SPY	ETF	169.1	169.21	168.95	169.01	4561224.0
2013-07-18 12:00:00	SPY	ETF	169.01	169.23	168.93	168.98	6815462.0
2013-07-18 12:30:00	SPY	ETF	168.98	169.01	168.76	168.825	4361512.0
2013-07-18 13:00:00	SPY	ETF	168.82	168.91	168.63	168.72	7233950.0
2013-07-18 13:30:00	SPY	ETF	168.71	168.92	168.66	168.89	4484830.0
2013-07-18 14:00:00	SPY	ETF	168.89	169.0	168.84	168.97	3084544.0
2013-07-18 14:30:00	SPY	ETF	168.9685	169.12	168.96	169.01	4922303.0
2013-07-18 15:00:00	SPY	ETF	169.01	169.01	168.725	168.87	4082056.0
2013-07-18 15:30:00	SPY	ETF	168.88	168.92	168.69	168.89	10500356.0
2013-07-18 16:00:00	SPY	ETF	168.88	169.15	168.033	168.43	10466754.0
2013-07-18 16:30:00	SPY	ETF	168.43	168.8456	168.38	168.44	1592047.0
2013-07-18 17:00:00	SPY	ETF	168.45	168.51	168.41	168.45	142381.0
2013-07-18 17:30:00	SPY	ETF	168.45	168.45	168.39	168.41	87781.0
2013-07-18 18:00:00	SPY	ETF	168.4	168.46	168.37	168.45	64485.0
2013-07-18 18:30:00	SPY	ETF	168.45	168.45	168.38	168.38	29328.0
2013-07-18 19:00:00	SPY	ETF	168.37	168.42	168.37	168.41	22200.0
2013-07-18 19:30:00	SPY	ETF	168.41	168.46	168.41	168.43	45112.0
2013-07-18 04:00:00	QQQ	ETF	75.48	75.52	75.47	75.5	3100.0
2013-07-18 04:30:00	QQQ	ETF	75.52	75.52	75.52	75.52	600.0
2013-07-18 05:00:00	QQQ	ETF	75.5	75.5	75.5	75.5	4600.0
2013-07-18 05:30:00	QQQ	ETF	75.52	75.56	75.52	75.56	1300.0
2013-07-18 06:00:00	QQQ	ETF	75.54	75.54	75.54	75.54	100.0
2013-07-18 06:30:00	QQQ	ETF	75.51	75.52	75.51	75.52	1800.0
2013-07-18 07:00:00	QQQ	ETF	75.52	75.53	75.52	75.52	5700.0
2013-07-18 07:30:00	QQQ	ETF	75.5	75.5	75.48	75.49	14900.0
2013-07-18 08:00:00	QQQ	ETF	75.48	75.51	75.47	75.51	26752.0
2013-07-18 08:30:00	QQQ	ETF	75.51	75.61	75.51	75.61	133481.0
2013-07-18 09:00:00	QQQ	ETF	75.63	75.63	75.53	75.54	123853.0
2013-07-18 09:30:00	QQQ	ETF	75.54	75.56	75.39	75.45	2650525.0
2013-07-18 10:00:00	QQQ	ETF	75.46	75.7	75.41	75.661	2457272.0
2013-07-18 10:30:00	QQQ	ETF	75.6699	75.74	75.61	75.68	1686933.0
2013-07-18 11:00:00	QQQ	ETF	75.69	75.73	75.6301	75.65	1040086.0
2013-07-18 11:30:00	QQQ	ETF	75.659	75.68	75.5007	75.53	1014109.0
2013-07-18 12:00:00	QQQ	ETF	75.53	75.61	75.44	75.46	1163058.0
2013-07-18 12:30:00	QQQ	ETF	75.46	75.47	75.301	75.35	1031755.0

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

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