PREVIEW / etf_30min / 2013-06-24

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-24.parquet
  size:    359 KB
  rows:    11,873

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-06-24 04:00:00	SPY	ETF	158.24	158.24	157.68	157.69	38170.0
2013-06-24 04:30:00	SPY	ETF	157.69	157.88	157.45	157.62	71600.0
2013-06-24 05:00:00	SPY	ETF	157.65	157.9	157.5	157.8	50657.0
2013-06-24 05:30:00	SPY	ETF	157.8	157.89	157.68	157.68	35375.0
2013-06-24 06:00:00	SPY	ETF	157.63	157.77	157.47	157.49	86094.0
2013-06-24 06:30:00	SPY	ETF	157.49	157.59	157.33	157.43	192835.0
2013-06-24 07:00:00	SPY	ETF	157.43	157.52	157.07	157.07	248515.0
2013-06-24 07:30:00	SPY	ETF	157.09	157.27	156.91	157.26	701220.0
2013-06-24 08:00:00	SPY	ETF	157.26	158.46	156.96	157.22	713447.0
2013-06-24 08:30:00	SPY	ETF	157.22	157.91	157.14	157.86	1483112.0
2013-06-24 09:00:00	SPY	ETF	157.86	157.92	157.39	157.42	1385429.0
2013-06-24 09:30:00	SPY	ETF	157.41	157.49	156.34	156.44	31254523.0
2013-06-24 10:00:00	SPY	ETF	156.43	156.57	156.07	156.27	19082947.0
2013-06-24 10:30:00	SPY	ETF	156.26	156.91	156.01	156.59	17241817.0
2013-06-24 11:00:00	SPY	ETF	156.58	156.73	155.78	155.8	12930834.0
2013-06-24 11:30:00	SPY	ETF	155.8	156.36	155.78	156.25	13424103.0
2013-06-24 12:00:00	SPY	ETF	156.25	156.45	155.73	156.18	12382406.0
2013-06-24 12:30:00	SPY	ETF	156.185	156.64	156.185	156.59	13006129.0
2013-06-24 13:00:00	SPY	ETF	156.58	157.05	156.34	156.98	11839828.0
2013-06-24 13:30:00	SPY	ETF	156.98	157.36	156.85	157.3	11977067.0
2013-06-24 14:00:00	SPY	ETF	157.295	158.11	157.13	158.01	14038632.0
2013-06-24 14:30:00	SPY	ETF	158.02	158.43	157.76	157.91	12568290.0
2013-06-24 15:00:00	SPY	ETF	157.91	158.22	157.52	157.57	12371291.0
2013-06-24 15:30:00	SPY	ETF	157.57	157.99	157.02	157.03	22086760.0
2013-06-24 16:00:00	SPY	ETF	157.01	157.5169	156.9163	157.04	7634880.0
2013-06-24 16:30:00	SPY	ETF	157.04	157.56	157.01	157.11	382308.0
2013-06-24 17:00:00	SPY	ETF	157.08	157.1	156.99	157.02	164842.0
2013-06-24 17:30:00	SPY	ETF	157.02	157.07	156.99	157.05	43632.0
2013-06-24 18:00:00	SPY	ETF	157.09	157.21	157.09	157.12	164630.0
2013-06-24 18:30:00	SPY	ETF	157.13	157.43	157.13	157.35	120181.0
2013-06-24 19:00:00	SPY	ETF	157.36	157.36	157.08	157.09	58985.0
2013-06-24 19:30:00	SPY	ETF	157.17	157.37	157.09	157.36	141170.0
2013-06-24 04:00:00	QQQ	ETF	70.1	70.12	69.93	69.93	1500.0
2013-06-24 04:30:00	QQQ	ETF	69.88	69.99	69.83	69.93	1540.0
2013-06-24 05:00:00	QQQ	ETF	69.98	70.08	69.98	70.08	600.0
2013-06-24 05:30:00	QQQ	ETF	70.11	70.11	69.98	69.98	5500.0
2013-06-24 06:00:00	QQQ	ETF	69.93	69.98	69.88	69.88	800.0
2013-06-24 06:30:00	QQQ	ETF	69.86	69.92	69.86	69.92	4100.0
2013-06-24 07:00:00	QQQ	ETF	69.83	69.9	69.75	69.75	9474.0
2013-06-24 07:30:00	QQQ	ETF	69.75	69.78	69.66	69.78	15100.0
2013-06-24 08:00:00	QQQ	ETF	69.82	69.85	69.72	69.76	50149.0
2013-06-24 08:30:00	QQQ	ETF	69.76	70.1	69.74	70.07	254329.0
2013-06-24 09:00:00	QQQ	ETF	70.07	70.07	69.83	69.86	111217.0
2013-06-24 09:30:00	QQQ	ETF	69.85	69.92	69.34	69.37	6329508.0
2013-06-24 10:00:00	QQQ	ETF	69.36	69.4999	69.2	69.42	3483745.0
2013-06-24 10:30:00	QQQ	ETF	69.4195	69.7	69.32	69.54	3689166.0
2013-06-24 11:00:00	QQQ	ETF	69.54	69.6	69.15	69.17	2118798.0
2013-06-24 11:30:00	QQQ	ETF	69.17	69.47	69.1699	69.41	1707758.0
2013-06-24 12:00:00	QQQ	ETF	69.401	69.49	69.2	69.4099	2078339.0
2013-06-24 12:30:00	QQQ	ETF	69.41	69.6	69.39	69.58	1792160.0

> showing 50 of 11,873 rows — these rows as CSV

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