PREVIEW / stock_30min / 2011-06-06

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-06.parquet
  size:    1.4 MB
  rows:    76,944
  symbols: 3,562

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-06-06 07:00:00	AAPL	Stock	12.2857	12.3125	12.2857	12.3125	67200.0
2011-06-06 07:30:00	AAPL	Stock	12.3129	12.3286	12.3011	12.3179	152320.0
2011-06-06 08:00:00	AAPL	Stock	12.3125	12.3532	12.2961	12.3482	1428168.0
2011-06-06 08:30:00	AAPL	Stock	12.3464	12.3711	12.3429	12.3429	1310176.0
2011-06-06 09:00:00	AAPL	Stock	12.3532	12.3557	12.3393	12.3464	361648.0
2011-06-06 09:30:00	AAPL	Stock	12.3464	12.3778	12.3096	12.3686	55577508.0
2011-06-06 10:00:00	AAPL	Stock	12.3689	12.3946	12.3157	12.3464	41174560.0
2011-06-06 10:30:00	AAPL	Stock	12.3464	12.3479	12.2679	12.3	27180048.0
2011-06-06 11:00:00	AAPL	Stock	12.2993	12.3375	12.2861	12.3361	14316708.0
2011-06-06 11:30:00	AAPL	Stock	12.3343	12.3532	12.3036	12.3071	13589744.0
2011-06-06 12:00:00	AAPL	Stock	12.3061	12.3196	12.2911	12.2943	10264296.0
2011-06-06 12:30:00	AAPL	Stock	12.2946	12.2971	12.2554	12.2907	16586976.0
2011-06-06 13:00:00	AAPL	Stock	12.2907	12.3171	12.2061	12.2164	42145964.0
2011-06-06 13:30:00	AAPL	Stock	12.2157	12.2371	12.1368	12.1429	51646644.0
2011-06-06 14:00:00	AAPL	Stock	12.1454	12.2139	12.1411	12.193	33764556.0
2011-06-06 14:30:00	AAPL	Stock	12.1904	12.1936	12.0946	12.1161	43521212.0
2011-06-06 15:00:00	AAPL	Stock	12.1161	12.1329	12.0646	12.0947	43503908.0
2011-06-06 15:30:00	AAPL	Stock	12.0961	12.1389	12.0668	12.0734	54553884.0
2011-06-06 16:00:00	AAPL	Stock	12.0732	12.2233	12.0646	12.0717	6652380.0
2011-06-06 16:30:00	AAPL	Stock	12.0679	12.0682	12.0436	12.0514	376320.0
2011-06-06 17:00:00	AAPL	Stock	12.2705	12.2705	12.0082	12.0111	1829352.0
2011-06-06 17:30:00	AAPL	Stock	12.0143	12.0336	12.0104	12.0186	378616.0
2011-06-06 18:00:00	AAPL	Stock	12.0186	12.0729	12.0143	12.0182	301000.0
2011-06-06 18:30:00	AAPL	Stock	12.025	12.0318	12.0182	12.0318	55272.0
2011-06-06 19:00:00	AAPL	Stock	12.0318	12.0336	12.0279	12.03	100716.0
2011-06-06 19:30:00	AAPL	Stock	12.0314	12.0357	12.0314	12.0357	153272.0
2011-06-06 07:30:00	MSFT	Stock	23.89	23.89	23.86	23.86	2151.0
2011-06-06 08:00:00	MSFT	Stock	23.89	23.94	23.87	23.94	98242.0
2011-06-06 08:30:00	MSFT	Stock	23.94	23.94	23.91	23.94	22991.0
2011-06-06 09:00:00	MSFT	Stock	23.93	23.93	23.86	23.88	19445.0
2011-06-06 09:30:00	MSFT	Stock	23.89	23.97	23.77	23.89	6569518.0
2011-06-06 10:00:00	MSFT	Stock	23.9	24.06	23.84	24.03	5085403.0
2011-06-06 10:30:00	MSFT	Stock	24.031	24.06	23.98	24.013	2858785.0
2011-06-06 11:00:00	MSFT	Stock	24.015	24.19	24.01	24.17	4061181.0
2011-06-06 11:30:00	MSFT	Stock	24.175	24.19	24.13	24.16	2379169.0
2011-06-06 12:00:00	MSFT	Stock	24.155	24.16	24.08	24.12	2050783.0
2011-06-06 12:30:00	MSFT	Stock	24.12	24.14	24.08	24.135	1605459.0
2011-06-06 13:00:00	MSFT	Stock	24.14	24.25	24.13	24.195	1858725.0
2011-06-06 13:30:00	MSFT	Stock	24.19	24.2	24.07	24.075	2300277.0
2011-06-06 14:00:00	MSFT	Stock	24.08	24.16	24.07	24.135	1739930.0
2011-06-06 14:30:00	MSFT	Stock	24.13	24.17	24.07	24.17	2906129.0
2011-06-06 15:00:00	MSFT	Stock	24.17	24.18	24.0	24.058	4186303.0
2011-06-06 15:30:00	MSFT	Stock	24.06	24.16	23.99	23.99	6676964.0
2011-06-06 16:00:00	MSFT	Stock	23.99	24.053	23.986	24.007	9680395.0
2011-06-06 16:30:00	MSFT	Stock	24.0	24.108	24.0	24.03	89420.0
2011-06-06 17:00:00	MSFT	Stock	24.103	24.103	24.01	24.01	39200.0
2011-06-06 17:30:00	MSFT	Stock	24.0	24.0	24.0	24.0	6193.0
2011-06-06 18:00:00	MSFT	Stock	24.01	24.01	24.0	24.0	17976.0
2011-06-06 18:30:00	MSFT	Stock	23.99	23.99	23.98	23.98	12764.0
2011-06-06 19:00:00	MSFT	Stock	23.96	23.96	23.95	23.96	1600.0

> showing 50 of 76,944 rows — these rows as CSV

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