PREVIEW / etf_30min / 2012-04-23

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-23.parquet
  size:    287 KB
  rows:    9,748

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-04-23 04:00:00	SPY	ETF	137.14	137.14	136.63	136.92	51900.0
2012-04-23 04:30:00	SPY	ETF	136.93	136.94	136.8	136.8	1400.0
2012-04-23 05:00:00	SPY	ETF	136.78	136.79	136.62	136.62	11262.0
2012-04-23 05:30:00	SPY	ETF	136.66	136.78	136.56	136.74	51295.0
2012-04-23 06:00:00	SPY	ETF	136.73	136.76	136.62	136.68	113695.0
2012-04-23 06:30:00	SPY	ETF	136.66	136.74	136.58	136.7	72619.0
2012-04-23 07:00:00	SPY	ETF	136.65	136.73	136.5	136.73	365753.0
2012-04-23 07:30:00	SPY	ETF	136.73	136.78	136.5	136.66	204621.0
2012-04-23 08:00:00	SPY	ETF	136.67	137.8282	136.51	136.65	674795.0
2012-04-23 08:30:00	SPY	ETF	136.64	136.78	136.64	136.7	836305.0
2012-04-23 09:00:00	SPY	ETF	136.7	136.78	136.53	136.53	981518.0
2012-04-23 09:30:00	SPY	ETF	136.54	136.63	136.1	136.291	22408081.0
2012-04-23 10:00:00	SPY	ETF	136.29	136.29	135.94	136.2	17794049.0
2012-04-23 10:30:00	SPY	ETF	136.19	136.35	136.02	136.21	15745580.0
2012-04-23 11:00:00	SPY	ETF	136.21	136.42	136.17	136.28	10621259.0
2012-04-23 11:30:00	SPY	ETF	136.28	136.45	136.24	136.435	7873681.0
2012-04-23 12:00:00	SPY	ETF	136.43	136.64	136.32	136.609	5868672.0
2012-04-23 12:30:00	SPY	ETF	136.61	136.64	136.35	136.44	7074090.0
2012-04-23 13:00:00	SPY	ETF	136.45	136.55	136.39	136.5	6260468.0
2012-04-23 13:30:00	SPY	ETF	136.5	136.6	136.37	136.475	5256469.0
2012-04-23 14:00:00	SPY	ETF	136.48	136.8	136.23	136.71	10150519.0
2012-04-23 14:30:00	SPY	ETF	136.72	136.91	136.57	136.57	9678317.0
2012-04-23 15:00:00	SPY	ETF	136.57	136.79	136.54	136.76	9378947.0
2012-04-23 15:30:00	SPY	ETF	136.77	136.89	136.7	136.77	16814816.0
2012-04-23 16:00:00	SPY	ETF	136.78	137.9266	136.23	136.78	17869919.0
2012-04-23 16:30:00	SPY	ETF	136.8	136.97	136.79	136.96	1061155.0
2012-04-23 17:00:00	SPY	ETF	136.96	136.98	136.9	136.96	186339.0
2012-04-23 17:30:00	SPY	ETF	136.97	136.97	136.94	136.95	17386.0
2012-04-23 18:00:00	SPY	ETF	136.96	137.0	136.94	136.99	24425.0
2012-04-23 18:30:00	SPY	ETF	136.95	136.97	136.89	136.95	63316.0
2012-04-23 19:00:00	SPY	ETF	136.94	136.94	136.92	136.94	4506.0
2012-04-23 19:30:00	SPY	ETF	136.91	136.91	136.84	136.88	42199.0
2012-04-23 04:00:00	QQQ	ETF	65.35	65.35	65.2	65.23	800.0
2012-04-23 04:30:00	QQQ	ETF	65.25	65.25	65.25	65.25	1000.0
2012-04-23 05:00:00	QQQ	ETF	65.08	65.08	65.08	65.08	200.0
2012-04-23 05:30:00	QQQ	ETF	65.07	65.08	65.07	65.08	4000.0
2012-04-23 06:30:00	QQQ	ETF	65.12	65.12	65.06	65.09	3200.0
2012-04-23 07:00:00	QQQ	ETF	65.09	65.16	65.02	65.15	20850.0
2012-04-23 07:30:00	QQQ	ETF	65.15	65.15	65.03	65.12	70230.0
2012-04-23 08:00:00	QQQ	ETF	65.14	65.3033	65.08	65.12	143862.0
2012-04-23 08:30:00	QQQ	ETF	65.12	65.22	65.12	65.2	138014.0
2012-04-23 09:00:00	QQQ	ETF	65.19	65.65	65.09	65.09	507460.0
2012-04-23 09:30:00	QQQ	ETF	65.09	65.17	64.76	64.91	10204323.0
2012-04-23 10:00:00	QQQ	ETF	64.9	64.94	64.62	64.83	8951668.0
2012-04-23 10:30:00	QQQ	ETF	64.83	64.83	64.49	64.58	6651232.0
2012-04-23 11:00:00	QQQ	ETF	64.59	64.79	64.51	64.74	4845118.0
2012-04-23 11:30:00	QQQ	ETF	64.74	64.84	64.69	64.84	2604391.0
2012-04-23 12:00:00	QQQ	ETF	64.84	65.02	64.81	65.0	3422252.0
2012-04-23 12:30:00	QQQ	ETF	65.0	65.05	64.82	64.87	1805896.0
2012-04-23 13:00:00	QQQ	ETF	64.88	64.989	64.86	64.98	1297554.0

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

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