PREVIEW / stock_30min / 2012-02-13

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-13.parquet
  size:    1.5 MB
  rows:    77,656
  symbols: 3,545

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-02-13 04:00:00	AAPL	Stock	17.6139	17.8479	17.6139	17.8214	84980.0
2012-02-13 04:30:00	AAPL	Stock	17.8214	17.8393	17.8214	17.8321	30268.0
2012-02-13 05:00:00	AAPL	Stock	17.8268	17.8286	17.8132	17.8132	68012.0
2012-02-13 05:30:00	AAPL	Stock	17.8132	17.8321	17.8132	17.8286	84280.0
2012-02-13 06:00:00	AAPL	Stock	17.8286	17.8343	17.8286	17.8343	13860.0
2012-02-13 06:30:00	AAPL	Stock	17.8389	17.8393	17.8214	17.8321	109760.0
2012-02-13 07:00:00	AAPL	Stock	17.8214	17.8375	17.8036	17.8211	950684.0
2012-02-13 07:30:00	AAPL	Stock	17.8282	17.8282	17.8111	17.8211	699580.0
2012-02-13 08:00:00	AAPL	Stock	17.8211	17.8257	17.8068	17.8196	2558108.0
2012-02-13 08:30:00	AAPL	Stock	17.8214	17.855	17.7968	17.8446	4543588.0
2012-02-13 09:00:00	AAPL	Stock	17.8439	17.8525	17.8179	17.8479	5803140.0
2012-02-13 09:30:00	AAPL	Stock	17.8471	17.9939	17.8314	17.8611	136913280.0
2012-02-13 10:00:00	AAPL	Stock	17.8632	17.9196	17.8186	17.8271	56024556.0
2012-02-13 10:30:00	AAPL	Stock	17.8278	17.8921	17.7939	17.855	38830204.0
2012-02-13 11:00:00	AAPL	Stock	17.8561	17.8786	17.825	17.8332	23355192.0
2012-02-13 11:30:00	AAPL	Stock	17.8286	17.8589	17.8286	17.847	16668904.0
2012-02-13 12:00:00	AAPL	Stock	17.8489	17.8525	17.7686	17.7696	23625840.0
2012-02-13 12:30:00	AAPL	Stock	17.7689	17.8271	17.7532	17.827	21510328.0
2012-02-13 13:00:00	AAPL	Stock	17.8271	17.8571	17.8207	17.8386	16159388.0
2012-02-13 13:30:00	AAPL	Stock	17.8375	17.885	17.8314	17.8675	16275056.0
2012-02-13 14:00:00	AAPL	Stock	17.8679	17.9046	17.8596	17.8679	22177960.0
2012-02-13 14:30:00	AAPL	Stock	17.8679	17.9239	17.8596	17.8975	25028556.0
2012-02-13 15:00:00	AAPL	Stock	17.8968	17.9204	17.8768	17.9096	22034208.0
2012-02-13 15:30:00	AAPL	Stock	17.9089	17.95	17.8697	17.9493	52785292.0
2012-02-13 16:00:00	AAPL	Stock	17.95	17.9775	17.7889	17.9754	16143288.0
2012-02-13 16:30:00	AAPL	Stock	17.9789	17.9889	17.855	17.9839	1213240.0
2012-02-13 17:00:00	AAPL	Stock	17.9825	17.9846	17.836	17.9464	1455888.0
2012-02-13 17:30:00	AAPL	Stock	17.9507	17.9714	17.9493	17.9571	271264.0
2012-02-13 18:00:00	AAPL	Stock	17.9571	17.9571	17.9111	17.9286	517300.0
2012-02-13 18:30:00	AAPL	Stock	17.9286	17.9657	17.9286	17.9657	155736.0
2012-02-13 19:00:00	AAPL	Stock	17.9536	17.9661	17.9518	17.9643	133392.0
2012-02-13 19:30:00	AAPL	Stock	17.9643	17.9714	17.9554	17.9571	207788.0
2012-02-13 05:00:00	MSFT	Stock	30.68	30.68	30.68	30.68	1100.0
2012-02-13 05:30:00	MSFT	Stock	30.66	30.66	30.66	30.66	200.0
2012-02-13 06:00:00	MSFT	Stock	30.66	30.66	30.66	30.66	4800.0
2012-02-13 07:00:00	MSFT	Stock	30.61	30.61	30.61	30.61	956.0
2012-02-13 07:30:00	MSFT	Stock	30.68	30.68	30.68	30.68	400.0
2012-02-13 08:00:00	MSFT	Stock	30.65	30.69	30.55	30.68	30300.0
2012-02-13 08:30:00	MSFT	Stock	30.68	30.68	30.62	30.62	7375.0
2012-02-13 09:00:00	MSFT	Stock	30.65	30.69	30.485	30.67	53375.0
2012-02-13 09:30:00	MSFT	Stock	30.65	30.77	30.58	30.745	5052808.0
2012-02-13 10:00:00	MSFT	Stock	30.74	30.745	30.55	30.558	3365923.0
2012-02-13 10:30:00	MSFT	Stock	30.555	30.56	30.43	30.495	2907438.0
2012-02-13 11:00:00	MSFT	Stock	30.495	30.58	30.49	30.5	1797172.0
2012-02-13 11:30:00	MSFT	Stock	30.5	30.59	30.48	30.56	2430903.0
2012-02-13 12:00:00	MSFT	Stock	30.554	30.6	30.53	30.57	1199203.0
2012-02-13 12:30:00	MSFT	Stock	30.56	30.59	30.53	30.59	1272002.0
2012-02-13 13:00:00	MSFT	Stock	30.585	30.61	30.55	30.55	1255279.0
2012-02-13 13:30:00	MSFT	Stock	30.55	30.62	30.55	30.611	1494566.0
2012-02-13 14:00:00	MSFT	Stock	30.611	30.67	30.6	30.645	1698876.0

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

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