PREVIEW / stock_30min / 2013-11-22

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-22.parquet
  size:    1.5 MB
  rows:    80,785
  symbols: 3,569

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
2013-11-22 04:00:00	AAPL	Stock	18.67	18.6786	18.6689	18.6689	11200.0
2013-11-22 04:30:00	AAPL	Stock	18.66	18.66	18.6539	18.6539	7000.0
2013-11-22 05:00:00	AAPL	Stock	18.6479	18.6479	18.6479	18.6479	2800.0
2013-11-22 06:30:00	AAPL	Stock	18.6286	18.6286	18.6286	18.6286	2800.0
2013-11-22 07:00:00	AAPL	Stock	18.6207	18.6279	18.6143	18.6275	46396.0
2013-11-22 07:30:00	AAPL	Stock	18.6221	18.6289	18.6214	18.6214	74200.0
2013-11-22 08:00:00	AAPL	Stock	18.6214	18.6357	18.5929	18.6107	484708.0
2013-11-22 08:30:00	AAPL	Stock	18.6157	18.6214	18.6	18.6061	417060.0
2013-11-22 09:00:00	AAPL	Stock	18.6018	18.6068	18.5714	18.5714	532112.0
2013-11-22 09:30:00	AAPL	Stock	18.5575	18.6282	18.5189	18.6007	39121572.0
2013-11-22 10:00:00	AAPL	Stock	18.6036	18.6486	18.5968	18.6239	32123056.0
2013-11-22 10:30:00	AAPL	Stock	18.6225	18.6404	18.5782	18.5861	16541672.0
2013-11-22 11:00:00	AAPL	Stock	18.5864	18.6054	18.5682	18.5682	14880880.0
2013-11-22 11:30:00	AAPL	Stock	18.5682	18.5957	18.5637	18.5804	11164692.0
2013-11-22 12:00:00	AAPL	Stock	18.5804	18.5818	18.5632	18.5729	6987568.0
2013-11-22 12:30:00	AAPL	Stock	18.5729	18.5871	18.565	18.5744	5752488.0
2013-11-22 13:00:00	AAPL	Stock	18.5743	18.5768	18.5589	18.5646	6263432.0
2013-11-22 13:30:00	AAPL	Stock	18.5677	18.5721	18.5425	18.5454	6104420.0
2013-11-22 14:00:00	AAPL	Stock	18.5475	18.5661	18.5429	18.5639	7747292.0
2013-11-22 14:30:00	AAPL	Stock	18.565	18.5714	18.5621	18.5668	7706300.0
2013-11-22 15:00:00	AAPL	Stock	18.5668	18.5693	18.5557	18.5614	9077460.0
2013-11-22 15:30:00	AAPL	Stock	18.5614	18.5668	18.5468	18.5604	21950068.0
2013-11-22 16:00:00	AAPL	Stock	18.5643	18.582	18.5504	18.5586	13324108.0
2013-11-22 16:30:00	AAPL	Stock	18.5618	18.5643	18.557	18.5625	457380.0
2013-11-22 17:00:00	AAPL	Stock	18.6107	18.6107	18.5596	18.5636	18876844.0
2013-11-22 17:30:00	AAPL	Stock	18.5582	18.5643	18.5564	18.5632	142072.0
2013-11-22 18:00:00	AAPL	Stock	18.5625	18.5636	18.5607	18.5636	67200.0
2013-11-22 18:30:00	AAPL	Stock	18.5625	18.5636	18.5625	18.5636	17640.0
2013-11-22 19:00:00	AAPL	Stock	18.5589	18.5589	18.5589	18.5589	11788.0
2013-11-22 19:30:00	AAPL	Stock	18.5593	18.5643	18.5593	18.5643	152432.0
2013-11-22 05:30:00	MSFT	Stock	37.42	37.42	37.42	37.42	978.0
2013-11-22 06:00:00	MSFT	Stock	37.46	37.46	37.4	37.45	4942.0
2013-11-22 07:30:00	MSFT	Stock	37.47	37.47	37.46	37.46	600.0
2013-11-22 08:00:00	MSFT	Stock	37.46	37.49	37.43	37.45	7643.0
2013-11-22 08:30:00	MSFT	Stock	37.48	37.49	37.48	37.49	4116.0
2013-11-22 09:00:00	MSFT	Stock	37.49	37.51	37.47	37.47	16505.0
2013-11-22 09:30:00	MSFT	Stock	37.525	37.54	37.33	37.478	2366287.0
2013-11-22 10:00:00	MSFT	Stock	37.48	37.54	37.4	37.51	2483258.0
2013-11-22 10:30:00	MSFT	Stock	37.51	37.52	37.41	37.42	1615449.0
2013-11-22 11:00:00	MSFT	Stock	37.42	37.49	37.42	37.49	928298.0
2013-11-22 11:30:00	MSFT	Stock	37.49	37.64	37.46	37.62	1418485.0
2013-11-22 12:00:00	MSFT	Stock	37.625	37.68	37.59	37.65	1178931.0
2013-11-22 12:30:00	MSFT	Stock	37.646	37.66	37.57	37.62	596330.0
2013-11-22 13:00:00	MSFT	Stock	37.62	37.62	37.469	37.48	2632440.0
2013-11-22 13:30:00	MSFT	Stock	37.48	37.61	37.475	37.52	2169596.0
2013-11-22 14:00:00	MSFT	Stock	37.53	37.67	37.52	37.64	1466192.0
2013-11-22 14:30:00	MSFT	Stock	37.64	37.65	37.51	37.545	1129656.0
2013-11-22 15:00:00	MSFT	Stock	37.534	37.62	37.52	37.54	1276282.0
2013-11-22 15:30:00	MSFT	Stock	37.54	37.58	37.51	37.56	3735403.0
2013-11-22 16:00:00	MSFT	Stock	37.57	37.584	37.408	37.54	3722882.0

> showing 50 of 80,785 rows — these rows as CSV

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