PREVIEW / stock_30min / 2010-04-08

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-08.parquet
  size:    1.4 MB
  rows:    75,002
  symbols: 3,476

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
2010-04-08 04:00:00	AAPL	Stock	8.5504	8.5732	8.5504	8.5679	65128.0
2010-04-08 04:30:00	AAPL	Stock	8.5714	8.5714	8.5714	8.5714	2800.0
2010-04-08 05:00:00	AAPL	Stock	8.5679	8.5696	8.5643	8.5696	37604.0
2010-04-08 05:30:00	AAPL	Stock	8.5732	8.5732	8.5732	8.5732	2800.0
2010-04-08 07:00:00	AAPL	Stock	8.5904	8.5904	8.5904	8.5904	5600.0
2010-04-08 07:30:00	AAPL	Stock	8.5804	8.5804	8.5675	8.5714	33600.0
2010-04-08 08:00:00	AAPL	Stock	8.5714	8.5929	8.5661	8.5714	1091440.0
2010-04-08 08:30:00	AAPL	Stock	8.5696	8.5732	8.54	8.5686	2052680.0
2010-04-08 09:00:00	AAPL	Stock	8.5704	8.5868	8.5643	8.5857	1087240.0
2010-04-08 09:30:00	AAPL	Stock	8.5871	8.5929	8.5036	8.5099	88213440.0
2010-04-08 10:00:00	AAPL	Stock	8.5106	8.5521	8.5014	8.5404	58919812.0
2010-04-08 10:30:00	AAPL	Stock	8.54	8.5607	8.5289	8.5382	32479916.0
2010-04-08 11:00:00	AAPL	Stock	8.5379	8.5593	8.5293	8.5323	25936036.0
2010-04-08 11:30:00	AAPL	Stock	8.5311	8.5599	8.5304	8.5482	18035892.0
2010-04-08 12:00:00	AAPL	Stock	8.5489	8.5807	8.5461	8.5782	23690744.0
2010-04-08 12:30:00	AAPL	Stock	8.5786	8.5925	8.5629	8.5921	21766136.0
2010-04-08 13:00:00	AAPL	Stock	8.5921	8.6264	8.5486	8.6005	93328228.0
2010-04-08 13:30:00	AAPL	Stock	8.6004	8.6143	8.5725	8.5768	41630484.0
2010-04-08 14:00:00	AAPL	Stock	8.5768	8.5829	8.5521	8.5796	37680132.0
2010-04-08 14:30:00	AAPL	Stock	8.5789	8.5839	8.5675	8.5746	25342772.0
2010-04-08 15:00:00	AAPL	Stock	8.5714	8.5911	8.5554	8.5846	33766936.0
2010-04-08 15:30:00	AAPL	Stock	8.5843	8.5886	8.5625	8.5696	54294940.0
2010-04-08 16:00:00	AAPL	Stock	8.5696	8.5743	8.5143	8.5707	5004328.0
2010-04-08 16:30:00	AAPL	Stock	8.5837	8.5889	8.5689	8.5725	228368.0
2010-04-08 17:00:00	AAPL	Stock	8.5721	8.5743	8.5714	8.5718	38136.0
2010-04-08 17:30:00	AAPL	Stock	8.5718	8.575	8.5714	8.575	141064.0
2010-04-08 18:00:00	AAPL	Stock	8.5718	8.5768	8.5696	8.5707	147616.0
2010-04-08 18:30:00	AAPL	Stock	8.57	8.5714	8.57	8.5714	42000.0
2010-04-08 19:00:00	AAPL	Stock	8.5686	8.5768	8.5686	8.575	59248.0
2010-04-08 19:30:00	AAPL	Stock	8.5746	8.5757	8.5725	8.5739	131292.0
2010-04-08 07:00:00	MSFT	Stock	29.22	29.24	29.22	29.24	11000.0
2010-04-08 07:30:00	MSFT	Stock	29.21	29.21	29.2	29.21	5000.0
2010-04-08 08:00:00	MSFT	Stock	29.23	29.35	29.23	29.3	26870.0
2010-04-08 08:30:00	MSFT	Stock	29.3	29.34	29.3	29.33	4208.0
2010-04-08 09:00:00	MSFT	Stock	29.3	29.31	29.27	29.31	9371.0
2010-04-08 09:30:00	MSFT	Stock	29.32	29.55	29.3	29.49	6337735.0
2010-04-08 10:00:00	MSFT	Stock	29.5	29.65	29.47	29.615	5296803.0
2010-04-08 10:30:00	MSFT	Stock	29.615	29.69	29.55	29.56	4776180.0
2010-04-08 11:00:00	MSFT	Stock	29.55	29.65	29.55	29.63	4249091.0
2010-04-08 11:30:00	MSFT	Stock	29.625	29.87	29.625	29.835	6619309.0
2010-04-08 12:00:00	MSFT	Stock	29.84	29.9	29.74	29.88	4472111.0
2010-04-08 12:30:00	MSFT	Stock	29.874	29.94	29.83	29.92	2984636.0
2010-04-08 13:00:00	MSFT	Stock	29.94	29.97	29.83	29.83	3030829.0
2010-04-08 13:30:00	MSFT	Stock	29.835	29.89	29.82	29.85	3355680.0
2010-04-08 14:00:00	MSFT	Stock	29.85	29.89	29.83	29.88	2332531.0
2010-04-08 14:30:00	MSFT	Stock	29.875	29.945	29.87	29.932	2777826.0
2010-04-08 15:00:00	MSFT	Stock	29.935	29.975	29.9	29.94	4048806.0
2010-04-08 15:30:00	MSFT	Stock	29.935	29.97	29.87	29.91	8754620.0
2010-04-08 16:00:00	MSFT	Stock	29.91	29.93	29.516	29.88	2161380.0
2010-04-08 16:30:00	MSFT	Stock	29.923	29.934	29.85	29.91	119185.0

> showing 50 of 75,002 rows — these rows as CSV

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