PREVIEW / stock_30min / 2012-10-01

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-01.parquet
  size:    1.5 MB
  rows:    77,825
  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
2012-10-01 04:00:00	AAPL	Stock	23.8093	23.9289	23.8093	23.9289	153300.0
2012-10-01 04:30:00	AAPL	Stock	23.9286	23.9286	23.9286	23.9286	7000.0
2012-10-01 05:00:00	AAPL	Stock	23.9446	23.9464	23.9407	23.9464	67760.0
2012-10-01 05:30:00	AAPL	Stock	23.9571	23.9679	23.9571	23.9679	20020.0
2012-10-01 06:00:00	AAPL	Stock	23.95	23.95	23.95	23.95	12600.0
2012-10-01 06:30:00	AAPL	Stock	23.9429	23.9429	23.9429	23.9429	5600.0
2012-10-01 07:00:00	AAPL	Stock	23.9571	23.9571	23.8654	23.875	376012.0
2012-10-01 07:30:00	AAPL	Stock	23.8929	24.0	23.8929	23.9879	546028.0
2012-10-01 08:00:00	AAPL	Stock	23.9604	23.9964	23.8307	23.9532	930216.0
2012-10-01 08:30:00	AAPL	Stock	23.9518	24.0071	23.9518	23.9896	1248072.0
2012-10-01 09:00:00	AAPL	Stock	23.9918	24.0	23.935	23.975	1195712.0
2012-10-01 09:30:00	AAPL	Stock	23.9714	24.0232	23.8126	23.9307	69340040.0
2012-10-01 10:00:00	AAPL	Stock	23.9354	24.1696	23.935	24.1345	59287312.0
2012-10-01 10:30:00	AAPL	Stock	24.1318	24.1386	24.0189	24.0521	29056076.0
2012-10-01 11:00:00	AAPL	Stock	24.0521	24.1196	24.0428	24.0811	19019868.0
2012-10-01 11:30:00	AAPL	Stock	24.0814	24.1136	24.0179	24.0264	12830272.0
2012-10-01 12:00:00	AAPL	Stock	24.0271	24.0695	23.9139	23.9429	25153212.0
2012-10-01 12:30:00	AAPL	Stock	23.9464	23.98	23.8304	23.8782	31903340.0
2012-10-01 13:00:00	AAPL	Stock	23.8771	23.9107	23.6914	23.7907	48172124.0
2012-10-01 13:30:00	AAPL	Stock	23.7907	23.8493	23.6429	23.8271	42435596.0
2012-10-01 14:00:00	AAPL	Stock	23.8271	23.8479	23.7004	23.7271	26120024.0
2012-10-01 14:30:00	AAPL	Stock	23.7286	23.7979	23.7064	23.7318	24862432.0
2012-10-01 15:00:00	AAPL	Stock	23.7325	23.7379	23.5018	23.5446	65675008.0
2012-10-01 15:30:00	AAPL	Stock	23.5436	23.5639	23.4464	23.5621	65543100.0
2012-10-01 16:00:00	AAPL	Stock	23.5571	23.916	23.5135	23.575	11924444.0
2012-10-01 16:30:00	AAPL	Stock	24.095	24.095	23.5052	23.5679	662256.0
2012-10-01 17:00:00	AAPL	Stock	23.5714	23.5839	23.5496	23.5786	289800.0
2012-10-01 17:30:00	AAPL	Stock	23.5786	23.5786	23.5554	23.5618	57344.0
2012-10-01 18:00:00	AAPL	Stock	23.5664	23.5679	23.5546	23.5586	86240.0
2012-10-01 18:30:00	AAPL	Stock	23.5639	23.5707	23.5625	23.5679	269864.0
2012-10-01 19:00:00	AAPL	Stock	23.5629	23.5643	23.5571	23.5589	120904.0
2012-10-01 19:30:00	AAPL	Stock	23.5586	23.5586	23.5414	23.55	262136.0
2012-10-01 04:00:00	MSFT	Stock	29.76	29.77	29.76	29.76	700.0
2012-10-01 05:00:00	MSFT	Stock	29.71	29.71	29.69	29.69	3990.0
2012-10-01 05:30:00	MSFT	Stock	29.69	29.69	29.69	29.69	2200.0
2012-10-01 06:00:00	MSFT	Stock	29.7	29.7	29.69	29.69	2500.0
2012-10-01 06:30:00	MSFT	Stock	29.69	29.76	29.69	29.76	800.0
2012-10-01 07:00:00	MSFT	Stock	29.77	29.77	29.7	29.7	14508.0
2012-10-01 07:30:00	MSFT	Stock	29.7	29.7	29.66	29.66	6350.0
2012-10-01 08:00:00	MSFT	Stock	29.7	29.73	29.67	29.73	18288.0
2012-10-01 08:30:00	MSFT	Stock	29.71	29.78	29.71	29.78	18910.0
2012-10-01 09:00:00	MSFT	Stock	29.8	29.85	29.76	29.85	83687.0
2012-10-01 09:30:00	MSFT	Stock	29.81	29.98	29.43	29.47	7247749.0
2012-10-01 10:00:00	MSFT	Stock	29.47	29.7	29.47	29.575	5694648.0
2012-10-01 10:30:00	MSFT	Stock	29.575	29.64	29.51	29.565	3949434.0
2012-10-01 11:00:00	MSFT	Stock	29.57	29.7	29.56	29.68	2948125.0
2012-10-01 11:30:00	MSFT	Stock	29.68	29.68	29.6	29.61	2104672.0
2012-10-01 12:00:00	MSFT	Stock	29.62	29.66	29.61	29.63	1804020.0
2012-10-01 12:30:00	MSFT	Stock	29.635	29.68	29.51	29.55	2476718.0
2012-10-01 13:00:00	MSFT	Stock	29.55	29.56	29.43	29.54	3071619.0

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

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