PREVIEW / etf_30min / 2011-10-19

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-19.parquet
  size:    278 KB
  rows:    9,248

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-10-19 04:00:00	SPY	ETF	122.02	122.34	121.92	122.22	34860.0
2011-10-19 04:30:00	SPY	ETF	122.18	122.41	122.18	122.41	1550.0
2011-10-19 05:00:00	SPY	ETF	122.62	122.95	122.62	122.81	10400.0
2011-10-19 05:30:00	SPY	ETF	122.89	123.11	122.89	123.11	31400.0
2011-10-19 06:00:00	SPY	ETF	123.1	123.16	122.8	122.8	85860.0
2011-10-19 06:30:00	SPY	ETF	122.83	123.28	122.83	123.2	59425.0
2011-10-19 07:00:00	SPY	ETF	123.15	123.19	122.89	122.93	159523.0
2011-10-19 07:30:00	SPY	ETF	122.93	122.93	122.46	122.5	294498.0
2011-10-19 08:00:00	SPY	ETF	122.47	122.63	122.16	122.41	649849.0
2011-10-19 08:30:00	SPY	ETF	122.49	122.91	122.49	122.84	1637918.0
2011-10-19 09:00:00	SPY	ETF	122.83	122.83	122.33	122.38	1468915.0
2011-10-19 09:30:00	SPY	ETF	122.38	122.77	122.11	122.46	20460584.0
2011-10-19 10:00:00	SPY	ETF	122.46	123.08	122.08	123.04	21006806.0
2011-10-19 10:30:00	SPY	ETF	123.04	123.08	122.71	122.82	14475345.0
2011-10-19 11:00:00	SPY	ETF	122.814	122.87	122.47	122.8	12806840.0
2011-10-19 11:30:00	SPY	ETF	122.79	123.02	122.44	122.46	7766261.0
2011-10-19 12:00:00	SPY	ETF	122.45	122.75	122.31	122.609	9858801.0
2011-10-19 12:30:00	SPY	ETF	122.62	122.83	122.42	122.62	6203868.0
2011-10-19 13:00:00	SPY	ETF	122.61	122.84	122.5	122.51	8058540.0
2011-10-19 13:30:00	SPY	ETF	122.51	122.54	122.07	122.29	12104312.0
2011-10-19 14:00:00	SPY	ETF	122.29	122.4	121.24	121.26	24210123.0
2011-10-19 14:30:00	SPY	ETF	121.26	121.74	121.1	121.19	24435741.0
2011-10-19 15:00:00	SPY	ETF	121.18	121.36	120.85	120.98	23229794.0
2011-10-19 15:30:00	SPY	ETF	120.97	121.43	120.71	121.12	28503129.0
2011-10-19 16:00:00	SPY	ETF	121.11	122.1793	120.75	121.23	6773894.0
2011-10-19 16:30:00	SPY	ETF	121.23	121.9944	121.2	121.31	401375.0
2011-10-19 17:00:00	SPY	ETF	121.32	121.41	121.099	121.33	1019992.0
2011-10-19 17:30:00	SPY	ETF	121.38	121.43	121.32	121.43	61003.0
2011-10-19 18:00:00	SPY	ETF	121.45	121.52	121.14	121.48	129538.0
2011-10-19 18:30:00	SPY	ETF	121.47	121.52	121.39	121.39	21058.0
2011-10-19 19:00:00	SPY	ETF	121.34	121.5	121.34	121.5	16032.0
2011-10-19 19:30:00	SPY	ETF	121.45	121.57	121.44	121.48	28607.0
2011-10-19 06:00:00	QQQ	ETF	57.82	57.82	57.82	57.82	400.0
2011-10-19 06:30:00	QQQ	ETF	57.81	57.94	57.81	57.94	20300.0
2011-10-19 07:00:00	QQQ	ETF	57.84	57.89	57.76	57.8	80000.0
2011-10-19 07:30:00	QQQ	ETF	57.8	57.8	57.6	57.61	110900.0
2011-10-19 08:00:00	QQQ	ETF	57.62	57.69	57.56	57.6	159447.0
2011-10-19 08:30:00	QQQ	ETF	57.63	58.0125	57.63	57.8	728642.0
2011-10-19 09:00:00	QQQ	ETF	57.8	57.8	57.58	57.71	860707.0
2011-10-19 09:30:00	QQQ	ETF	57.72	57.82	57.51	57.58	6794103.0
2011-10-19 10:00:00	QQQ	ETF	57.57	57.77	57.35	57.74	6426683.0
2011-10-19 10:30:00	QQQ	ETF	57.74	57.85	57.62	57.76	5839214.0
2011-10-19 11:00:00	QQQ	ETF	57.7693	57.81	57.65	57.75	4269026.0
2011-10-19 11:30:00	QQQ	ETF	57.75	57.835	57.55	57.56	3269356.0
2011-10-19 12:00:00	QQQ	ETF	57.56	57.72	57.54	57.67	2075535.0
2011-10-19 12:30:00	QQQ	ETF	57.678	57.79	57.59	57.68	1621819.0
2011-10-19 13:00:00	QQQ	ETF	57.6822	57.75	57.5675	57.57	1927995.0
2011-10-19 13:30:00	QQQ	ETF	57.57	57.6	57.3402	57.45	3220224.0
2011-10-19 14:00:00	QQQ	ETF	57.4401	57.47	56.89	56.9	4836559.0
2011-10-19 14:30:00	QQQ	ETF	56.9	57.19	56.81	56.9297	5228425.0

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

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