PREVIEW / etf_30min / 2011-03-08

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-08.parquet
  size:    275 KB
  rows:    9,200

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-08 04:00:00	SPY	ETF	132.01	132.25	132.01	132.25	9644.0
2011-03-08 04:30:00	SPY	ETF	132.12	132.12	131.95	131.95	300.0
2011-03-08 05:00:00	SPY	ETF	131.89	131.95	131.84	131.85	18800.0
2011-03-08 05:30:00	SPY	ETF	131.85	132.01	131.7	131.9	3400.0
2011-03-08 06:00:00	SPY	ETF	131.92	132.01	131.89	131.92	20675.0
2011-03-08 06:30:00	SPY	ETF	131.98	131.98	131.74	131.82	7050.0
2011-03-08 07:00:00	SPY	ETF	131.81	131.86	131.62	131.75	105084.0
2011-03-08 07:30:00	SPY	ETF	131.71	131.83	131.45	131.58	342383.0
2011-03-08 08:00:00	SPY	ETF	131.58	131.82	131.27	131.32	1539048.0
2011-03-08 08:30:00	SPY	ETF	131.32	131.7	131.28	131.45	989224.0
2011-03-08 09:00:00	SPY	ETF	131.44	131.7	131.44	131.65	1203017.0
2011-03-08 09:30:00	SPY	ETF	131.64	131.75	131.07	131.585	22086035.0
2011-03-08 10:00:00	SPY	ETF	131.59	132.33	131.585	132.22	22427770.0
2011-03-08 10:30:00	SPY	ETF	132.23	132.34	131.95	132.23	12015615.0
2011-03-08 11:00:00	SPY	ETF	132.23	132.6	132.0	132.6	11140771.0
2011-03-08 11:30:00	SPY	ETF	132.59	132.93	132.54	132.92	11316166.0
2011-03-08 12:00:00	SPY	ETF	132.93	133.0	132.76	132.8	8047344.0
2011-03-08 12:30:00	SPY	ETF	132.81	132.85	132.62	132.67	6226781.0
2011-03-08 13:00:00	SPY	ETF	132.67	132.76	132.65	132.74	5376038.0
2011-03-08 13:30:00	SPY	ETF	132.73	132.84	132.69	132.76	3357664.0
2011-03-08 14:00:00	SPY	ETF	132.75	132.79	132.39	132.55	8034952.0
2011-03-08 14:30:00	SPY	ETF	132.55	132.82	132.37	132.78	6216311.0
2011-03-08 15:00:00	SPY	ETF	132.78	132.9	132.595	132.78	8354553.0
2011-03-08 15:30:00	SPY	ETF	132.7783	132.88	132.55	132.57	14888275.0
2011-03-08 16:00:00	SPY	ETF	132.57	132.83	132.33	132.46	9657965.0
2011-03-08 16:30:00	SPY	ETF	132.45	132.7	131.4082	132.48	8671636.0
2011-03-08 17:00:00	SPY	ETF	132.47	132.52	132.41	132.45	5154974.0
2011-03-08 17:30:00	SPY	ETF	132.42	132.48	132.38	132.45	40318.0
2011-03-08 18:00:00	SPY	ETF	132.45	132.58	132.38	132.49	192548.0
2011-03-08 18:30:00	SPY	ETF	132.47	132.56	132.41	132.54	57943.0
2011-03-08 19:00:00	SPY	ETF	132.48	132.5	132.45	132.45	16398.0
2011-03-08 19:30:00	SPY	ETF	132.45	132.54	132.43	132.49	13249.0
2011-03-08 05:00:00	QQQ	ETF	57.24	57.24	57.22	57.24	1500.0
2011-03-08 05:30:00	QQQ	ETF	57.16	57.26	57.16	57.26	11100.0
2011-03-08 06:00:00	QQQ	ETF	57.25	57.25	57.25	57.25	100.0
2011-03-08 06:30:00	QQQ	ETF	57.29	57.29	57.23	57.23	2700.0
2011-03-08 07:00:00	QQQ	ETF	57.22	57.22	57.12	57.19	61753.0
2011-03-08 07:30:00	QQQ	ETF	57.18	57.2	57.05	57.12	108545.0
2011-03-08 08:00:00	QQQ	ETF	57.12	57.13	56.93	56.99	374850.0
2011-03-08 08:30:00	QQQ	ETF	56.98	57.13	56.97	57.03	426558.0
2011-03-08 09:00:00	QQQ	ETF	57.02	57.12	57.02	57.11	133459.0
2011-03-08 09:30:00	QQQ	ETF	57.1	57.17	56.77	57.08	10873932.0
2011-03-08 10:00:00	QQQ	ETF	57.08	57.46	57.08	57.38	7734807.0
2011-03-08 10:30:00	QQQ	ETF	57.38	57.48	57.26	57.4	5504406.0
2011-03-08 11:00:00	QQQ	ETF	57.3901	57.53	57.3	57.52	5699008.0
2011-03-08 11:30:00	QQQ	ETF	57.53	57.66	57.5	57.64	3478948.0
2011-03-08 12:00:00	QQQ	ETF	57.645	57.68	57.61	57.64	2239607.0
2011-03-08 12:30:00	QQQ	ETF	57.63	57.665	57.59	57.61	1899215.0
2011-03-08 13:00:00	QQQ	ETF	57.61	57.66	57.58	57.62	1426137.0
2011-03-08 13:30:00	QQQ	ETF	57.62	57.66	57.58	57.601	1430047.0

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

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