PREVIEW / etf_30min / 2011-11-07

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-07.parquet
  size:    282 KB
  rows:    9,332

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-11-07 04:00:00	SPY	ETF	124.42	124.42	123.88	124.2	8147.0
2011-11-07 04:30:00	SPY	ETF	124.1	124.3	124.05	124.1	117016.0
2011-11-07 05:00:00	SPY	ETF	124.03	124.09	123.8	124.05	25182.0
2011-11-07 05:30:00	SPY	ETF	124.15	124.5	124.08	124.5	9700.0
2011-11-07 06:00:00	SPY	ETF	124.48	125.37	124.48	124.97	50699.0
2011-11-07 06:30:00	SPY	ETF	124.92	125.27	124.49	124.49	122937.0
2011-11-07 07:00:00	SPY	ETF	124.52	125.08	124.5	124.97	256899.0
2011-11-07 07:30:00	SPY	ETF	124.96	125.36	124.95	125.22	235182.0
2011-11-07 08:00:00	SPY	ETF	125.26	125.31	124.84	124.86	1187788.0
2011-11-07 08:30:00	SPY	ETF	124.87	125.2	124.22	125.17	623810.0
2011-11-07 09:00:00	SPY	ETF	125.17	125.49	125.05	125.38	1545075.0
2011-11-07 09:30:00	SPY	ETF	125.39	126.16	125.29	125.9	26145679.0
2011-11-07 10:00:00	SPY	ETF	125.9	125.975	125.27	125.3	15815219.0
2011-11-07 10:30:00	SPY	ETF	125.29	125.34	124.71	124.82	17820096.0
2011-11-07 11:00:00	SPY	ETF	124.82	125.24	124.62	124.77	13385692.0
2011-11-07 11:30:00	SPY	ETF	124.76	125.02	124.65	124.72	11608985.0
2011-11-07 12:00:00	SPY	ETF	124.72	125.05	124.3	124.38	16649625.0
2011-11-07 12:30:00	SPY	ETF	124.37	124.6	124.2	124.56	7105841.0
2011-11-07 13:00:00	SPY	ETF	124.56	124.88	124.46	124.85	7272264.0
2011-11-07 13:30:00	SPY	ETF	124.86	125.37	124.7	125.26	9013869.0
2011-11-07 14:00:00	SPY	ETF	125.27	125.7	125.15	125.58	16753357.0
2011-11-07 14:30:00	SPY	ETF	125.57	125.96	125.46	125.94	12994700.0
2011-11-07 15:00:00	SPY	ETF	125.95	126.15	125.72	125.73	9962995.0
2011-11-07 15:30:00	SPY	ETF	125.72	126.39	125.69	126.27	20397984.0
2011-11-07 16:00:00	SPY	ETF	126.28	126.38	124.8	126.26	3830891.0
2011-11-07 16:30:00	SPY	ETF	126.28	126.48	126.22	126.48	1434198.0
2011-11-07 17:00:00	SPY	ETF	126.49	127.05	126.41	126.77	505969.0
2011-11-07 17:30:00	SPY	ETF	126.77	126.77	126.69	126.72	52047.0
2011-11-07 18:00:00	SPY	ETF	126.67	126.74	126.28	126.46	209905.0
2011-11-07 18:30:00	SPY	ETF	126.45	126.49	126.35	126.39	62707.0
2011-11-07 19:00:00	SPY	ETF	126.39	126.44	126.33	126.39	51138.0
2011-11-07 19:30:00	SPY	ETF	126.4	126.4	126.22	126.28	117334.0
2011-11-07 04:00:00	QQQ	ETF	57.25	57.25	57.15	57.22	5110.0
2011-11-07 05:00:00	QQQ	ETF	57.12	57.17	57.11	57.17	10900.0
2011-11-07 05:30:00	QQQ	ETF	57.2	57.36	57.2	57.36	3700.0
2011-11-07 06:00:00	QQQ	ETF	57.41	57.58	57.41	57.58	5556.0
2011-11-07 06:30:00	QQQ	ETF	57.56	57.64	57.56	57.64	9418.0
2011-11-07 07:00:00	QQQ	ETF	57.5	57.62	57.44	57.58	23800.0
2011-11-07 07:30:00	QQQ	ETF	57.61	57.75	57.6	57.71	53323.0
2011-11-07 08:00:00	QQQ	ETF	57.71	57.71	57.5	57.57	106978.0
2011-11-07 08:30:00	QQQ	ETF	57.55	57.67	57.55	57.67	116646.0
2011-11-07 09:00:00	QQQ	ETF	57.67	57.81	57.63	57.75	244630.0
2011-11-07 09:30:00	QQQ	ETF	57.75	58.07	57.67	57.98	5559103.0
2011-11-07 10:00:00	QQQ	ETF	57.9829	58.02	57.585	57.62	3262503.0
2011-11-07 10:30:00	QQQ	ETF	57.61	57.64	57.3	57.3299	5256754.0
2011-11-07 11:00:00	QQQ	ETF	57.33	57.555	57.28	57.37	2897670.0
2011-11-07 11:30:00	QQQ	ETF	57.37	57.52	57.33	57.42	1645864.0
2011-11-07 12:00:00	QQQ	ETF	57.425	57.56	57.21	57.255	4394959.0
2011-11-07 12:30:00	QQQ	ETF	57.25	57.36	57.17	57.33	1571294.0
2011-11-07 13:00:00	QQQ	ETF	57.33	57.5	57.31	57.5	1102048.0

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

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