PREVIEW / stock_30min / 2012-01-05

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-05.parquet
  size:    1.4 MB
  rows:    75,105
  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
2012-01-05 04:30:00	AAPL	Stock	14.7504	14.7504	14.7504	14.7504	5600.0
2012-01-05 05:00:00	AAPL	Stock	14.7339	14.7339	14.7321	14.7321	56420.0
2012-01-05 05:30:00	AAPL	Stock	14.7321	14.7321	14.7143	14.7143	5600.0
2012-01-05 06:00:00	AAPL	Stock	14.7143	14.7143	14.7	14.7143	23800.0
2012-01-05 06:30:00	AAPL	Stock	14.6982	14.6982	14.6786	14.6971	22400.0
2012-01-05 07:00:00	AAPL	Stock	14.7054	14.7364	14.7054	14.7257	90916.0
2012-01-05 07:30:00	AAPL	Stock	14.7432	14.7761	14.7432	14.7704	333032.0
2012-01-05 08:00:00	AAPL	Stock	14.7743	14.8143	14.7382	14.8139	1558928.0
2012-01-05 08:30:00	AAPL	Stock	14.8104	14.8364	14.7982	14.8204	1360800.0
2012-01-05 09:00:00	AAPL	Stock	14.8129	14.825	14.7986	14.815	974120.0
2012-01-05 09:30:00	AAPL	Stock	14.8193	14.8436	14.7382	14.8046	52491292.0
2012-01-05 10:00:00	AAPL	Stock	14.8036	14.8346	14.7821	14.8132	23988580.0
2012-01-05 10:30:00	AAPL	Stock	14.8132	14.8196	14.7875	14.8071	13118784.0
2012-01-05 11:00:00	AAPL	Stock	14.8043	14.8161	14.7918	14.8093	10532172.0
2012-01-05 11:30:00	AAPL	Stock	14.81	14.835	14.8093	14.8236	11558260.0
2012-01-05 12:00:00	AAPL	Stock	14.8236	14.8671	14.8179	14.8671	16555868.0
2012-01-05 12:30:00	AAPL	Stock	14.8675	14.8693	14.8404	14.8621	10744692.0
2012-01-05 13:00:00	AAPL	Stock	14.8629	14.8846	14.8596	14.8846	12146568.0
2012-01-05 13:30:00	AAPL	Stock	14.885	14.9254	14.8818	14.9196	20737836.0
2012-01-05 14:00:00	AAPL	Stock	14.9223	14.9468	14.9089	14.9122	22808044.0
2012-01-05 14:30:00	AAPL	Stock	14.9121	14.9218	14.8868	14.8939	14299376.0
2012-01-05 15:00:00	AAPL	Stock	14.8941	14.9189	14.8821	14.9139	16139900.0
2012-01-05 15:30:00	AAPL	Stock	14.9154	14.9482	14.8973	14.9271	31634148.0
2012-01-05 16:00:00	AAPL	Stock	14.9304	14.9375	14.8591	14.9296	5814256.0
2012-01-05 16:30:00	AAPL	Stock	14.9296	14.9329	14.9121	14.9286	174048.0
2012-01-05 17:00:00	AAPL	Stock	14.9286	14.9296	14.9186	14.9204	177688.0
2012-01-05 17:30:00	AAPL	Stock	14.9232	14.9296	14.9232	14.9254	447384.0
2012-01-05 18:00:00	AAPL	Stock	14.9236	14.9296	14.9196	14.9196	54236.0
2012-01-05 18:30:00	AAPL	Stock	14.9286	14.9325	14.9286	14.9321	28560.0
2012-01-05 19:00:00	AAPL	Stock	14.9329	14.9329	14.9279	14.9286	63336.0
2012-01-05 19:30:00	AAPL	Stock	14.9286	14.9343	14.9143	14.9143	233884.0
2012-01-05 07:00:00	MSFT	Stock	27.11	27.31	27.11	27.31	1600.0
2012-01-05 07:30:00	MSFT	Stock	27.3	27.31	27.3	27.3	12700.0
2012-01-05 08:00:00	MSFT	Stock	27.28	27.45	27.28	27.42	30723.0
2012-01-05 08:30:00	MSFT	Stock	27.4	27.48	27.33	27.37	40372.0
2012-01-05 09:00:00	MSFT	Stock	27.37	27.43	27.3	27.43	34281.0
2012-01-05 09:30:00	MSFT	Stock	27.38	27.5	27.35	27.4	6529040.0
2012-01-05 10:00:00	MSFT	Stock	27.39	27.48	27.34	27.44	4067294.0
2012-01-05 10:30:00	MSFT	Stock	27.445	27.46	27.29	27.38	4681303.0
2012-01-05 11:00:00	MSFT	Stock	27.38	27.48	27.37	27.47	3828176.0
2012-01-05 11:30:00	MSFT	Stock	27.47	27.5	27.44	27.445	3430939.0
2012-01-05 12:00:00	MSFT	Stock	27.44	27.49	27.41	27.485	2450529.0
2012-01-05 12:30:00	MSFT	Stock	27.488	27.58	27.48	27.56	4748177.0
2012-01-05 13:00:00	MSFT	Stock	27.563	27.59	27.53	27.59	1979157.0
2012-01-05 13:30:00	MSFT	Stock	27.585	27.728	27.58	27.67	4773434.0
2012-01-05 14:00:00	MSFT	Stock	27.665	27.7	27.63	27.64	2640886.0
2012-01-05 14:30:00	MSFT	Stock	27.64	27.67	27.62	27.63	2298562.0
2012-01-05 15:00:00	MSFT	Stock	27.635	27.67	27.6	27.65	3060712.0
2012-01-05 15:30:00	MSFT	Stock	27.65	27.69	27.56	27.67	8016844.0
2012-01-05 16:00:00	MSFT	Stock	27.68	27.7	27.385	27.58	1780104.0

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

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