PREVIEW / etf_30min / 2012-12-14

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-14.parquet
  size:    281 KB
  rows:    9,731

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-12-14 04:00:00	SPY	ETF	142.81	142.94	142.8	142.82	5002.0
2012-12-14 04:30:00	SPY	ETF	142.94	142.94	142.87	142.87	29400.0
2012-12-14 05:30:00	SPY	ETF	142.81	142.81	142.81	142.81	100.0
2012-12-14 06:00:00	SPY	ETF	142.91	142.91	142.83	142.9	3200.0
2012-12-14 06:30:00	SPY	ETF	142.92	142.94	142.88	142.93	19435.0
2012-12-14 07:00:00	SPY	ETF	142.9	142.92	142.8	142.89	71289.0
2012-12-14 07:30:00	SPY	ETF	142.88	142.88	142.6	142.6	187845.0
2012-12-14 08:00:00	SPY	ETF	142.62	142.9	142.57	142.75	423091.0
2012-12-14 08:30:00	SPY	ETF	142.75	142.78	142.32	142.46	1634065.0
2012-12-14 09:00:00	SPY	ETF	142.47	142.85	142.29	142.31	1723992.0
2012-12-14 09:30:00	SPY	ETF	142.32	142.58	142.11	142.25	11278198.0
2012-12-14 10:00:00	SPY	ETF	142.25	142.46	142.14	142.3	11250565.0
2012-12-14 10:30:00	SPY	ETF	142.3	142.53	142.24	142.35	9670460.0
2012-12-14 11:00:00	SPY	ETF	142.3501	142.425	142.23	142.26	9971896.0
2012-12-14 11:30:00	SPY	ETF	142.27	142.3	142.02	142.23	5881467.0
2012-12-14 12:00:00	SPY	ETF	142.23	142.48	142.21	142.43	7437506.0
2012-12-14 12:30:00	SPY	ETF	142.43	142.47	142.32	142.35	3671924.0
2012-12-14 13:00:00	SPY	ETF	142.35	142.39	142.21	142.29	3056069.0
2012-12-14 13:30:00	SPY	ETF	142.29	142.44	142.25	142.42	4167731.0
2012-12-14 14:00:00	SPY	ETF	142.41	142.49	142.31	142.318	4239337.0
2012-12-14 14:30:00	SPY	ETF	142.31	142.3225	141.99	142.03	5191124.0
2012-12-14 15:00:00	SPY	ETF	142.031	142.1	141.88	142.03	9833655.0
2012-12-14 15:30:00	SPY	ETF	142.02	142.25	141.93	142.11	18754282.0
2012-12-14 16:00:00	SPY	ETF	142.1	142.3	141.9723	142.21	18417684.0
2012-12-14 16:30:00	SPY	ETF	142.21	142.34	142.0547	142.33	5284256.0
2012-12-14 17:00:00	SPY	ETF	142.31	142.54	142.23	142.27	286716.0
2012-12-14 17:30:00	SPY	ETF	142.27	142.27	142.13	142.14	168229.0
2012-12-14 18:00:00	SPY	ETF	142.14	142.19	142.12	142.18	22040.0
2012-12-14 18:30:00	SPY	ETF	142.18	142.19	142.16	142.16	4850.0
2012-12-14 19:00:00	SPY	ETF	142.15	142.19	142.15	142.19	2383.0
2012-12-14 19:30:00	SPY	ETF	142.19	142.19	142.12	142.15	22032.0
2012-12-14 05:00:00	QQQ	ETF	65.33	65.33	65.33	65.33	900.0
2012-12-14 06:00:00	QQQ	ETF	65.33	65.33	65.33	65.33	100.0
2012-12-14 06:30:00	QQQ	ETF	65.36	65.36	65.36	65.36	100.0
2012-12-14 07:00:00	QQQ	ETF	65.34	65.34	65.31	65.32	27000.0
2012-12-14 07:30:00	QQQ	ETF	65.29	65.29	65.14	65.14	110200.0
2012-12-14 08:00:00	QQQ	ETF	65.15	65.34	65.11	65.18	55386.0
2012-12-14 08:30:00	QQQ	ETF	65.13	65.13	64.96	64.99	192575.0
2012-12-14 09:00:00	QQQ	ETF	65.0	65.05	64.89	64.89	578550.0
2012-12-14 09:30:00	QQQ	ETF	64.89	65.08	64.66	64.83	6508990.0
2012-12-14 10:00:00	QQQ	ETF	64.82	64.94	64.74	64.86	4642672.0
2012-12-14 10:30:00	QQQ	ETF	64.87	64.96	64.75	64.86	2929606.0
2012-12-14 11:00:00	QQQ	ETF	64.86	64.86	64.74	64.78	2726864.0
2012-12-14 11:30:00	QQQ	ETF	64.78	64.88	64.7	64.81	2439708.0
2012-12-14 12:00:00	QQQ	ETF	64.82	64.99	64.815	64.94	2481086.0
2012-12-14 12:30:00	QQQ	ETF	64.941	64.97	64.87	64.91	913851.0
2012-12-14 13:00:00	QQQ	ETF	64.9001	64.93	64.7899	64.83	766097.0
2012-12-14 13:30:00	QQQ	ETF	64.83	64.87	64.765	64.87	1613775.0
2012-12-14 14:00:00	QQQ	ETF	64.865	64.88	64.77	64.77	790713.0
2012-12-14 14:30:00	QQQ	ETF	64.78	64.79	64.48	64.5	2961764.0

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

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