PREVIEW / etf_30min / 2012-02-10

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-10.parquet
  size:    293 KB
  rows:    9,981

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
2012-02-10 04:00:00	SPY	ETF	134.77	134.77	134.59	134.59	2200.0
2012-02-10 04:30:00	SPY	ETF	134.66	134.67	134.66	134.67	26358.0
2012-02-10 05:00:00	SPY	ETF	134.59	134.59	134.42	134.45	27900.0
2012-02-10 05:30:00	SPY	ETF	134.41	134.55	134.39	134.47	4225.0
2012-02-10 06:00:00	SPY	ETF	134.49	134.57	134.48	134.55	24670.0
2012-02-10 06:30:00	SPY	ETF	134.48	134.48	134.36	134.4	125720.0
2012-02-10 07:00:00	SPY	ETF	134.42	134.42	133.95	134.16	1406702.0
2012-02-10 07:30:00	SPY	ETF	134.16	134.23	134.05	134.16	583847.0
2012-02-10 08:00:00	SPY	ETF	134.16	134.66	133.98	134.04	2881153.0
2012-02-10 08:30:00	SPY	ETF	134.05	134.16	133.88	134.07	2071740.0
2012-02-10 09:00:00	SPY	ETF	134.08	134.24	134.01	134.17	1637814.0
2012-02-10 09:30:00	SPY	ETF	134.16	134.35	133.98	134.03	22806810.0
2012-02-10 10:00:00	SPY	ETF	134.03	134.15	133.84	134.109	18182493.0
2012-02-10 10:30:00	SPY	ETF	134.1	134.23	133.99	134.2	10779300.0
2012-02-10 11:00:00	SPY	ETF	134.21	134.35	134.17	134.18	10122316.0
2012-02-10 11:30:00	SPY	ETF	134.18	134.42	134.13	134.28	6051422.0
2012-02-10 12:00:00	SPY	ETF	134.28	134.39	134.215	134.25	4274718.0
2012-02-10 12:30:00	SPY	ETF	134.24	134.47	134.23	134.44	5273483.0
2012-02-10 13:00:00	SPY	ETF	134.45	134.46	134.23	134.23	4433946.0
2012-02-10 13:30:00	SPY	ETF	134.23	134.24	133.96	133.99	7139622.0
2012-02-10 14:00:00	SPY	ETF	133.98	134.18	133.97	134.16	6286127.0
2012-02-10 14:30:00	SPY	ETF	134.155	134.22	134.09	134.125	5887867.0
2012-02-10 15:00:00	SPY	ETF	134.12	134.13	133.87	134.1199	11362576.0
2012-02-10 15:30:00	SPY	ETF	134.12	134.4	134.04	134.37	27164602.0
2012-02-10 16:00:00	SPY	ETF	134.38	135.3267	134.15	134.52	14368407.0
2012-02-10 16:30:00	SPY	ETF	134.52	134.78	134.1528	134.75	2894021.0
2012-02-10 17:00:00	SPY	ETF	134.73	134.73	134.64	134.64	194198.0
2012-02-10 17:30:00	SPY	ETF	134.65	134.65	134.47	134.58	249236.0
2012-02-10 18:00:00	SPY	ETF	134.59	134.62	134.53	134.57	27815.0
2012-02-10 18:30:00	SPY	ETF	134.58	134.65	134.55	134.55	19013.0
2012-02-10 19:00:00	SPY	ETF	134.55	134.66	134.55	134.66	36313.0
2012-02-10 19:30:00	SPY	ETF	134.67	134.73	134.66	134.7	70438.0
2012-02-10 04:00:00	QQQ	ETF	62.69	62.69	62.65	62.65	300.0
2012-02-10 04:30:00	QQQ	ETF	62.63	62.64	62.63	62.64	800.0
2012-02-10 05:00:00	QQQ	ETF	62.64	62.7	62.64	62.7	20000.0
2012-02-10 05:30:00	QQQ	ETF	62.65	62.66	62.65	62.65	6000.0
2012-02-10 06:00:00	QQQ	ETF	62.64	62.64	62.62	62.62	8100.0
2012-02-10 06:30:00	QQQ	ETF	62.61	62.61	62.56	62.56	11465.0
2012-02-10 07:00:00	QQQ	ETF	62.58	62.58	62.35	62.44	1034112.0
2012-02-10 07:30:00	QQQ	ETF	62.42	62.44	62.32	62.37	1078424.0
2012-02-10 08:00:00	QQQ	ETF	62.38	62.75	62.34	62.36	2488049.0
2012-02-10 08:30:00	QQQ	ETF	62.37	62.45	62.34	62.42	244114.0
2012-02-10 09:00:00	QQQ	ETF	62.43	62.49	62.4	62.48	243758.0
2012-02-10 09:30:00	QQQ	ETF	62.47	62.56	62.31	62.37	6961775.0
2012-02-10 10:00:00	QQQ	ETF	62.36	62.46	62.25	62.44	5765201.0
2012-02-10 10:30:00	QQQ	ETF	62.44	62.53	62.39	62.51	3104667.0
2012-02-10 11:00:00	QQQ	ETF	62.509	62.5801	62.48	62.49	2922748.0
2012-02-10 11:30:00	QQQ	ETF	62.49	62.6	62.46	62.54	2221227.0
2012-02-10 12:00:00	QQQ	ETF	62.55	62.61	62.51	62.546	3092889.0
2012-02-10 12:30:00	QQQ	ETF	62.54	62.64	62.53	62.62	2654296.0

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

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