PREVIEW / etf_30min / 2012-06-14

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-14.parquet
  size:    280 KB
  rows:    9,358

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
2012-06-14 04:00:00	SPY	ETF	132.5	132.5	132.17	132.27	1610.0
2012-06-14 04:30:00	SPY	ETF	132.22	132.22	132.1	132.1	1100.0
2012-06-14 05:00:00	SPY	ETF	132.1	132.28	132.02	132.19	6300.0
2012-06-14 05:30:00	SPY	ETF	132.13	132.2	131.96	132.08	53180.0
2012-06-14 06:00:00	SPY	ETF	132.11	132.35	132.05	132.32	13130.0
2012-06-14 06:30:00	SPY	ETF	132.34	132.56	132.34	132.4	134835.0
2012-06-14 07:00:00	SPY	ETF	132.4	132.46	132.3	132.32	84897.0
2012-06-14 07:30:00	SPY	ETF	132.35	132.45	131.96	132.11	594965.0
2012-06-14 08:00:00	SPY	ETF	132.1	132.25	132.04	132.08	845302.0
2012-06-14 08:30:00	SPY	ETF	132.05	132.57	131.8	132.4	1696355.0
2012-06-14 09:00:00	SPY	ETF	132.4	132.48	132.28	132.33	803661.0
2012-06-14 09:30:00	SPY	ETF	132.34	132.75	131.98	132.72	19343549.0
2012-06-14 10:00:00	SPY	ETF	132.72	132.95	132.68	132.78	13843680.0
2012-06-14 10:30:00	SPY	ETF	132.77	133.08	132.57	133.01	11145486.0
2012-06-14 11:00:00	SPY	ETF	133.0	133.24	132.91	133.22	9522082.0
2012-06-14 11:30:00	SPY	ETF	133.22	133.27	133.01	133.03	7395877.0
2012-06-14 12:00:00	SPY	ETF	133.03	133.18	133.01	133.02	8666574.0
2012-06-14 12:30:00	SPY	ETF	133.03	133.28	132.95	133.2	7246206.0
2012-06-14 13:00:00	SPY	ETF	133.21	133.35	133.0	133.08	16384008.0
2012-06-14 13:30:00	SPY	ETF	133.07	133.25	133.015	133.12	13106588.0
2012-06-14 14:00:00	SPY	ETF	133.12	133.27	132.89	132.929	10256413.0
2012-06-14 14:30:00	SPY	ETF	132.92	132.929	132.66	132.68	9834905.0
2012-06-14 15:00:00	SPY	ETF	132.68	134.0	132.64	132.98	44415177.0
2012-06-14 15:30:00	SPY	ETF	132.99	133.74	132.91	133.49	34495601.0
2012-06-14 16:00:00	SPY	ETF	133.51	134.1363	132.0693	133.78	16593989.0
2012-06-14 16:30:00	SPY	ETF	133.78	133.995	132.0693	133.96	2782816.0
2012-06-14 17:00:00	SPY	ETF	133.97	134.009	133.85	133.87	409301.0
2012-06-14 17:30:00	SPY	ETF	133.85	133.88	133.83	133.84	44768.0
2012-06-14 18:00:00	SPY	ETF	133.83	133.88	133.78	133.79	62624.0
2012-06-14 18:30:00	SPY	ETF	133.83	133.85	133.8	133.83	18750.0
2012-06-14 19:00:00	SPY	ETF	133.83	133.83	133.76	133.77	23869.0
2012-06-14 19:30:00	SPY	ETF	133.83	133.84	133.77	133.81	40582.0
2012-06-14 04:00:00	QQQ	ETF	62.24	62.24	62.24	62.24	1100.0
2012-06-14 05:00:00	QQQ	ETF	62.21	62.21	62.21	62.21	1700.0
2012-06-14 06:00:00	QQQ	ETF	62.16	62.17	62.16	62.17	13300.0
2012-06-14 06:30:00	QQQ	ETF	62.2	62.3	62.2	62.29	3700.0
2012-06-14 07:00:00	QQQ	ETF	62.23	62.23	62.17	62.2	1400.0
2012-06-14 07:30:00	QQQ	ETF	62.2	62.2	62.08	62.14	24180.0
2012-06-14 08:00:00	QQQ	ETF	62.14	62.14	62.03	62.1	33310.0
2012-06-14 08:30:00	QQQ	ETF	62.08	62.31	62.0	62.26	63330.0
2012-06-14 09:00:00	QQQ	ETF	62.23	62.27	62.11	62.11	76017.0
2012-06-14 09:30:00	QQQ	ETF	62.13	62.26	61.8	62.24	5062962.0
2012-06-14 10:00:00	QQQ	ETF	62.23	62.34	62.18	62.27	4161352.0
2012-06-14 10:30:00	QQQ	ETF	62.27	62.46	62.16	62.42	3190824.0
2012-06-14 11:00:00	QQQ	ETF	62.42	62.54	62.35	62.53	2610753.0
2012-06-14 11:30:00	QQQ	ETF	62.5399	62.57	62.45	62.46	2114481.0
2012-06-14 12:00:00	QQQ	ETF	62.45	62.52	62.41	62.44	1718742.0
2012-06-14 12:30:00	QQQ	ETF	62.44	62.529	62.42	62.49	881687.0
2012-06-14 13:00:00	QQQ	ETF	62.49	62.521	62.31	62.33	1604350.0
2012-06-14 13:30:00	QQQ	ETF	62.32	62.44	62.29	62.34	1945986.0

> showing 50 of 9,358 rows — these rows as CSV

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