PREVIEW / stock_30min / 2014-05-21

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-21.parquet
  size:    1.5 MB
  rows:    81,331
  symbols: 3,534

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
2014-05-21 04:00:00	AAPL	Stock	21.5893	21.5893	21.5889	21.5889	11200.0
2014-05-21 05:00:00	AAPL	Stock	21.6	21.6	21.6	21.6	2800.0
2014-05-21 05:30:00	AAPL	Stock	21.6286	21.6286	21.6286	21.6286	2800.0
2014-05-21 07:00:00	AAPL	Stock	21.5821	21.6071	21.575	21.5982	121576.0
2014-05-21 07:30:00	AAPL	Stock	21.6071	21.6179	21.6071	21.6107	46900.0
2014-05-21 08:00:00	AAPL	Stock	21.5986	21.6186	21.5468	21.5632	515424.0
2014-05-21 08:30:00	AAPL	Stock	21.5714	21.5975	21.5614	21.5893	171192.0
2014-05-21 09:00:00	AAPL	Stock	21.5846	21.5846	21.5607	21.5711	275940.0
2014-05-21 09:30:00	AAPL	Stock	21.5654	21.6286	21.5379	21.5996	32293352.0
2014-05-21 10:00:00	AAPL	Stock	21.5971	21.5989	21.5021	21.5407	21570472.0
2014-05-21 10:30:00	AAPL	Stock	21.5429	21.6096	21.5246	21.58	12549544.0
2014-05-21 11:00:00	AAPL	Stock	21.574	21.5867	21.5361	21.5425	12306364.0
2014-05-21 11:30:00	AAPL	Stock	21.5432	21.5714	21.5339	21.5636	7308364.0
2014-05-21 12:00:00	AAPL	Stock	21.5643	21.5761	21.5475	21.5729	4325692.0
2014-05-21 12:30:00	AAPL	Stock	21.5732	21.6161	21.5682	21.5975	6309212.0
2014-05-21 13:00:00	AAPL	Stock	21.6011	21.6179	21.5821	21.6064	5817140.0
2014-05-21 13:30:00	AAPL	Stock	21.6032	21.6179	21.5975	21.6039	4349268.0
2014-05-21 14:00:00	AAPL	Stock	21.6061	21.6543	21.5943	21.65	12364128.0
2014-05-21 14:30:00	AAPL	Stock	21.65	21.6671	21.625	21.6321	11157916.0
2014-05-21 15:00:00	AAPL	Stock	21.6328	21.6621	21.6154	21.6464	8737456.0
2014-05-21 15:30:00	AAPL	Stock	21.6464	21.6679	21.6368	21.6529	14980672.0
2014-05-21 16:00:00	AAPL	Stock	21.6539	21.6643	21.5911	21.6539	5889128.0
2014-05-21 16:30:00	AAPL	Stock	21.6539	21.6625	21.5965	21.6571	52024.0
2014-05-21 17:00:00	AAPL	Stock	21.6536	21.6536	21.6468	21.6468	50260.0
2014-05-21 17:30:00	AAPL	Stock	21.6532	21.6532	21.6504	21.6504	9380.0
2014-05-21 18:00:00	AAPL	Stock	21.65	21.6539	21.65	21.6539	47040.0
2014-05-21 18:30:00	AAPL	Stock	21.65	21.6536	21.65	21.6518	30800.0
2014-05-21 19:00:00	AAPL	Stock	21.6536	21.6536	21.6507	21.6507	7000.0
2014-05-21 19:30:00	AAPL	Stock	21.6518	21.6518	21.6486	21.6486	87724.0
2014-05-21 07:00:00	MSFT	Stock	39.78	39.78	39.78	39.78	100.0
2014-05-21 07:30:00	MSFT	Stock	39.76	39.76	39.76	39.76	200.0
2014-05-21 08:00:00	MSFT	Stock	39.75	39.76	39.75	39.76	600.0
2014-05-21 08:30:00	MSFT	Stock	39.72	39.75	39.71	39.75	1221.0
2014-05-21 09:00:00	MSFT	Stock	39.76	39.84	39.76	39.82	11169.0
2014-05-21 09:30:00	MSFT	Stock	39.8	40.24	39.74	40.105	3069501.0
2014-05-21 10:00:00	MSFT	Stock	40.105	40.14	40.04	40.1	1503056.0
2014-05-21 10:30:00	MSFT	Stock	40.11	40.18	40.08	40.14	1068606.0
2014-05-21 11:00:00	MSFT	Stock	40.14	40.145	40.05	40.055	1154253.0
2014-05-21 11:30:00	MSFT	Stock	40.05	40.13	39.97	40.112	1183283.0
2014-05-21 12:00:00	MSFT	Stock	40.12	40.165	40.09	40.146	728037.0
2014-05-21 12:30:00	MSFT	Stock	40.14	40.18	40.12	40.16	537995.0
2014-05-21 13:00:00	MSFT	Stock	40.16	40.195	40.14	40.14	594593.0
2014-05-21 13:30:00	MSFT	Stock	40.141	40.2	40.14	40.17	1050018.0
2014-05-21 14:00:00	MSFT	Stock	40.165	40.25	40.12	40.2	1725773.0
2014-05-21 14:30:00	MSFT	Stock	40.2	40.28	40.18	40.24	866607.0
2014-05-21 15:00:00	MSFT	Stock	40.25	40.32	40.23	40.29	1535023.0
2014-05-21 15:30:00	MSFT	Stock	40.28	40.35	40.26	40.35	4234552.0
2014-05-21 16:00:00	MSFT	Stock	40.35	40.358	40.181	40.35	2307988.0
2014-05-21 16:30:00	MSFT	Stock	40.32	40.35	40.099	40.3	21674.0
2014-05-21 17:00:00	MSFT	Stock	40.35	40.35	40.31	40.31	13695.0

> showing 50 of 81,331 rows — these rows as CSV

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