PREVIEW / etf_30min / 2013-04-24

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-24.parquet
  size:    305 KB
  rows:    10,362

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-24 04:00:00	SPY	ETF	158.26	158.32	158.16	158.16	23270.0
2013-04-24 04:30:00	SPY	ETF	158.16	158.29	158.14	158.14	1500.0
2013-04-24 05:00:00	SPY	ETF	158.13	158.23	158.1	158.14	7900.0
2013-04-24 05:30:00	SPY	ETF	158.23	158.26	158.18	158.26	4400.0
2013-04-24 06:00:00	SPY	ETF	158.26	158.29	158.12	158.12	8700.0
2013-04-24 06:30:00	SPY	ETF	158.12	158.18	157.98	158.02	43499.0
2013-04-24 07:00:00	SPY	ETF	158.04	158.14	158.03	158.07	46118.0
2013-04-24 07:30:00	SPY	ETF	158.1	158.18	158.0	158.0	214048.0
2013-04-24 08:00:00	SPY	ETF	158.0	158.11	157.88	157.97	436718.0
2013-04-24 08:30:00	SPY	ETF	157.92	157.93	157.68	157.73	1848409.0
2013-04-24 09:00:00	SPY	ETF	157.73	157.94	157.71	157.82	900664.0
2013-04-24 09:30:00	SPY	ETF	157.83	158.15	157.75	157.961	13498134.0
2013-04-24 10:00:00	SPY	ETF	157.97	158.13	157.54	157.77	11451697.0
2013-04-24 10:30:00	SPY	ETF	157.77	158.1	157.76	157.99	7399832.0
2013-04-24 11:00:00	SPY	ETF	157.991	158.08	157.691	157.94	4961959.0
2013-04-24 11:30:00	SPY	ETF	157.95	158.04	157.82	157.939	3030332.0
2013-04-24 12:00:00	SPY	ETF	157.94	158.02	157.82	157.87	2909186.0
2013-04-24 12:30:00	SPY	ETF	157.87	157.96	157.66	157.8	3353662.0
2013-04-24 13:00:00	SPY	ETF	157.8	158.02	157.78	157.962	2762239.0
2013-04-24 13:30:00	SPY	ETF	157.97	158.07	157.92	157.971	3161155.0
2013-04-24 14:00:00	SPY	ETF	157.97	158.17	157.96	158.155	5439917.0
2013-04-24 14:30:00	SPY	ETF	158.16	158.3	158.1	158.29	5856150.0
2013-04-24 15:00:00	SPY	ETF	158.29	158.29	158.02	158.03	5252634.0
2013-04-24 15:30:00	SPY	ETF	158.03	158.09	157.75	157.88	12772929.0
2013-04-24 16:00:00	SPY	ETF	157.87	158.21	157.78	157.81	7289325.0
2013-04-24 16:30:00	SPY	ETF	157.8	157.89	157.77	157.87	1643786.0
2013-04-24 17:00:00	SPY	ETF	157.85	157.88	157.75	157.76	93222.0
2013-04-24 17:30:00	SPY	ETF	157.76	157.83	157.75	157.78	77525.0
2013-04-24 18:00:00	SPY	ETF	157.75	157.77	157.69	157.75	153795.0
2013-04-24 18:30:00	SPY	ETF	157.74	157.75	157.71	157.75	11600.0
2013-04-24 19:00:00	SPY	ETF	157.75	157.77	157.74	157.76	17600.0
2013-04-24 19:30:00	SPY	ETF	157.75	157.77	157.72	157.76	18020.0
2013-04-24 04:30:00	QQQ	ETF	69.49	69.51	69.49	69.51	300.0
2013-04-24 05:30:00	QQQ	ETF	69.55	69.55	69.55	69.55	1000.0
2013-04-24 06:00:00	QQQ	ETF	69.5	69.54	69.5	69.54	1390.0
2013-04-24 06:30:00	QQQ	ETF	69.49	69.49	69.41	69.41	37500.0
2013-04-24 07:00:00	QQQ	ETF	69.44	69.48	69.44	69.48	11910.0
2013-04-24 07:30:00	QQQ	ETF	69.48	69.48	69.33	69.35	72900.0
2013-04-24 08:00:00	QQQ	ETF	69.33	69.49	69.22	69.3	365184.0
2013-04-24 08:30:00	QQQ	ETF	69.28	69.4384	69.18	69.21	2171901.0
2013-04-24 09:00:00	QQQ	ETF	69.21	69.3	69.2	69.27	375849.0
2013-04-24 09:30:00	QQQ	ETF	69.26	69.67	69.19	69.46	5775101.0
2013-04-24 10:00:00	QQQ	ETF	69.46	69.54	69.12	69.27	4503493.0
2013-04-24 10:30:00	QQQ	ETF	69.27	69.42	69.25	69.32	2503237.0
2013-04-24 11:00:00	QQQ	ETF	69.33	69.385	69.17	69.33	1602022.0
2013-04-24 11:30:00	QQQ	ETF	69.34	69.38	69.24	69.311	1039463.0
2013-04-24 12:00:00	QQQ	ETF	69.32	69.38	69.27	69.305	492424.0
2013-04-24 12:30:00	QQQ	ETF	69.3073	69.36	69.19	69.25	1081932.0
2013-04-24 13:00:00	QQQ	ETF	69.242	69.47	69.24	69.44	638126.0
2013-04-24 13:30:00	QQQ	ETF	69.43	69.51	69.41	69.43	778808.0

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

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