PREVIEW / etf_30min / 2013-04-16

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-16.parquet
  size:    325 KB
  rows:    10,802

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-04-16 04:00:00	SPY	ETF	155.57	155.57	155.36	155.36	24112.0
2013-04-16 04:30:00	SPY	ETF	155.4	155.42	155.26	155.26	15399.0
2013-04-16 05:00:00	SPY	ETF	155.32	155.59	155.31	155.59	52245.0
2013-04-16 05:30:00	SPY	ETF	155.55	155.82	155.55	155.7	20240.0
2013-04-16 06:00:00	SPY	ETF	155.69	155.69	155.57	155.6	49540.0
2013-04-16 06:30:00	SPY	ETF	155.6	155.7	155.43	155.47	219676.0
2013-04-16 07:00:00	SPY	ETF	155.5	155.68	155.49	155.63	190119.0
2013-04-16 07:30:00	SPY	ETF	155.63	156.11	155.63	155.975	803678.0
2013-04-16 08:00:00	SPY	ETF	155.975	156.22	155.15	156.12	1539521.0
2013-04-16 08:30:00	SPY	ETF	156.13	156.39	156.06	156.26	1582479.0
2013-04-16 09:00:00	SPY	ETF	156.26	156.31	155.17	156.3	1823716.0
2013-04-16 09:30:00	SPY	ETF	156.29	156.57	156.16	156.372	21313656.0
2013-04-16 10:00:00	SPY	ETF	156.38	156.56	156.1	156.2	13153829.0
2013-04-16 10:30:00	SPY	ETF	156.208	156.4	155.91	156.17	11056510.0
2013-04-16 11:00:00	SPY	ETF	156.16	156.65	156.08	156.62	12051740.0
2013-04-16 11:30:00	SPY	ETF	156.61	156.99	156.52	156.878	9479122.0
2013-04-16 12:00:00	SPY	ETF	156.88	156.95	156.75	156.86	5959110.0
2013-04-16 12:30:00	SPY	ETF	156.85	157.23	156.82	157.18	5513491.0
2013-04-16 13:00:00	SPY	ETF	157.18	157.22	157.07	157.13	4441509.0
2013-04-16 13:30:00	SPY	ETF	157.14	157.28	156.99	157.03	4737961.0
2013-04-16 14:00:00	SPY	ETF	157.03	157.14	156.78	156.93	6276633.0
2013-04-16 14:30:00	SPY	ETF	156.921	157.03	156.68	156.725	6331386.0
2013-04-16 15:00:00	SPY	ETF	156.715	157.14	156.69	157.09	7529344.0
2013-04-16 15:30:00	SPY	ETF	157.09	157.49	157.08	157.39	20324615.0
2013-04-16 16:00:00	SPY	ETF	157.4	157.43	156.7731	157.23	6653180.0
2013-04-16 16:30:00	SPY	ETF	157.25	157.3989	155.1869	157.35	2301444.0
2013-04-16 17:00:00	SPY	ETF	157.34	157.42	155.1869	157.42	1080420.0
2013-04-16 17:30:00	SPY	ETF	157.42	157.42	157.39	157.4	26785.0
2013-04-16 18:00:00	SPY	ETF	157.38	157.38	157.23	157.23	85749.0
2013-04-16 18:30:00	SPY	ETF	157.23	157.25	156.96	157.06	139783.0
2013-04-16 19:00:00	SPY	ETF	157.08	157.14	157.02	157.11	32366.0
2013-04-16 19:30:00	SPY	ETF	157.15	157.15	157.02	157.05	36408.0
2013-04-16 04:00:00	QQQ	ETF	68.71	68.73	68.62	68.62	34000.0
2013-04-16 04:30:00	QQQ	ETF	68.64	68.64	68.64	68.64	4000.0
2013-04-16 05:00:00	QQQ	ETF	68.62	68.69	68.62	68.69	12400.0
2013-04-16 05:30:00	QQQ	ETF	68.69	68.82	68.69	68.82	4600.0
2013-04-16 06:00:00	QQQ	ETF	68.77	68.77	68.76	68.76	3100.0
2013-04-16 06:30:00	QQQ	ETF	68.75	68.75	68.66	68.69	12700.0
2013-04-16 07:00:00	QQQ	ETF	68.71	68.78	68.71	68.73	18250.0
2013-04-16 07:30:00	QQQ	ETF	68.78	68.92	68.78	68.9	196935.0
2013-04-16 08:00:00	QQQ	ETF	68.89	68.99	68.7	68.92	143860.0
2013-04-16 08:30:00	QQQ	ETF	68.97	69.02	68.93	68.98	455743.0
2013-04-16 09:00:00	QQQ	ETF	68.98	69.02	68.88	68.97	221078.0
2013-04-16 09:30:00	QQQ	ETF	68.98	69.1	68.84	68.9365	3872047.0
2013-04-16 10:00:00	QQQ	ETF	68.94	69.069	68.85	68.95	2093515.0
2013-04-16 10:30:00	QQQ	ETF	68.95	69.0601	68.81	68.9593	1362078.0
2013-04-16 11:00:00	QQQ	ETF	68.95	69.255	68.91	69.18	3451104.0
2013-04-16 11:30:00	QQQ	ETF	69.18	69.43	69.14	69.37	1782751.0
2013-04-16 12:00:00	QQQ	ETF	69.37	69.42	69.29	69.331	881719.0
2013-04-16 12:30:00	QQQ	ETF	69.3301	69.49	69.32	69.47	1061360.0

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

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