PREVIEW / etf_30min / 2013-02-14

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-14.parquet
  size:    298 KB
  rows:    10,226

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
2013-02-14 04:00:00	SPY	ETF	152.04	152.1	151.99	151.99	2800.0
2013-02-14 05:00:00	SPY	ETF	151.85	151.85	151.67	151.69	14600.0
2013-02-14 05:30:00	SPY	ETF	151.67	151.67	151.51	151.51	10985.0
2013-02-14 06:00:00	SPY	ETF	151.5	151.54	151.4	151.52	59686.0
2013-02-14 06:30:00	SPY	ETF	151.54	151.62	151.54	151.57	29770.0
2013-02-14 07:00:00	SPY	ETF	151.57	151.67	151.51	151.63	2064814.0
2013-02-14 07:30:00	SPY	ETF	151.62	151.8	151.6	151.75	445607.0
2013-02-14 08:00:00	SPY	ETF	151.75	151.88	151.35	151.86	886425.0
2013-02-14 08:30:00	SPY	ETF	151.85	151.96	151.66	151.71	1366339.0
2013-02-14 09:00:00	SPY	ETF	151.7	151.75	151.57	151.7	1665292.0
2013-02-14 09:30:00	SPY	ETF	151.69	151.99	151.52	151.83	9830932.0
2013-02-14 10:00:00	SPY	ETF	151.84	152.07	151.83	152.0199	5417803.0
2013-02-14 10:30:00	SPY	ETF	152.01	152.29	152.0	152.18	6010009.0
2013-02-14 11:00:00	SPY	ETF	152.18	152.25	152.05	152.09	3624186.0
2013-02-14 11:30:00	SPY	ETF	152.09	152.17	151.99	152.11	3274689.0
2013-02-14 12:00:00	SPY	ETF	152.11	152.22	152.07	152.14	3201138.0
2013-02-14 12:30:00	SPY	ETF	152.14	152.31	152.08	152.2871	3715636.0
2013-02-14 13:00:00	SPY	ETF	152.29	152.38	152.14	152.16	3466920.0
2013-02-14 13:30:00	SPY	ETF	152.16	152.29	152.16	152.24	2483795.0
2013-02-14 14:00:00	SPY	ETF	152.235	152.44	152.2	152.36	3779180.0
2013-02-14 14:30:00	SPY	ETF	152.37	152.38	152.27	152.345	3106849.0
2013-02-14 15:00:00	SPY	ETF	152.345	152.44	152.29	152.4	2983249.0
2013-02-14 15:30:00	SPY	ETF	152.41	152.47	152.21	152.29	10042000.0
2013-02-14 16:00:00	SPY	ETF	152.3	152.4	152.2048	152.26	10029627.0
2013-02-14 16:30:00	SPY	ETF	152.25	152.32	152.25	152.3188	668170.0
2013-02-14 17:00:00	SPY	ETF	152.27	152.34	152.26	152.32	322579.0
2013-02-14 17:30:00	SPY	ETF	152.32	152.35	152.3	152.33	520473.0
2013-02-14 18:00:00	SPY	ETF	152.32	152.32	152.25	152.28	53979.0
2013-02-14 18:30:00	SPY	ETF	152.28	152.28	152.27	152.27	1220.0
2013-02-14 19:00:00	SPY	ETF	152.28	152.3	152.28	152.3	8600.0
2013-02-14 19:30:00	SPY	ETF	152.28	152.29	152.25	152.26	15450.0
2013-02-14 04:00:00	QQQ	ETF	67.85	67.85	67.85	67.85	100.0
2013-02-14 04:30:00	QQQ	ETF	67.8	67.8	67.8	67.8	300.0
2013-02-14 05:00:00	QQQ	ETF	67.75	67.75	67.67	67.67	200.0
2013-02-14 05:30:00	QQQ	ETF	67.65	67.66	67.65	67.66	1400.0
2013-02-14 06:00:00	QQQ	ETF	67.63	67.63	67.62	67.62	7700.0
2013-02-14 07:00:00	QQQ	ETF	67.65	67.69	67.64	67.69	1690.0
2013-02-14 07:30:00	QQQ	ETF	67.68	67.73	67.66	67.73	17230.0
2013-02-14 08:00:00	QQQ	ETF	67.66	67.75	67.53	67.75	37218.0
2013-02-14 08:30:00	QQQ	ETF	67.75	67.81	67.695	67.71	62557.0
2013-02-14 09:00:00	QQQ	ETF	67.71	67.71	67.63	67.66	244114.0
2013-02-14 09:30:00	QQQ	ETF	67.65	67.83	67.62	67.67	3542499.0
2013-02-14 10:00:00	QQQ	ETF	67.6799	67.81	67.67	67.77	2511201.0
2013-02-14 10:30:00	QQQ	ETF	67.779	67.94	67.745	67.89	2214432.0
2013-02-14 11:00:00	QQQ	ETF	67.89	67.9201	67.83	67.88	1596078.0
2013-02-14 11:30:00	QQQ	ETF	67.88	67.91	67.84	67.88	802384.0
2013-02-14 12:00:00	QQQ	ETF	67.87	67.97	67.86	67.92	737945.0
2013-02-14 12:30:00	QQQ	ETF	67.91	68.031	67.9	68.03	857138.0
2013-02-14 13:00:00	QQQ	ETF	68.028	68.05	67.92	67.94	1232344.0
2013-02-14 13:30:00	QQQ	ETF	67.9499	68.01	67.94	67.96	816983.0

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

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