PREVIEW / etf_30min / 2012-11-27

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-27.parquet
  size:    290 KB
  rows:    9,784

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-11-27 05:00:00	SPY	ETF	141.05	141.08	140.93	140.93	62300.0
2012-11-27 05:30:00	SPY	ETF	140.91	140.93	140.89	140.9	11550.0
2012-11-27 06:00:00	SPY	ETF	140.85	140.86	140.81	140.85	28154.0
2012-11-27 06:30:00	SPY	ETF	140.89	141.01	140.83	141.01	22800.0
2012-11-27 07:00:00	SPY	ETF	140.95	141.11	140.95	141.06	584967.0
2012-11-27 07:30:00	SPY	ETF	141.07	141.16	140.98	141.09	247318.0
2012-11-27 08:00:00	SPY	ETF	141.09	141.3	140.9	140.9	173732.0
2012-11-27 08:30:00	SPY	ETF	140.95	141.18	140.88	141.08	999334.0
2012-11-27 09:00:00	SPY	ETF	141.09	141.09	140.78	140.91	480788.0
2012-11-27 09:30:00	SPY	ETF	140.91	141.35	140.75	141.265	11699306.0
2012-11-27 10:00:00	SPY	ETF	141.27	141.31	140.49	140.585	14083730.0
2012-11-27 10:30:00	SPY	ETF	140.58	140.79	140.48	140.685	7890529.0
2012-11-27 11:00:00	SPY	ETF	140.695	140.911	140.69	140.88	4050124.0
2012-11-27 11:30:00	SPY	ETF	140.885	141.35	140.79	141.25	10197056.0
2012-11-27 12:00:00	SPY	ETF	141.253	141.39	141.1	141.1765	4331394.0
2012-11-27 12:30:00	SPY	ETF	141.1733	141.28	141.0	141.205	3968293.0
2012-11-27 13:00:00	SPY	ETF	141.2	141.21	140.92	141.0	4362153.0
2012-11-27 13:30:00	SPY	ETF	140.99	141.14	140.95	141.01	4265114.0
2012-11-27 14:00:00	SPY	ETF	141.02	141.205	140.53	140.58	11177309.0
2012-11-27 14:30:00	SPY	ETF	140.57	140.71	140.32	140.65	11817356.0
2012-11-27 15:00:00	SPY	ETF	140.66	141.0834	140.575	140.76	10406815.0
2012-11-27 15:30:00	SPY	ETF	140.76	140.82	140.24	140.42	16333238.0
2012-11-27 16:00:00	SPY	ETF	140.44	141.0934	140.33	140.37	8374952.0
2012-11-27 16:30:00	SPY	ETF	140.37	140.45	140.37	140.43	378938.0
2012-11-27 17:00:00	SPY	ETF	140.42	140.7772	140.39	140.39	264857.0
2012-11-27 17:30:00	SPY	ETF	140.39	140.42	140.36	140.38	64307.0
2012-11-27 18:00:00	SPY	ETF	140.38	140.42	140.33	140.35	130956.0
2012-11-27 18:30:00	SPY	ETF	140.35	140.37	140.2	140.2	697310.0
2012-11-27 19:00:00	SPY	ETF	140.24	140.34	140.19	140.26	9451.0
2012-11-27 19:30:00	SPY	ETF	140.31	140.32	140.19	140.24	27605.0
2012-11-27 04:00:00	QQQ	ETF	65.25	65.28	65.21	65.21	600.0
2012-11-27 04:30:00	QQQ	ETF	65.17	65.17	65.17	65.17	1700.0
2012-11-27 06:00:00	QQQ	ETF	65.13	65.16	65.12	65.16	84650.0
2012-11-27 06:30:00	QQQ	ETF	65.15	65.15	65.15	65.15	100.0
2012-11-27 07:00:00	QQQ	ETF	65.17	65.25	65.17	65.25	11800.0
2012-11-27 07:30:00	QQQ	ETF	65.25	65.28	65.2	65.25	5890.0
2012-11-27 08:00:00	QQQ	ETF	65.25	65.26	65.17	65.17	81910.0
2012-11-27 08:30:00	QQQ	ETF	65.19	65.265	65.14	65.2	91445.0
2012-11-27 09:00:00	QQQ	ETF	65.17	65.17	65.07	65.15	191183.0
2012-11-27 09:30:00	QQQ	ETF	65.16	65.32	65.08	65.23	3553542.0
2012-11-27 10:00:00	QQQ	ETF	65.22	65.25	64.85	64.93	3780389.0
2012-11-27 10:30:00	QQQ	ETF	64.93	65.04	64.88	64.97	1351875.0
2012-11-27 11:00:00	QQQ	ETF	64.97	65.13	64.97	65.09	1165567.0
2012-11-27 11:30:00	QQQ	ETF	65.09	65.3085	65.03	65.2601	1889904.0
2012-11-27 12:00:00	QQQ	ETF	65.27	65.34	65.19	65.24	826424.0
2012-11-27 12:30:00	QQQ	ETF	65.23	65.4	65.15	65.36	904981.0
2012-11-27 13:00:00	QQQ	ETF	65.35	65.35	65.18	65.23	1120174.0
2012-11-27 13:30:00	QQQ	ETF	65.24	65.319	65.2	65.265	867881.0
2012-11-27 14:00:00	QQQ	ETF	65.26	65.35	65.03	65.07	2057260.0
2012-11-27 14:30:00	QQQ	ETF	65.068	65.11	64.92	65.08	2173497.0

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

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