PREVIEW / stock_30min / 2013-06-18

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-18.parquet
  size:    1.5 MB
  rows:    79,795
  symbols: 3,515

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-06-18 06:00:00	AAPL	Stock	15.4746	15.4746	15.4746	15.4746	2800.0
2013-06-18 07:00:00	AAPL	Stock	15.4768	15.4768	15.4768	15.4768	14700.0
2013-06-18 07:30:00	AAPL	Stock	15.4643	15.4643	15.4318	15.4468	25312.0
2013-06-18 08:00:00	AAPL	Stock	15.4671	15.4671	15.4107	15.4446	176148.0
2013-06-18 08:30:00	AAPL	Stock	15.4411	15.4425	15.4214	15.4214	537600.0
2013-06-18 09:00:00	AAPL	Stock	15.4279	15.4436	15.4043	15.4043	235816.0
2013-06-18 09:30:00	AAPL	Stock	15.4039	15.4761	15.3646	15.4511	35337204.0
2013-06-18 10:00:00	AAPL	Stock	15.4489	15.5124	15.4293	15.5054	19431076.0
2013-06-18 10:30:00	AAPL	Stock	15.5079	15.5321	15.4893	15.4946	17850308.0
2013-06-18 11:00:00	AAPL	Stock	15.4946	15.5132	15.4804	15.5089	13283816.0
2013-06-18 11:30:00	AAPL	Stock	15.5089	15.5229	15.4443	15.4621	12756072.0
2013-06-18 12:00:00	AAPL	Stock	15.4618	15.47	15.4143	15.4361	13661648.0
2013-06-18 12:30:00	AAPL	Stock	15.4389	15.4529	15.4207	15.4241	8037932.0
2013-06-18 13:00:00	AAPL	Stock	15.4264	15.4289	15.4039	15.4071	8013348.0
2013-06-18 13:30:00	AAPL	Stock	15.4086	15.4268	15.3893	15.4204	8283324.0
2013-06-18 14:00:00	AAPL	Stock	15.4218	15.4429	15.4054	15.4236	10392172.0
2013-06-18 14:30:00	AAPL	Stock	15.4274	15.4357	15.4129	15.4268	6334048.0
2013-06-18 15:00:00	AAPL	Stock	15.4268	15.4343	15.4007	15.4286	8365896.0
2013-06-18 15:30:00	AAPL	Stock	15.4286	15.4286	15.4004	15.4195	18721976.0
2013-06-18 16:00:00	AAPL	Stock	15.4195	15.4464	15.3989	15.4204	9362388.0
2013-06-18 16:30:00	AAPL	Stock	15.4014	15.4234	15.3971	15.4018	199612.0
2013-06-18 17:00:00	AAPL	Stock	15.4	15.4204	15.3875	15.3875	1766296.0
2013-06-18 17:30:00	AAPL	Stock	15.3946	15.3989	15.3936	15.3946	35420.0
2013-06-18 18:00:00	AAPL	Stock	15.3964	15.3964	15.3929	15.3929	10584.0
2013-06-18 18:30:00	AAPL	Stock	15.3929	15.3979	15.3911	15.3911	27440.0
2013-06-18 19:00:00	AAPL	Stock	15.3911	15.3911	15.3911	15.3911	2800.0
2013-06-18 19:30:00	AAPL	Stock	15.3961	15.4018	15.3961	15.4018	105896.0
2013-06-18 08:00:00	MSFT	Stock	35.0	35.0	35.0	35.0	300.0
2013-06-18 08:30:00	MSFT	Stock	35.06	35.06	34.99	35.0	28098.0
2013-06-18 09:00:00	MSFT	Stock	34.97	34.97	34.97	34.97	5299.0
2013-06-18 09:30:00	MSFT	Stock	34.97	35.102	34.895	34.955	3813511.0
2013-06-18 10:00:00	MSFT	Stock	34.955	35.07	34.95	35.05	2196871.0
2013-06-18 10:30:00	MSFT	Stock	35.043	35.17	35.04	35.09	2396478.0
2013-06-18 11:00:00	MSFT	Stock	35.09	35.1	35.015	35.07	1904082.0
2013-06-18 11:30:00	MSFT	Stock	35.07	35.11	35.03	35.07	1460199.0
2013-06-18 12:00:00	MSFT	Stock	35.07	35.08	35.02	35.045	981683.0
2013-06-18 12:30:00	MSFT	Stock	35.04	35.08	35.04	35.075	1206243.0
2013-06-18 13:00:00	MSFT	Stock	35.078	35.1	35.05	35.085	1200785.0
2013-06-18 13:30:00	MSFT	Stock	35.09	35.09	35.04	35.04	990117.0
2013-06-18 14:00:00	MSFT	Stock	35.044	35.07	34.98	34.995	1537196.0
2013-06-18 14:30:00	MSFT	Stock	35.0	35.07	34.99	35.05	1201805.0
2013-06-18 15:00:00	MSFT	Stock	35.045	35.06	35.0	35.06	1249141.0
2013-06-18 15:30:00	MSFT	Stock	35.055	35.06	34.94	35.01	3201405.0
2013-06-18 16:00:00	MSFT	Stock	35.01	35.084	34.973	35.01	3826280.0
2013-06-18 16:30:00	MSFT	Stock	35.01	35.017	35.01	35.017	27201.0
2013-06-18 17:00:00	MSFT	Stock	35.02	35.02	34.99	35.01	422677.0
2013-06-18 18:00:00	MSFT	Stock	35.01	35.05	35.01	35.05	1625.0
2013-06-18 18:30:00	MSFT	Stock	35.04	35.04	35.04	35.04	150.0
2013-06-18 19:00:00	MSFT	Stock	35.04	35.05	35.03	35.03	3835.0
2013-06-18 19:30:00	MSFT	Stock	34.96	34.96	34.94	34.95	2450.0

> showing 50 of 79,795 rows — these rows as CSV

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