PREVIEW / etf_30min / 2012-07-31

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-31.parquet
  size:    277 KB
  rows:    9,404

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-07-31 04:00:00	SPY	ETF	138.78	138.78	138.77	138.77	1800.0
2012-07-31 04:30:00	SPY	ETF	138.93	138.94	138.88	138.88	2894.0
2012-07-31 05:00:00	SPY	ETF	138.9	138.98	138.9	138.97	450.0
2012-07-31 05:30:00	SPY	ETF	138.94	139.02	138.94	139.01	3700.0
2012-07-31 06:00:00	SPY	ETF	139.06	139.11	138.96	138.97	1654.0
2012-07-31 06:30:00	SPY	ETF	138.91	138.91	138.85	138.85	1000.0
2012-07-31 07:00:00	SPY	ETF	138.88	139.0	138.82	138.82	109095.0
2012-07-31 07:30:00	SPY	ETF	138.82	138.95	138.77	138.92	63298.0
2012-07-31 08:00:00	SPY	ETF	138.92	138.96	138.73	138.75	1052970.0
2012-07-31 08:30:00	SPY	ETF	138.75	138.94	138.63	138.73	806304.0
2012-07-31 09:00:00	SPY	ETF	138.71	138.83	138.39	138.49	2288843.0
2012-07-31 09:30:00	SPY	ETF	138.49	138.85	138.38	138.58	14349056.0
2012-07-31 10:00:00	SPY	ETF	138.58	138.77	138.25	138.61	12442798.0
2012-07-31 10:30:00	SPY	ETF	138.6	138.769	138.41	138.61	7770203.0
2012-07-31 11:00:00	SPY	ETF	138.61	138.87	138.509	138.76	8167258.0
2012-07-31 11:30:00	SPY	ETF	138.77	138.78	138.57	138.65	4697000.0
2012-07-31 12:00:00	SPY	ETF	138.65	138.65	138.15	138.3	8298606.0
2012-07-31 12:30:00	SPY	ETF	138.3	138.35	138.13	138.18	4195965.0
2012-07-31 13:00:00	SPY	ETF	138.175	138.42	138.1	138.41	5982699.0
2012-07-31 13:30:00	SPY	ETF	138.41	138.42	138.22	138.25	3127666.0
2012-07-31 14:00:00	SPY	ETF	138.25	138.65	138.2	138.575	5385006.0
2012-07-31 14:30:00	SPY	ETF	138.58	138.63	138.33	138.34	5783656.0
2012-07-31 15:00:00	SPY	ETF	138.33	138.42	138.23	138.42	6041249.0
2012-07-31 15:30:00	SPY	ETF	138.41	138.45	137.95	137.98	16011900.0
2012-07-31 16:00:00	SPY	ETF	137.97	138.816	137.71	137.81	8706759.0
2012-07-31 16:30:00	SPY	ETF	137.81	138.6658	137.81	137.89	3800058.0
2012-07-31 17:00:00	SPY	ETF	137.89	137.9	137.82	137.9	112228.0
2012-07-31 17:30:00	SPY	ETF	137.85	137.92	137.84	137.89	29036.0
2012-07-31 18:00:00	SPY	ETF	137.88	137.89	137.8	137.8	20900.0
2012-07-31 18:30:00	SPY	ETF	137.85	137.86	137.79	137.86	6151.0
2012-07-31 19:00:00	SPY	ETF	137.84	137.87	137.82	137.87	17022.0
2012-07-31 19:30:00	SPY	ETF	137.81	137.87	137.8	137.85	24490.0
2012-07-31 05:00:00	QQQ	ETF	65.0	65.0	64.99	64.99	3150.0
2012-07-31 06:30:00	QQQ	ETF	65.0	65.0	65.0	65.0	2400.0
2012-07-31 07:00:00	QQQ	ETF	64.96	65.04	64.96	64.97	50800.0
2012-07-31 07:30:00	QQQ	ETF	64.97	65.01	64.97	65.01	13100.0
2012-07-31 08:00:00	QQQ	ETF	65.0	65.02	64.95	64.97	860440.0
2012-07-31 08:30:00	QQQ	ETF	64.92	65.05	64.9	64.96	107904.0
2012-07-31 09:00:00	QQQ	ETF	64.97	65.05	64.82	64.91	955224.0
2012-07-31 09:30:00	QQQ	ETF	64.91	65.18	64.81	64.96	3721747.0
2012-07-31 10:00:00	QQQ	ETF	64.94	65.07	64.75	64.97	3902095.0
2012-07-31 10:30:00	QQQ	ETF	64.97	65.14	64.81	65.0145	2477776.0
2012-07-31 11:00:00	QQQ	ETF	65.02	65.1501	64.94	65.12	1769765.0
2012-07-31 11:30:00	QQQ	ETF	65.12	65.12	64.98	65.02	951640.0
2012-07-31 12:00:00	QQQ	ETF	65.01	65.01	64.75	64.88	3997374.0
2012-07-31 12:30:00	QQQ	ETF	64.88	64.8999	64.75	64.78	776528.0
2012-07-31 13:00:00	QQQ	ETF	64.78	64.97	64.74	64.97	2092729.0
2012-07-31 13:30:00	QQQ	ETF	64.97	64.98	64.85	64.8901	1513157.0
2012-07-31 14:00:00	QQQ	ETF	64.8999	65.06	64.87	65.0399	1970925.0
2012-07-31 14:30:00	QQQ	ETF	65.03	65.08	64.9	64.9	1871794.0

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

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