PREVIEW / stock_30min / 2012-04-24

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-24.parquet
  size:    1.4 MB
  rows:    75,732
  symbols: 3,553

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-04-24 04:00:00	AAPL	Stock	20.4896	20.5743	20.4896	20.5714	47600.0
2012-04-24 04:30:00	AAPL	Stock	20.5786	20.6607	20.5786	20.6607	19600.0
2012-04-24 05:00:00	AAPL	Stock	20.6293	20.6857	20.6293	20.6857	32284.0
2012-04-24 05:30:00	AAPL	Stock	20.7	20.7143	20.6821	20.6821	78960.0
2012-04-24 06:00:00	AAPL	Stock	20.7139	20.7139	20.6464	20.6464	32452.0
2012-04-24 06:30:00	AAPL	Stock	20.6486	20.6536	20.6071	20.6429	123200.0
2012-04-24 07:00:00	AAPL	Stock	20.625	20.6429	20.2996	20.3393	1744428.0
2012-04-24 07:30:00	AAPL	Stock	20.3564	20.4507	20.1189	20.1443	4199244.0
2012-04-24 08:00:00	AAPL	Stock	20.15	20.3214	20.1204	20.1425	6356112.0
2012-04-24 08:30:00	AAPL	Stock	20.1307	20.1429	19.9386	19.9457	8641920.0
2012-04-24 09:00:00	AAPL	Stock	19.9429	20.125	19.9107	20.1014	14103600.0
2012-04-24 09:30:00	AAPL	Stock	20.0982	20.25	19.9565	20.1043	144193448.0
2012-04-24 10:00:00	AAPL	Stock	20.0982	20.2746	20.0639	20.1811	64746080.0
2012-04-24 10:30:00	AAPL	Stock	20.1804	20.1917	20.0357	20.052	50203244.0
2012-04-24 11:00:00	AAPL	Stock	20.0532	20.1029	20.0	20.0318	50370068.0
2012-04-24 11:30:00	AAPL	Stock	20.0318	20.0764	19.9464	20.0357	50195124.0
2012-04-24 12:00:00	AAPL	Stock	20.0357	20.0707	19.97	20.01	31337516.0
2012-04-24 12:30:00	AAPL	Stock	20.01	20.0286	19.9286	19.9421	35131292.0
2012-04-24 13:00:00	AAPL	Stock	19.9404	19.9779	19.8571	19.8743	44939020.0
2012-04-24 13:30:00	AAPL	Stock	19.8739	19.9432	19.8257	19.8304	55882176.0
2012-04-24 14:00:00	AAPL	Stock	19.8297	19.8857	19.8214	19.8604	49539476.0
2012-04-24 14:30:00	AAPL	Stock	19.8636	20.1339	19.8607	20.1239	90604304.0
2012-04-24 15:00:00	AAPL	Stock	20.1239	20.1421	19.9404	20.0071	64672076.0
2012-04-24 15:30:00	AAPL	Stock	20.0086	20.1036	19.9564	20.0139	96491780.0
2012-04-24 16:00:00	AAPL	Stock	20.0104	20.1601	19.8286	19.9821	13157060.0
2012-04-24 16:30:00	AAPL	Stock	20.0179	21.5793	20.01	21.5121	130067728.0
2012-04-24 17:00:00	AAPL	Stock	21.5121	21.5179	21.2732	21.3396	25440100.0
2012-04-24 17:30:00	AAPL	Stock	21.3393	21.455	21.3214	21.4436	6746096.0
2012-04-24 18:00:00	AAPL	Stock	21.44	21.5343	21.4379	21.45	5775140.0
2012-04-24 18:30:00	AAPL	Stock	21.4564	21.4643	21.4286	21.4411	1911616.0
2012-04-24 19:00:00	AAPL	Stock	21.4446	21.5075	21.4386	21.5068	1575028.0
2012-04-24 19:30:00	AAPL	Stock	21.5068	21.5857	21.5064	21.5646	3834880.0
2012-04-24 08:00:00	MSFT	Stock	32.1	32.17	32.1	32.12	3000.0
2012-04-24 08:30:00	MSFT	Stock	32.1	32.1	32.05	32.05	19084.0
2012-04-24 09:00:00	MSFT	Stock	32.07	32.22	32.06	32.22	32566.0
2012-04-24 09:30:00	MSFT	Stock	32.22	32.22	32.0	32.03	4978417.0
2012-04-24 10:00:00	MSFT	Stock	32.02	32.16	32.0	32.08	3516804.0
2012-04-24 10:30:00	MSFT	Stock	32.08	32.11	32.02	32.06	2697319.0
2012-04-24 11:00:00	MSFT	Stock	32.05	32.09	32.0	32.07	3354388.0
2012-04-24 11:30:00	MSFT	Stock	32.07	32.1	32.03	32.042	2014413.0
2012-04-24 12:00:00	MSFT	Stock	32.05	32.06	32.03	32.05	1979991.0
2012-04-24 12:30:00	MSFT	Stock	32.05	32.06	31.92	31.94	2214909.0
2012-04-24 13:00:00	MSFT	Stock	31.942	31.96	31.9	31.937	1617413.0
2012-04-24 13:30:00	MSFT	Stock	31.93	31.97	31.89	31.91	1722980.0
2012-04-24 14:00:00	MSFT	Stock	31.9	31.93	31.87	31.88	2684876.0
2012-04-24 14:30:00	MSFT	Stock	31.88	31.93	31.85	31.9	2128333.0
2012-04-24 15:00:00	MSFT	Stock	31.905	31.93	31.875	31.89	2657536.0
2012-04-24 15:30:00	MSFT	Stock	31.89	31.94	31.83	31.922	6036205.0
2012-04-24 16:00:00	MSFT	Stock	31.92	32.065	31.892	31.99	2374363.0
2012-04-24 16:30:00	MSFT	Stock	31.93	32.08	31.92	32.0	117578.0

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

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