PREVIEW / etf_30min / 2012-08-02

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-02.parquet
  size:    282 KB
  rows:    9,607

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-08-02 04:00:00	SPY	ETF	137.6	137.7	137.6	137.7	5200.0
2012-08-02 05:00:00	SPY	ETF	137.96	137.99	137.96	137.99	4150.0
2012-08-02 05:30:00	SPY	ETF	138.03	138.27	138.03	138.27	19196.0
2012-08-02 06:00:00	SPY	ETF	138.24	138.27	138.15	138.15	35900.0
2012-08-02 06:30:00	SPY	ETF	138.17	138.25	138.07	138.18	33920.0
2012-08-02 07:00:00	SPY	ETF	138.15	138.32	138.02	138.11	215742.0
2012-08-02 07:30:00	SPY	ETF	138.11	138.25	137.51	138.14	946816.0
2012-08-02 08:00:00	SPY	ETF	138.16	138.49	138.11	138.35	1321494.0
2012-08-02 08:30:00	SPY	ETF	138.28	138.93	136.4	136.57	12569523.0
2012-08-02 09:00:00	SPY	ETF	136.55	136.78	136.23	136.54	3810366.0
2012-08-02 09:30:00	SPY	ETF	136.55	137.11	136.21	137.04	21245406.0
2012-08-02 10:00:00	SPY	ETF	137.05	137.57	136.75	137.51	15594188.0
2012-08-02 10:30:00	SPY	ETF	137.51	137.54	136.81	136.86	16600536.0
2012-08-02 11:00:00	SPY	ETF	136.86	137.02	136.35	136.62	17219931.0
2012-08-02 11:30:00	SPY	ETF	136.62	136.63	135.91	136.16	14055437.0
2012-08-02 12:00:00	SPY	ETF	136.15	136.28	136.01	136.022	6753817.0
2012-08-02 12:30:00	SPY	ETF	136.02	136.09	135.58	136.0699	9502968.0
2012-08-02 13:00:00	SPY	ETF	136.07	136.16	135.91	136.02	4140998.0
2012-08-02 13:30:00	SPY	ETF	136.02	136.4	135.84	135.859	5835211.0
2012-08-02 14:00:00	SPY	ETF	135.85	136.1	135.77	135.995	5780277.0
2012-08-02 14:30:00	SPY	ETF	136.0	136.43	135.97	136.18	8803882.0
2012-08-02 15:00:00	SPY	ETF	136.19	136.64	136.18	136.29	11153835.0
2012-08-02 15:30:00	SPY	ETF	136.3	136.78	136.28	136.66	26317892.0
2012-08-02 16:00:00	SPY	ETF	136.66	136.85	136.57	136.82	9523541.0
2012-08-02 16:30:00	SPY	ETF	136.83	136.84	135.94	136.81	1780866.0
2012-08-02 17:00:00	SPY	ETF	136.81	136.81	136.7	136.78	1542152.0
2012-08-02 17:30:00	SPY	ETF	136.78	136.79	136.72	136.73	74266.0
2012-08-02 18:00:00	SPY	ETF	136.73	136.76	136.68	136.71	50189.0
2012-08-02 18:30:00	SPY	ETF	136.71	136.76	136.71	136.76	10459.0
2012-08-02 19:00:00	SPY	ETF	136.76	136.77	136.74	136.77	6250.0
2012-08-02 19:30:00	SPY	ETF	136.75	136.77	136.71	136.75	70238.0
2012-08-02 06:30:00	QQQ	ETF	64.72	64.77	64.72	64.77	400.0
2012-08-02 07:00:00	QQQ	ETF	64.71	64.74	64.7	64.7	650.0
2012-08-02 07:30:00	QQQ	ETF	64.76	64.76	64.58	64.68	15600.0
2012-08-02 08:00:00	QQQ	ETF	64.77	64.89	64.74	64.84	132395.0
2012-08-02 08:30:00	QQQ	ETF	64.71	65.09	63.96	64.04	1037046.0
2012-08-02 09:00:00	QQQ	ETF	64.03	64.15	63.99	64.1	1256209.0
2012-08-02 09:30:00	QQQ	ETF	64.1	64.68	63.91	64.658	4760590.0
2012-08-02 10:00:00	QQQ	ETF	64.64	65.02	64.5098	65.0	4884709.0
2012-08-02 10:30:00	QQQ	ETF	65.0	65.01	64.59	64.63	3908099.0
2012-08-02 11:00:00	QQQ	ETF	64.62	64.71	64.33	64.51	4676063.0
2012-08-02 11:30:00	QQQ	ETF	64.5	64.51	64.05	64.2	2851451.0
2012-08-02 12:00:00	QQQ	ETF	64.19	64.28	64.15	64.16	1481735.0
2012-08-02 12:30:00	QQQ	ETF	64.1697	64.21	63.965	64.18	2107092.0
2012-08-02 13:00:00	QQQ	ETF	64.18	64.23	64.07	64.13	1124510.0
2012-08-02 13:30:00	QQQ	ETF	64.13	64.16	64.04	64.05	734728.0
2012-08-02 14:00:00	QQQ	ETF	64.0415	64.17	64.02	64.13	1402094.0
2012-08-02 14:30:00	QQQ	ETF	64.14	64.32	64.12	64.21	2076200.0
2012-08-02 15:00:00	QQQ	ETF	64.21	64.37	64.2	64.25	1452476.0
2012-08-02 15:30:00	QQQ	ETF	64.24	64.49	64.24	64.37	3264760.0

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

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