PREVIEW / stock_30min / 2011-10-03

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-03.parquet
  size:    1.5 MB
  rows:    77,987
  symbols: 3,528

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-10-03 04:00:00	AAPL	Stock	13.57	13.57	13.5443	13.5493	22400.0
2011-10-03 04:30:00	AAPL	Stock	13.6186	13.6186	13.6179	13.6179	23240.0
2011-10-03 05:00:00	AAPL	Stock	13.6179	13.6179	13.5743	13.5893	19600.0
2011-10-03 05:30:00	AAPL	Stock	13.6036	13.6036	13.5825	13.5825	25200.0
2011-10-03 06:00:00	AAPL	Stock	13.6175	13.6175	13.6071	13.6175	42000.0
2011-10-03 06:30:00	AAPL	Stock	13.6175	13.6746	13.6175	13.6746	47600.0
2011-10-03 07:00:00	AAPL	Stock	13.6643	13.6904	13.6429	13.69	431620.0
2011-10-03 07:30:00	AAPL	Stock	13.6921	13.7125	13.6732	13.7125	639940.0
2011-10-03 08:00:00	AAPL	Stock	13.7107	13.7296	13.6136	13.6493	1780856.0
2011-10-03 08:30:00	AAPL	Stock	13.6518	13.6786	13.6186	13.6575	978124.0
2011-10-03 09:00:00	AAPL	Stock	13.6518	13.6518	13.5779	13.5839	2733192.0
2011-10-03 09:30:00	AAPL	Stock	13.5839	13.6318	13.3896	13.4075	125647816.0
2011-10-03 10:00:00	AAPL	Stock	13.4082	13.6657	13.3929	13.55	82990040.0
2011-10-03 10:30:00	AAPL	Stock	13.5579	13.5646	13.4286	13.4815	38161452.0
2011-10-03 11:00:00	AAPL	Stock	13.4807	13.6329	13.4525	13.6225	40751844.0
2011-10-03 11:30:00	AAPL	Stock	13.6157	13.6482	13.5311	13.5911	31398164.0
2011-10-03 12:00:00	AAPL	Stock	13.5911	13.6007	13.5	13.5407	20844908.0
2011-10-03 12:30:00	AAPL	Stock	13.5404	13.5504	13.4564	13.475	23828196.0
2011-10-03 13:00:00	AAPL	Stock	13.475	13.475	13.3929	13.4557	33443256.0
2011-10-03 13:30:00	AAPL	Stock	13.4567	13.4821	13.3921	13.4669	45138464.0
2011-10-03 14:00:00	AAPL	Stock	13.4611	13.4986	13.425	13.4536	26601596.0
2011-10-03 14:30:00	AAPL	Stock	13.4511	13.4739	13.3275	13.3946	41671644.0
2011-10-03 15:00:00	AAPL	Stock	13.39	13.5471	13.3704	13.4011	53067812.0
2011-10-03 15:30:00	AAPL	Stock	13.4032	13.5057	13.3607	13.3693	64662640.0
2011-10-03 16:00:00	AAPL	Stock	13.3825	13.6121	13.3293	13.3589	23922780.0
2011-10-03 16:30:00	AAPL	Stock	13.3593	13.587	13.3593	13.3714	958524.0
2011-10-03 17:00:00	AAPL	Stock	13.3779	13.3782	13.3536	13.3571	188636.0
2011-10-03 17:30:00	AAPL	Stock	13.3625	13.3839	13.3554	13.3786	235536.0
2011-10-03 18:00:00	AAPL	Stock	13.3818	13.3861	13.375	13.3857	189392.0
2011-10-03 18:30:00	AAPL	Stock	13.3771	13.3796	13.3593	13.3629	198296.0
2011-10-03 19:00:00	AAPL	Stock	13.3668	13.3668	13.3214	13.3396	338688.0
2011-10-03 19:30:00	AAPL	Stock	13.3429	13.3571	13.3361	13.3571	223664.0
2011-10-03 04:00:00	MSFT	Stock	24.76	24.76	24.6	24.6	300.0
2011-10-03 06:00:00	MSFT	Stock	24.68	24.74	24.68	24.74	2100.0
2011-10-03 06:30:00	MSFT	Stock	24.71	24.8	24.71	24.8	250.0
2011-10-03 07:00:00	MSFT	Stock	24.8	24.8	24.7	24.7	7400.0
2011-10-03 07:30:00	MSFT	Stock	24.7	24.78	24.7	24.78	10620.0
2011-10-03 08:00:00	MSFT	Stock	24.79	24.89	24.65	24.65	26621.0
2011-10-03 08:30:00	MSFT	Stock	24.68	24.89	24.66	24.69	40815.0
2011-10-03 09:00:00	MSFT	Stock	24.7	24.89	24.66	24.7	43429.0
2011-10-03 09:30:00	MSFT	Stock	24.69	25.0	24.62	24.68	5369840.0
2011-10-03 10:00:00	MSFT	Stock	24.69	25.335	24.64	25.16	7798861.0
2011-10-03 10:30:00	MSFT	Stock	25.16	25.175	24.95	24.98	4016257.0
2011-10-03 11:00:00	MSFT	Stock	24.97	25.14	24.9	25.038	3628874.0
2011-10-03 11:30:00	MSFT	Stock	25.04	25.13	24.99	25.09	2465617.0
2011-10-03 12:00:00	MSFT	Stock	25.09	25.12	24.95	24.98	2056244.0
2011-10-03 12:30:00	MSFT	Stock	24.97	24.98	24.8	24.838	2046548.0
2011-10-03 13:00:00	MSFT	Stock	24.84	24.88	24.69	24.815	3501175.0
2011-10-03 13:30:00	MSFT	Stock	24.815	24.84	24.68	24.79	3600265.0
2011-10-03 14:00:00	MSFT	Stock	24.785	24.87	24.74	24.82	3786857.0

> showing 50 of 77,987 rows — these rows as CSV

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