PREVIEW / stock_30min / 2011-04-08

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-08.parquet
  size:    1.4 MB
  rows:    73,836
  symbols: 3,529

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
2011-04-08 04:00:00	AAPL	Stock	12.1214	12.1214	12.1214	12.1214	28000.0
2011-04-08 05:00:00	AAPL	Stock	12.1243	12.1243	12.1243	12.1243	2800.0
2011-04-08 05:30:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	12600.0
2011-04-08 06:30:00	AAPL	Stock	12.125	12.1421	12.125	12.1421	10920.0
2011-04-08 07:00:00	AAPL	Stock	12.1286	12.1464	12.125	12.1339	63280.0
2011-04-08 07:30:00	AAPL	Stock	12.1318	12.1711	12.125	12.1589	393904.0
2011-04-08 08:00:00	AAPL	Stock	12.1582	12.1589	12.1404	12.1404	612640.0
2011-04-08 08:30:00	AAPL	Stock	12.1379	12.1511	12.125	12.1482	481012.0
2011-04-08 09:00:00	AAPL	Stock	12.145	12.1486	12.1264	12.1432	532084.0
2011-04-08 09:30:00	AAPL	Stock	12.1432	12.1482	12.0288	12.0557	55233976.0
2011-04-08 10:00:00	AAPL	Stock	12.0571	12.0714	12.0064	12.0257	36493604.0
2011-04-08 10:30:00	AAPL	Stock	12.0264	12.0507	11.9946	12.0236	33073768.0
2011-04-08 11:00:00	AAPL	Stock	12.0225	12.0429	12.0129	12.0218	21769804.0
2011-04-08 11:30:00	AAPL	Stock	12.0225	12.0564	12.0179	12.0446	15860656.0
2011-04-08 12:00:00	AAPL	Stock	12.0446	12.0518	12.0325	12.0429	9764468.0
2011-04-08 12:30:00	AAPL	Stock	12.0421	12.0529	12.01	12.0207	14603036.0
2011-04-08 13:00:00	AAPL	Stock	12.0206	12.0343	12.0175	12.0317	9856056.0
2011-04-08 13:30:00	AAPL	Stock	12.0314	12.0332	12.0132	12.0275	10514168.0
2011-04-08 14:00:00	AAPL	Stock	12.0282	12.0296	11.9936	12.0054	20027252.0
2011-04-08 14:30:00	AAPL	Stock	12.0054	12.0121	11.9304	11.9329	49335608.0
2011-04-08 15:00:00	AAPL	Stock	11.9304	11.9743	11.9268	11.9636	33597312.0
2011-04-08 15:30:00	AAPL	Stock	11.9634	11.9736	11.945	11.9664	42713132.0
2011-04-08 16:00:00	AAPL	Stock	11.9646	12.0155	11.9629	11.9657	15001168.0
2011-04-08 16:30:00	AAPL	Stock	11.9657	11.9657	11.9455	11.965	273448.0
2011-04-08 17:00:00	AAPL	Stock	11.9643	11.965	11.9625	11.9643	38276.0
2011-04-08 17:30:00	AAPL	Stock	11.9643	11.9643	11.9625	11.9625	44996.0
2011-04-08 18:00:00	AAPL	Stock	11.9625	11.9664	11.9571	11.9589	249984.0
2011-04-08 18:30:00	AAPL	Stock	11.9589	11.9643	11.9579	11.96	85596.0
2011-04-08 19:00:00	AAPL	Stock	11.9614	11.9725	11.9607	11.9682	279188.0
2011-04-08 19:30:00	AAPL	Stock	11.9682	11.9696	11.9664	11.9668	87080.0
2011-04-08 07:00:00	MSFT	Stock	26.23	26.23	26.23	26.23	300.0
2011-04-08 07:30:00	MSFT	Stock	26.33	26.33	26.29	26.3	2500.0
2011-04-08 08:00:00	MSFT	Stock	26.27	26.3	26.26	26.28	7478.0
2011-04-08 08:30:00	MSFT	Stock	26.3	26.32	26.28	26.29	3097.0
2011-04-08 09:00:00	MSFT	Stock	26.29	26.29	26.16	26.17	59937.0
2011-04-08 09:30:00	MSFT	Stock	26.17	26.28	26.04	26.04	3992776.0
2011-04-08 10:00:00	MSFT	Stock	26.04	26.09	25.96	26.02	5282381.0
2011-04-08 10:30:00	MSFT	Stock	26.02	26.055	25.96	26.0	3246681.0
2011-04-08 11:00:00	MSFT	Stock	25.995	26.04	25.97	26.02	2337004.0
2011-04-08 11:30:00	MSFT	Stock	26.01	26.14	26.01	26.12	1602746.0
2011-04-08 12:00:00	MSFT	Stock	26.12	26.16	26.1	26.11	1471205.0
2011-04-08 12:30:00	MSFT	Stock	26.11	26.17	26.07	26.1	1742952.0
2011-04-08 13:00:00	MSFT	Stock	26.11	26.17	26.1	26.13	1714918.0
2011-04-08 13:30:00	MSFT	Stock	26.13	26.14	26.07	26.092	2100087.0
2011-04-08 14:00:00	MSFT	Stock	26.1	26.135	26.08	26.096	1956898.0
2011-04-08 14:30:00	MSFT	Stock	26.092	26.12	25.98	26.0	3518017.0
2011-04-08 15:00:00	MSFT	Stock	26.0	26.05	25.995	26.032	2486080.0
2011-04-08 15:30:00	MSFT	Stock	26.034	26.12	26.02	26.06	5631768.0
2011-04-08 16:00:00	MSFT	Stock	26.07	26.2	26.02	26.07	2178777.0
2011-04-08 16:30:00	MSFT	Stock	26.07	26.07	26.05	26.05	8907.0

> showing 50 of 73,836 rows — these rows as CSV

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