PREVIEW / etf_30min / 2013-02-15

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-15.parquet
  size:    302 KB
  rows:    10,239

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-15 04:00:00	SPY	ETF	152.07	152.07	151.9	151.92	27350.0
2013-02-15 04:30:00	SPY	ETF	151.87	151.87	151.85	151.85	2000.0
2013-02-15 05:00:00	SPY	ETF	152.02	152.1	152.02	152.1	6000.0
2013-02-15 05:30:00	SPY	ETF	152.12	152.12	152.04	152.05	12132.0
2013-02-15 06:00:00	SPY	ETF	152.05	152.09	152.03	152.09	7830.0
2013-02-15 06:30:00	SPY	ETF	152.09	152.17	152.09	152.16	3200.0
2013-02-15 07:00:00	SPY	ETF	152.12	152.16	152.04	152.1	140315.0
2013-02-15 07:30:00	SPY	ETF	152.08	152.14	152.08	152.1	157906.0
2013-02-15 08:00:00	SPY	ETF	152.1	152.3	151.95	152.23	395704.0
2013-02-15 08:30:00	SPY	ETF	152.32	152.36	152.16	152.29	1000800.0
2013-02-15 09:00:00	SPY	ETF	152.29	152.5	152.17	152.43	1487713.0
2013-02-15 09:30:00	SPY	ETF	152.43	152.54	152.29	152.49	12429744.0
2013-02-15 10:00:00	SPY	ETF	152.49	152.59	152.38	152.41	6904730.0
2013-02-15 10:30:00	SPY	ETF	152.42	152.5	152.24	152.4887	6974603.0
2013-02-15 11:00:00	SPY	ETF	152.489	152.52	152.29	152.36	4887098.0
2013-02-15 11:30:00	SPY	ETF	152.35	152.35	152.11	152.23	60678566.0
2013-02-15 12:00:00	SPY	ETF	152.24	152.24	151.94	152.05	12546367.0
2013-02-15 12:30:00	SPY	ETF	152.048	152.17	151.98	152.15	4627013.0
2013-02-15 13:00:00	SPY	ETF	152.16	152.24	152.12	152.17	2842331.0
2013-02-15 13:30:00	SPY	ETF	152.165	152.32	152.16	152.31	5750448.0
2013-02-15 14:00:00	SPY	ETF	152.31	152.32	151.58	151.605	17800262.0
2013-02-15 14:30:00	SPY	ETF	151.6044	152.297	151.55	151.66	14741808.0
2013-02-15 15:00:00	SPY	ETF	151.67	152.297	151.63	151.875	8902369.0
2013-02-15 15:30:00	SPY	ETF	151.88	152.15	151.84	152.149	15395597.0
2013-02-15 16:00:00	SPY	ETF	152.15	152.297	151.68	152.1	8929056.0
2013-02-15 16:30:00	SPY	ETF	152.1	152.26	151.9837	152.12	385762.0
2013-02-15 17:00:00	SPY	ETF	152.2974	152.2974	152.11	152.12	558265.0
2013-02-15 17:30:00	SPY	ETF	152.15	152.22	152.11	152.21	171316.0
2013-02-15 18:00:00	SPY	ETF	152.18	152.25	152.14	152.15	66958.0
2013-02-15 18:30:00	SPY	ETF	152.13	152.14	152.08	152.08	20099.0
2013-02-15 19:00:00	SPY	ETF	152.08	152.08	152.06	152.07	7323.0
2013-02-15 19:30:00	SPY	ETF	152.08	152.09	152.0	152.02	28274.0
2013-02-15 05:30:00	QQQ	ETF	67.85	67.85	67.81	67.81	300.0
2013-02-15 06:00:00	QQQ	ETF	67.8	67.8	67.8	67.8	100.0
2013-02-15 06:30:00	QQQ	ETF	67.84	67.84	67.84	67.84	300.0
2013-02-15 07:00:00	QQQ	ETF	67.82	67.83	67.82	67.83	4100.0
2013-02-15 07:30:00	QQQ	ETF	67.83	67.83	67.82	67.83	7400.0
2013-02-15 08:00:00	QQQ	ETF	67.84	67.9	67.84	67.88	13800.0
2013-02-15 08:30:00	QQQ	ETF	67.9	67.94	67.89	67.92	54725.0
2013-02-15 09:00:00	QQQ	ETF	67.91	67.99	67.89	67.98	343171.0
2013-02-15 09:30:00	QQQ	ETF	67.97	68.05	67.9	68.025	2841114.0
2013-02-15 10:00:00	QQQ	ETF	68.03	68.11	68.01	68.05	2150882.0
2013-02-15 10:30:00	QQQ	ETF	68.04	68.04	67.95	68.025	1408413.0
2013-02-15 11:00:00	QQQ	ETF	68.0203	68.055	67.95	67.99	1056016.0
2013-02-15 11:30:00	QQQ	ETF	67.98	67.98	67.84	67.9	1504072.0
2013-02-15 12:00:00	QQQ	ETF	67.91	67.91	67.77	67.8416	1395393.0
2013-02-15 12:30:00	QQQ	ETF	67.84	67.89	67.82	67.87	590906.0
2013-02-15 13:00:00	QQQ	ETF	67.8791	67.9	67.8	67.8284	792008.0
2013-02-15 13:30:00	QQQ	ETF	67.83	67.939	67.82	67.93	630085.0
2013-02-15 14:00:00	QQQ	ETF	67.93	67.95	67.58	67.59	2685144.0

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

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