PREVIEW / stock_30min / 2013-01-09

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-09.parquet
  size:    1.4 MB
  rows:    74,984
  symbols: 3,453

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
2013-01-09 04:00:00	AAPL	Stock	18.8571	18.8571	18.8107	18.8107	11200.0
2013-01-09 04:30:00	AAPL	Stock	18.8207	18.8207	18.8157	18.8157	5600.0
2013-01-09 05:00:00	AAPL	Stock	18.8161	18.8161	18.8161	18.8161	5600.0
2013-01-09 05:30:00	AAPL	Stock	18.8157	18.8157	18.8057	18.8057	11200.0
2013-01-09 06:00:00	AAPL	Stock	18.8161	18.8161	18.8036	18.8036	29204.0
2013-01-09 06:30:00	AAPL	Stock	18.7964	18.8036	18.7671	18.7671	79240.0
2013-01-09 07:00:00	AAPL	Stock	18.7504	18.8211	18.7321	18.8121	290948.0
2013-01-09 07:30:00	AAPL	Stock	18.8	18.8107	18.7921	18.7921	35364.0
2013-01-09 08:00:00	AAPL	Stock	18.7968	18.8107	18.6071	18.6825	1839124.0
2013-01-09 08:30:00	AAPL	Stock	18.6882	18.7089	18.625	18.6625	2426648.0
2013-01-09 09:00:00	AAPL	Stock	18.6579	18.6893	18.6318	18.6607	2394896.0
2013-01-09 09:30:00	AAPL	Stock	18.6593	18.7429	18.5393	18.6314	80471076.0
2013-01-09 10:00:00	AAPL	Stock	18.6279	18.7036	18.5629	18.6721	38480820.0
2013-01-09 10:30:00	AAPL	Stock	18.6711	18.7039	18.6207	18.6856	26441688.0
2013-01-09 11:00:00	AAPL	Stock	18.6853	18.7496	18.6496	18.6739	28372120.0
2013-01-09 11:30:00	AAPL	Stock	18.6739	18.6761	18.6025	18.62	18172868.0
2013-01-09 12:00:00	AAPL	Stock	18.6196	18.6371	18.595	18.6068	13016164.0
2013-01-09 12:30:00	AAPL	Stock	18.6075	18.6264	18.5793	18.6143	16323804.0
2013-01-09 13:00:00	AAPL	Stock	18.6164	18.6343	18.6032	18.6214	11805528.0
2013-01-09 13:30:00	AAPL	Stock	18.6243	18.6718	18.6057	18.645	14827316.0
2013-01-09 14:00:00	AAPL	Stock	18.6454	18.7007	18.6357	18.6689	13590472.0
2013-01-09 14:30:00	AAPL	Stock	18.6707	18.6843	18.5786	18.5882	19429508.0
2013-01-09 15:00:00	AAPL	Stock	18.5839	18.6054	18.5429	18.5829	27751808.0
2013-01-09 15:30:00	AAPL	Stock	18.5854	18.5993	18.4282	18.4679	61164852.0
2013-01-09 16:00:00	AAPL	Stock	18.4686	18.6044	18.4182	18.425	15992984.0
2013-01-09 16:30:00	AAPL	Stock	18.4229	18.5828	18.4136	18.4179	540792.0
2013-01-09 17:00:00	AAPL	Stock	18.4207	18.4357	18.4143	18.4321	319620.0
2013-01-09 17:30:00	AAPL	Stock	18.4357	18.4357	18.4232	18.4282	138824.0
2013-01-09 18:00:00	AAPL	Stock	18.4221	18.4339	18.4221	18.4286	112532.0
2013-01-09 18:30:00	AAPL	Stock	18.4286	18.4286	18.4214	18.4218	99400.0
2013-01-09 19:00:00	AAPL	Stock	18.4268	18.4339	18.4268	18.4289	119756.0
2013-01-09 19:30:00	AAPL	Stock	18.4286	18.43	18.4179	18.4204	116256.0
2013-01-09 06:30:00	MSFT	Stock	26.64	26.64	26.64	26.64	5000.0
2013-01-09 07:00:00	MSFT	Stock	26.6	26.61	26.6	26.6	6025.0
2013-01-09 07:30:00	MSFT	Stock	26.6	26.61	26.6	26.6	8800.0
2013-01-09 08:00:00	MSFT	Stock	26.62	26.64	26.59	26.6	14495.0
2013-01-09 08:30:00	MSFT	Stock	26.6	26.61	26.6	26.61	8676.0
2013-01-09 09:00:00	MSFT	Stock	26.61	26.74	26.61	26.72	58312.0
2013-01-09 09:30:00	MSFT	Stock	26.75	26.75	26.6	26.635	4799709.0
2013-01-09 10:00:00	MSFT	Stock	26.635	26.7	26.56	26.67	4810548.0
2013-01-09 10:30:00	MSFT	Stock	26.675	26.69	26.6	26.63	2878075.0
2013-01-09 11:00:00	MSFT	Stock	26.635	26.66	26.614	26.635	1936421.0
2013-01-09 11:30:00	MSFT	Stock	26.63	26.66	26.62	26.62	1746634.0
2013-01-09 12:00:00	MSFT	Stock	26.625	26.65	26.62	26.635	1226151.0
2013-01-09 12:30:00	MSFT	Stock	26.64	26.65	26.6	26.626	1715541.0
2013-01-09 13:00:00	MSFT	Stock	26.628	26.64	26.6	26.63	1352160.0
2013-01-09 13:30:00	MSFT	Stock	26.63	26.65	26.62	26.65	1577413.0
2013-01-09 14:00:00	MSFT	Stock	26.65	26.67	26.64	26.67	2000098.0
2013-01-09 14:30:00	MSFT	Stock	26.665	26.67	26.6	26.62	2820412.0
2013-01-09 15:00:00	MSFT	Stock	26.62	26.66	26.56	26.64	3069574.0

> showing 50 of 74,984 rows — these rows as CSV

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