PREVIEW / stock_30min / 2011-05-13

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-13.parquet
  size:    1.4 MB
  rows:    76,197
  symbols: 3,566

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-05-13 04:00:00	AAPL	Stock	12.3929	12.3929	12.3929	12.3929	5600.0
2011-05-13 04:30:00	AAPL	Stock	12.375	12.375	12.375	12.375	2800.0
2011-05-13 05:00:00	AAPL	Stock	12.3607	12.3607	12.3607	12.3607	5880.0
2011-05-13 05:30:00	AAPL	Stock	12.3643	12.3643	12.3643	12.3643	53760.0
2011-05-13 06:00:00	AAPL	Stock	12.3657	12.3896	12.3657	12.3896	11200.0
2011-05-13 07:00:00	AAPL	Stock	12.3764	12.3818	12.3693	12.3696	40880.0
2011-05-13 07:30:00	AAPL	Stock	12.3696	12.3861	12.3696	12.375	67368.0
2011-05-13 08:00:00	AAPL	Stock	12.3818	12.3825	12.3571	12.3696	261548.0
2011-05-13 08:30:00	AAPL	Stock	12.375	12.3818	12.3429	12.3429	960960.0
2011-05-13 09:00:00	AAPL	Stock	12.3511	12.3571	12.3321	12.3496	691740.0
2011-05-13 09:30:00	AAPL	Stock	12.345	12.3661	12.2811	12.2868	38588480.0
2011-05-13 10:00:00	AAPL	Stock	12.2843	12.3254	12.2754	12.3171	24877748.0
2011-05-13 10:30:00	AAPL	Stock	12.315	12.3275	12.2886	12.2946	13967324.0
2011-05-13 11:00:00	AAPL	Stock	12.2925	12.2936	12.225	12.2379	44653168.0
2011-05-13 11:30:00	AAPL	Stock	12.2386	12.2746	12.2343	12.253	19508804.0
2011-05-13 12:00:00	AAPL	Stock	12.2521	12.265	12.2232	12.255	22623104.0
2011-05-13 12:30:00	AAPL	Stock	12.2536	12.2607	12.2393	12.2421	12617864.0
2011-05-13 13:00:00	AAPL	Stock	12.2425	12.2732	12.2396	12.2579	11754876.0
2011-05-13 13:30:00	AAPL	Stock	12.2568	12.2646	12.2332	12.2489	10891972.0
2011-05-13 14:00:00	AAPL	Stock	12.2488	12.2725	12.2404	12.2561	14967204.0
2011-05-13 14:30:00	AAPL	Stock	12.2561	12.2596	12.2339	12.2414	11662000.0
2011-05-13 15:00:00	AAPL	Stock	12.2414	12.2536	12.1696	12.1796	27730920.0
2011-05-13 15:30:00	AAPL	Stock	12.1818	12.1964	12.1554	12.16	58756992.0
2011-05-13 16:00:00	AAPL	Stock	12.1607	12.2566	12.1489	12.1589	9574628.0
2011-05-13 16:30:00	AAPL	Stock	12.1525	12.1814	12.1525	12.1607	562268.0
2011-05-13 17:00:00	AAPL	Stock	12.1589	12.1614	12.15	12.1589	241724.0
2011-05-13 17:30:00	AAPL	Stock	12.1593	12.1607	12.1543	12.1554	134736.0
2011-05-13 18:00:00	AAPL	Stock	12.1564	12.1607	12.1546	12.1589	193732.0
2011-05-13 18:30:00	AAPL	Stock	12.1571	12.1639	12.1554	12.1639	19600.0
2011-05-13 19:00:00	AAPL	Stock	12.1643	12.1643	12.1589	12.1589	20636.0
2011-05-13 19:30:00	AAPL	Stock	12.1589	12.1607	12.1561	12.1607	90356.0
2011-05-13 04:00:00	MSFT	Stock	25.38	25.38	25.38	25.38	200.0
2011-05-13 06:30:00	MSFT	Stock	25.35	25.35	25.35	25.35	100.0
2011-05-13 07:00:00	MSFT	Stock	25.37	25.37	25.35	25.37	1600.0
2011-05-13 07:30:00	MSFT	Stock	25.34	25.39	25.34	25.39	1200.0
2011-05-13 08:00:00	MSFT	Stock	25.34	25.34	25.28	25.32	10650.0
2011-05-13 08:30:00	MSFT	Stock	25.33	25.36	25.33	25.34	17128.0
2011-05-13 09:00:00	MSFT	Stock	25.33	25.38	25.28	25.28	57213.0
2011-05-13 09:30:00	MSFT	Stock	25.28	25.32	25.12	25.13	4484801.0
2011-05-13 10:00:00	MSFT	Stock	25.12	25.149	25.05	25.135	5307454.0
2011-05-13 10:30:00	MSFT	Stock	25.13	25.24	25.1	25.185	5554721.0
2011-05-13 11:00:00	MSFT	Stock	25.185	25.21	25.05	25.06	6488218.0
2011-05-13 11:30:00	MSFT	Stock	25.06	25.1	25.01	25.025	5166210.0
2011-05-13 12:00:00	MSFT	Stock	25.03	25.05	24.95	25.005	6409397.0
2011-05-13 12:30:00	MSFT	Stock	25.0	25.03	24.97	24.99	3586836.0
2011-05-13 13:00:00	MSFT	Stock	24.99	25.03	24.98	25.01	2870593.0
2011-05-13 13:30:00	MSFT	Stock	25.01	25.05	25.0	25.05	1825034.0
2011-05-13 14:00:00	MSFT	Stock	25.05	25.09	25.02	25.05	3931097.0
2011-05-13 14:30:00	MSFT	Stock	25.05	25.09	25.02	25.09	4601114.0
2011-05-13 15:00:00	MSFT	Stock	25.09	25.11	25.0	25.025	3866757.0

> showing 50 of 76,197 rows — these rows as CSV

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