PREVIEW / etf_30min / 2011-03-24

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-24.parquet
  size:    283 KB
  rows:    9,295

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
2011-03-24 04:00:00	SPY	ETF	129.45	129.58	129.45	129.58	2800.0
2011-03-24 04:30:00	SPY	ETF	129.54	129.84	129.54	129.83	700.0
2011-03-24 05:00:00	SPY	ETF	129.81	129.99	129.81	129.85	1300.0
2011-03-24 05:30:00	SPY	ETF	129.76	130.33	129.76	130.16	15250.0
2011-03-24 06:00:00	SPY	ETF	130.15	130.3	130.12	130.3	2100.0
2011-03-24 06:30:00	SPY	ETF	130.21	130.35	130.18	130.34	132800.0
2011-03-24 07:00:00	SPY	ETF	130.3	130.33	130.18	130.23	85875.0
2011-03-24 07:30:00	SPY	ETF	130.24	130.5	130.23	130.49	1181237.0
2011-03-24 08:00:00	SPY	ETF	130.46	130.66	130.27	130.58	2790359.0
2011-03-24 08:30:00	SPY	ETF	130.56	130.56	130.22	130.3	2460521.0
2011-03-24 09:00:00	SPY	ETF	130.3	130.43	130.26	130.41	1907891.0
2011-03-24 09:30:00	SPY	ETF	130.4	130.46	129.81	129.9	23842478.0
2011-03-24 10:00:00	SPY	ETF	129.9	130.09	129.67	130.05	14011665.0
2011-03-24 10:30:00	SPY	ETF	130.05	130.59	130.03	130.54	14933145.0
2011-03-24 11:00:00	SPY	ETF	130.54	130.68	130.48	130.54	11245594.0
2011-03-24 11:30:00	SPY	ETF	130.54	130.7	130.52	130.63	5498597.0
2011-03-24 12:00:00	SPY	ETF	130.63	130.87	130.62	130.83	9688687.0
2011-03-24 12:30:00	SPY	ETF	130.83	130.83	130.45	130.525	9496700.0
2011-03-24 13:00:00	SPY	ETF	130.53	130.67	130.47	130.66	4805911.0
2011-03-24 13:30:00	SPY	ETF	130.65	130.72	130.43	130.6	6699327.0
2011-03-24 14:00:00	SPY	ETF	130.6	130.78	130.6	130.73	4233001.0
2011-03-24 14:30:00	SPY	ETF	130.74	130.89	130.72	130.78	6217251.0
2011-03-24 15:00:00	SPY	ETF	130.775	131.09	130.72	131.01	8947229.0
2011-03-24 15:30:00	SPY	ETF	131.01	131.04	130.81	130.9	18166676.0
2011-03-24 16:00:00	SPY	ETF	130.91	130.96	130.85	130.86	8188773.0
2011-03-24 16:30:00	SPY	ETF	130.86	130.96	129.6825	130.95	1279913.0
2011-03-24 17:00:00	SPY	ETF	130.94	131.78	130.9	131.3	307912.0
2011-03-24 17:30:00	SPY	ETF	131.32	131.49	131.26	131.27	176673.0
2011-03-24 18:00:00	SPY	ETF	131.26	131.4	130.9	131.3	851286.0
2011-03-24 18:30:00	SPY	ETF	131.31	131.39	131.22	131.28	66886.0
2011-03-24 19:00:00	SPY	ETF	131.27	131.32	131.23	131.23	31806.0
2011-03-24 19:30:00	SPY	ETF	131.23	131.29	131.22	131.23	81108.0
2011-03-24 04:00:00	QQQ	ETF	55.75	55.75	55.75	55.75	100.0
2011-03-24 04:30:00	QQQ	ETF	55.74	55.78	55.74	55.78	1600.0
2011-03-24 05:00:00	QQQ	ETF	55.84	55.98	55.84	55.87	3900.0
2011-03-24 05:30:00	QQQ	ETF	55.83	56.08	55.83	56.04	16300.0
2011-03-24 06:30:00	QQQ	ETF	56.02	56.12	56.02	56.12	1200.0
2011-03-24 07:00:00	QQQ	ETF	56.04	56.07	56.02	56.02	23550.0
2011-03-24 07:30:00	QQQ	ETF	56.02	56.13	56.02	56.08	33167.0
2011-03-24 08:00:00	QQQ	ETF	56.08	56.24	56.07	56.18	1323924.0
2011-03-24 08:30:00	QQQ	ETF	56.18	56.2	56.05	56.1	549290.0
2011-03-24 09:00:00	QQQ	ETF	56.1	56.13	56.07	56.12	142815.0
2011-03-24 09:30:00	QQQ	ETF	56.12	56.13	55.82	55.92	10085488.0
2011-03-24 10:00:00	QQQ	ETF	55.91	56.085	55.85	56.045	3020223.0
2011-03-24 10:30:00	QQQ	ETF	56.05	56.41	56.05	56.409	5173840.0
2011-03-24 11:00:00	QQQ	ETF	56.4	56.54	56.39	56.45	8241084.0
2011-03-24 11:30:00	QQQ	ETF	56.44	56.53	56.44	56.5	2470207.0
2011-03-24 12:00:00	QQQ	ETF	56.491	56.61	56.49	56.59	2756173.0
2011-03-24 12:30:00	QQQ	ETF	56.59	56.59	56.47	56.525	3746004.0
2011-03-24 13:00:00	QQQ	ETF	56.525	56.58	56.49	56.56	975015.0

> showing 50 of 9,295 rows — these rows as CSV

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