PREVIEW / etf_30min / 2013-07-11

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-11.parquet
  size:    338 KB
  rows:    11,370

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-07-11 04:00:00	SPY	ETF	166.75	167.07	166.75	166.99	54012.0
2013-07-11 04:30:00	SPY	ETF	167.02	167.07	166.95	167.05	20405.0
2013-07-11 05:00:00	SPY	ETF	167.1	167.1	166.81	166.83	17100.0
2013-07-11 05:30:00	SPY	ETF	166.85	166.94	166.81	166.91	6859.0
2013-07-11 06:00:00	SPY	ETF	166.91	166.99	166.78	166.8	76191.0
2013-07-11 06:30:00	SPY	ETF	166.75	167.01	166.75	166.87	138575.0
2013-07-11 07:00:00	SPY	ETF	166.87	166.98	166.83	166.93	114255.0
2013-07-11 07:30:00	SPY	ETF	166.93	167.2	166.93	167.0	420844.0
2013-07-11 08:00:00	SPY	ETF	166.9	167.17	166.85	167.09	502283.0
2013-07-11 08:30:00	SPY	ETF	167.04	167.08	166.79	166.86	1424844.0
2013-07-11 09:00:00	SPY	ETF	166.87	167.13	166.87	167.12	1723313.0
2013-07-11 09:30:00	SPY	ETF	167.11	167.15	166.68	166.795	19209659.0
2013-07-11 10:00:00	SPY	ETF	166.8	166.92	166.67	166.84	9568799.0
2013-07-11 10:30:00	SPY	ETF	166.83	166.91	166.53	166.855	11372205.0
2013-07-11 11:00:00	SPY	ETF	166.85	167.0	166.81	166.99	6907150.0
2013-07-11 11:30:00	SPY	ETF	167.0	167.04	166.84	166.97	5400145.0
2013-07-11 12:00:00	SPY	ETF	166.965	166.97	166.74	166.83	4202401.0
2013-07-11 12:30:00	SPY	ETF	166.82	166.91	166.75	166.865	3274780.0
2013-07-11 13:00:00	SPY	ETF	166.86	166.93	166.82	166.8799	4943296.0
2013-07-11 13:30:00	SPY	ETF	166.88	166.94	166.76	166.909	3687065.0
2013-07-11 14:00:00	SPY	ETF	166.91	167.32	166.88	167.24	11615501.0
2013-07-11 14:30:00	SPY	ETF	167.2301	167.45	167.18	167.27	6866181.0
2013-07-11 15:00:00	SPY	ETF	167.27	167.46	167.2	167.41	6029056.0
2013-07-11 15:30:00	SPY	ETF	167.42	167.61	167.23	167.43	18227163.0
2013-07-11 16:00:00	SPY	ETF	167.43	167.53	165.1774	167.46	6689158.0
2013-07-11 16:30:00	SPY	ETF	167.47	167.53	165.1774	167.44	2914795.0
2013-07-11 17:00:00	SPY	ETF	167.41	167.41	167.36	167.4	57999.0
2013-07-11 17:30:00	SPY	ETF	167.4	167.42	167.37	167.38	11267.0
2013-07-11 18:00:00	SPY	ETF	167.38	167.49	167.36	167.4	26709.0
2013-07-11 18:30:00	SPY	ETF	167.38	167.45	167.37	167.37	13050.0
2013-07-11 19:00:00	SPY	ETF	167.35	167.35	167.3	167.35	32355.0
2013-07-11 19:30:00	SPY	ETF	167.33	167.34	167.22	167.22	55317.0
2013-07-11 04:00:00	QQQ	ETF	74.2	74.33	74.2	74.3	16100.0
2013-07-11 04:30:00	QQQ	ETF	74.27	74.27	74.27	74.27	600.0
2013-07-11 05:00:00	QQQ	ETF	74.25	74.25	74.18	74.18	1870.0
2013-07-11 06:00:00	QQQ	ETF	74.17	74.2	74.15	74.15	1600.0
2013-07-11 06:30:00	QQQ	ETF	74.18	74.21	74.18	74.18	1107.0
2013-07-11 07:00:00	QQQ	ETF	74.15	74.22	74.14	74.2	28902.0
2013-07-11 07:30:00	QQQ	ETF	74.21	74.29	74.21	74.24	20771.0
2013-07-11 08:00:00	QQQ	ETF	74.22	74.28	74.18	74.21	54992.0
2013-07-11 08:30:00	QQQ	ETF	74.21	74.22	74.14	74.17	45683.0
2013-07-11 09:00:00	QQQ	ETF	74.18	74.32	74.17	74.29	138796.0
2013-07-11 09:30:00	QQQ	ETF	74.29	74.43	74.25	74.37	4072469.0
2013-07-11 10:00:00	QQQ	ETF	74.37	74.45	74.27	74.4	2252671.0
2013-07-11 10:30:00	QQQ	ETF	74.3901	74.54	74.27	74.518	3568725.0
2013-07-11 11:00:00	QQQ	ETF	74.52	74.635	74.49	74.625	3676963.0
2013-07-11 11:30:00	QQQ	ETF	74.625	74.66	74.58	74.65	1780432.0
2013-07-11 12:00:00	QQQ	ETF	74.65	74.655	74.59	74.64	3122993.0
2013-07-11 12:30:00	QQQ	ETF	74.63	74.73	74.6	74.73	2750964.0
2013-07-11 13:00:00	QQQ	ETF	74.725	74.76	74.69	74.715	2237852.0

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

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