PREVIEW / etf_30min / 2012-11-05

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-05.parquet
  size:    278 KB
  rows:    9,396

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-11-05 04:00:00	SPY	ETF	141.16	141.18	141.14	141.18	2800.0
2012-11-05 04:30:00	SPY	ETF	141.23	141.26	141.12	141.12	3840.0
2012-11-05 05:00:00	SPY	ETF	141.09	141.09	141.0	141.07	29560.0
2012-11-05 05:30:00	SPY	ETF	141.07	141.3	141.07	141.3	72766.0
2012-11-05 06:00:00	SPY	ETF	141.34	141.35	141.14	141.14	24200.0
2012-11-05 06:30:00	SPY	ETF	141.17	141.29	141.09	141.19	8509.0
2012-11-05 07:00:00	SPY	ETF	141.22	141.23	141.02	141.08	50110.0
2012-11-05 07:30:00	SPY	ETF	141.1	141.1	140.93	141.1	113608.0
2012-11-05 08:00:00	SPY	ETF	141.1	141.15	140.96	141.02	245349.0
2012-11-05 08:30:00	SPY	ETF	141.0	141.37	141.0	141.3	695808.0
2012-11-05 09:00:00	SPY	ETF	141.31	141.37	141.19	141.36	1062403.0
2012-11-05 09:30:00	SPY	ETF	141.35	141.42	140.95	141.12	14916436.0
2012-11-05 10:00:00	SPY	ETF	141.12	141.28	140.93	141.125	7835914.0
2012-11-05 10:30:00	SPY	ETF	141.12	141.66	141.07	141.5901	6835500.0
2012-11-05 11:00:00	SPY	ETF	141.6	141.72	141.48	141.54	4955026.0
2012-11-05 11:30:00	SPY	ETF	141.55	141.66	141.33	141.445	4469458.0
2012-11-05 12:00:00	SPY	ETF	141.44	141.5	141.3	141.32	2811237.0
2012-11-05 12:30:00	SPY	ETF	141.32	141.32	141.11	141.2	5442198.0
2012-11-05 13:00:00	SPY	ETF	141.19	141.48	141.17	141.42	4657051.0
2012-11-05 13:30:00	SPY	ETF	141.43	141.54	141.37	141.45	3852407.0
2012-11-05 14:00:00	SPY	ETF	141.45	141.62	141.43	141.6	4393256.0
2012-11-05 14:30:00	SPY	ETF	141.592	141.8	141.58	141.69	3778961.0
2012-11-05 15:00:00	SPY	ETF	141.69	141.8	141.64	141.76	5264284.0
2012-11-05 15:30:00	SPY	ETF	141.76	142.17	141.65	141.87	16656960.0
2012-11-05 16:00:00	SPY	ETF	141.88	141.9391	141.14	141.76	2403787.0
2012-11-05 16:30:00	SPY	ETF	141.75	141.79	141.65	141.7	165514.0
2012-11-05 17:00:00	SPY	ETF	141.7	141.73	141.63	141.67	84021.0
2012-11-05 17:30:00	SPY	ETF	141.67	141.71	141.59	141.71	27073.0
2012-11-05 18:00:00	SPY	ETF	141.71	141.75	141.7	141.73	19531.0
2012-11-05 18:30:00	SPY	ETF	141.73	141.75	141.68	141.68	28857.0
2012-11-05 19:00:00	SPY	ETF	141.71	141.72	141.65	141.68	5100.0
2012-11-05 19:30:00	SPY	ETF	141.66	141.66	141.63	141.63	12685.0
2012-11-05 04:00:00	QQQ	ETF	65.01	65.01	65.01	65.01	100.0
2012-11-05 05:00:00	QQQ	ETF	64.93	64.93	64.93	64.93	950.0
2012-11-05 07:00:00	QQQ	ETF	65.03	65.03	65.0	65.02	1390.0
2012-11-05 07:30:00	QQQ	ETF	64.95	64.95	64.89	64.92	32460.0
2012-11-05 08:00:00	QQQ	ETF	64.93	64.96	64.85	64.86	114339.0
2012-11-05 08:30:00	QQQ	ETF	64.85	65.19	64.85	65.16	588503.0
2012-11-05 09:00:00	QQQ	ETF	65.15	65.2	65.1	65.19	304610.0
2012-11-05 09:30:00	QQQ	ETF	65.195	65.35	65.04	65.2	4525927.0
2012-11-05 10:00:00	QQQ	ETF	65.2199	65.28	65.06	65.175	1677401.0
2012-11-05 10:30:00	QQQ	ETF	65.19	65.51	65.16	65.4699	2575564.0
2012-11-05 11:00:00	QQQ	ETF	65.46	65.51	65.35	65.38	1583363.0
2012-11-05 11:30:00	QQQ	ETF	65.38	65.39	65.26	65.325	534353.0
2012-11-05 12:00:00	QQQ	ETF	65.33	65.33	65.1601	65.17	675476.0
2012-11-05 12:30:00	QQQ	ETF	65.1799	65.18	65.07	65.1201	1212180.0
2012-11-05 13:00:00	QQQ	ETF	65.13	65.3	65.12	65.28	1164613.0
2012-11-05 13:30:00	QQQ	ETF	65.28	65.3299	65.18	65.22	726803.0
2012-11-05 14:00:00	QQQ	ETF	65.22	65.41	65.22	65.4	801005.0
2012-11-05 14:30:00	QQQ	ETF	65.41	65.51	65.376	65.44	1130461.0

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

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