PREVIEW / etf_30min / 2011-08-02

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-02.parquet
  size:    307 KB
  rows:    10,173

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
2011-08-02 04:00:00	SPY	ETF	128.13	128.13	127.9	128.03	2776.0
2011-08-02 04:30:00	SPY	ETF	127.9	127.9	127.75	127.83	4900.0
2011-08-02 05:00:00	SPY	ETF	127.94	127.94	127.64	127.65	2550.0
2011-08-02 05:30:00	SPY	ETF	127.77	127.8	127.6	127.7	5250.0
2011-08-02 06:00:00	SPY	ETF	127.7	128.05	127.7	128.05	7400.0
2011-08-02 06:30:00	SPY	ETF	127.95	128.01	127.75	127.87	37150.0
2011-08-02 07:00:00	SPY	ETF	127.88	127.99	127.63	127.73	361625.0
2011-08-02 07:30:00	SPY	ETF	127.74	127.86	127.53	127.78	880462.0
2011-08-02 08:00:00	SPY	ETF	127.79	127.8	127.07	127.34	3188914.0
2011-08-02 08:30:00	SPY	ETF	127.34	127.94	127.15	127.9	3527614.0
2011-08-02 09:00:00	SPY	ETF	127.9	127.9	127.6	127.81	2754067.0
2011-08-02 09:30:00	SPY	ETF	127.81	128.43	127.77	128.35	25543595.0
2011-08-02 10:00:00	SPY	ETF	128.36	128.5	127.85	127.94	21122797.0
2011-08-02 10:30:00	SPY	ETF	127.94	128.15	127.6	127.6715	14939197.0
2011-08-02 11:00:00	SPY	ETF	127.67	127.7267	127.23	127.42	19345257.0
2011-08-02 11:30:00	SPY	ETF	127.42	127.56	127.24	127.38	17842941.0
2011-08-02 12:00:00	SPY	ETF	127.39	127.66	127.21	127.525	11987923.0
2011-08-02 12:30:00	SPY	ETF	127.53	127.56	126.63	126.82	27836132.0
2011-08-02 13:00:00	SPY	ETF	126.81	127.25	126.8	127.05	15551366.0
2011-08-02 13:30:00	SPY	ETF	127.06	127.11	126.3	126.4269	19094639.0
2011-08-02 14:00:00	SPY	ETF	126.43	126.96	126.38	126.68	15770061.0
2011-08-02 14:30:00	SPY	ETF	126.68	126.94	126.36	126.87	11607116.0
2011-08-02 15:00:00	SPY	ETF	126.87	126.95	126.13	126.265	23054867.0
2011-08-02 15:30:00	SPY	ETF	126.25	126.38	125.49	125.5	61149348.0
2011-08-02 16:00:00	SPY	ETF	125.5	128.8023	125.17	125.38	20877430.0
2011-08-02 16:30:00	SPY	ETF	125.39	126.9658	125.06	125.13	12108427.0
2011-08-02 17:00:00	SPY	ETF	125.13	125.5153	125.04	125.05	10067026.0
2011-08-02 17:30:00	SPY	ETF	125.05	125.44	125.03	125.3	644652.0
2011-08-02 18:00:00	SPY	ETF	125.3	125.49	124.96	125.17	1049917.0
2011-08-02 18:30:00	SPY	ETF	125.16	125.18	125.02	125.09	127998.0
2011-08-02 19:00:00	SPY	ETF	125.1	125.22	125.07	125.18	68107.0
2011-08-02 19:30:00	SPY	ETF	125.16	125.22	125.1	125.12	122822.0
2011-08-02 04:00:00	QQQ	ETF	57.5	57.5	57.41	57.41	2148.0
2011-08-02 06:30:00	QQQ	ETF	57.4	57.4	57.4	57.4	300.0
2011-08-02 07:00:00	QQQ	ETF	57.41	57.43	57.31	57.31	46550.0
2011-08-02 07:30:00	QQQ	ETF	57.36	57.42	57.28	57.39	162623.0
2011-08-02 08:00:00	QQQ	ETF	57.39	57.39	57.15	57.18	1251643.0
2011-08-02 08:30:00	QQQ	ETF	57.16	57.46	57.13	57.45	612571.0
2011-08-02 09:00:00	QQQ	ETF	57.44	57.46	57.33	57.46	378780.0
2011-08-02 09:30:00	QQQ	ETF	57.46	57.64	57.38	57.62	6600400.0
2011-08-02 10:00:00	QQQ	ETF	57.63	57.72	57.5	57.55	8130499.0
2011-08-02 10:30:00	QQQ	ETF	57.54	57.66	57.38	57.415	5116824.0
2011-08-02 11:00:00	QQQ	ETF	57.42	57.42	57.17	57.29	8858714.0
2011-08-02 11:30:00	QQQ	ETF	57.285	57.36	57.22	57.275	4272958.0
2011-08-02 12:00:00	QQQ	ETF	57.28	57.41	57.21	57.38	2764561.0
2011-08-02 12:30:00	QQQ	ETF	57.39	57.39	56.89	56.9705	7235031.0
2011-08-02 13:00:00	QQQ	ETF	56.979	57.13	56.93	57.02	2791459.0
2011-08-02 13:30:00	QQQ	ETF	57.03	57.05	56.58	56.64	5704944.0
2011-08-02 14:00:00	QQQ	ETF	56.64	56.91	56.62	56.77	3408368.0
2011-08-02 14:30:00	QQQ	ETF	56.78	56.92	56.605	56.88	3387071.0

> showing 50 of 10,173 rows — these rows as CSV

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