PREVIEW / stock_30min / 2011-03-09

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-09.parquet
  size:    1.4 MB
  rows:    74,003
  symbols: 3,532

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-03-09 04:00:00	AAPL	Stock	12.7104	12.7111	12.7104	12.7111	8400.0
2011-03-09 04:30:00	AAPL	Stock	12.7193	12.7193	12.7193	12.7193	2800.0
2011-03-09 06:00:00	AAPL	Stock	12.7143	12.7143	12.7143	12.7143	5600.0
2011-03-09 06:30:00	AAPL	Stock	12.7661	12.7675	12.7661	12.7661	36400.0
2011-03-09 07:00:00	AAPL	Stock	12.7639	12.7639	12.7321	12.7321	76580.0
2011-03-09 07:30:00	AAPL	Stock	12.7325	12.7482	12.7318	12.7464	116928.0
2011-03-09 08:00:00	AAPL	Stock	12.7464	12.7496	12.7257	12.7304	677096.0
2011-03-09 08:30:00	AAPL	Stock	12.7336	12.7336	12.6993	12.7079	508732.0
2011-03-09 09:00:00	AAPL	Stock	12.7082	12.7082	12.6614	12.6664	860496.0
2011-03-09 09:30:00	AAPL	Stock	12.6679	12.67	12.5532	12.6036	63027552.0
2011-03-09 10:00:00	AAPL	Stock	12.6014	12.6364	12.5811	12.6036	84586992.0
2011-03-09 10:30:00	AAPL	Stock	12.6036	12.6146	12.5479	12.5707	62463436.0
2011-03-09 11:00:00	AAPL	Stock	12.5707	12.5829	12.5389	12.5407	32825352.0
2011-03-09 11:30:00	AAPL	Stock	12.5404	12.6204	12.5214	12.6036	42880124.0
2011-03-09 12:00:00	AAPL	Stock	12.6064	12.6282	12.5593	12.5604	22498112.0
2011-03-09 12:30:00	AAPL	Stock	12.5604	12.6071	12.5604	12.5843	16346540.0
2011-03-09 13:00:00	AAPL	Stock	12.5832	12.5979	12.5511	12.5793	14643888.0
2011-03-09 13:30:00	AAPL	Stock	12.58	12.5821	12.5429	12.5525	13222104.0
2011-03-09 14:00:00	AAPL	Stock	12.5546	12.5929	12.5536	12.5646	18576684.0
2011-03-09 14:30:00	AAPL	Stock	12.5647	12.5939	12.5464	12.5793	17522932.0
2011-03-09 15:00:00	AAPL	Stock	12.5821	12.5946	12.5743	12.5857	14395052.0
2011-03-09 15:30:00	AAPL	Stock	12.585	12.59	12.5539	12.5875	37046604.0
2011-03-09 16:00:00	AAPL	Stock	12.5875	12.5893	12.5696	12.5814	8463280.0
2011-03-09 16:30:00	AAPL	Stock	12.5796	12.5882	12.5634	12.5786	394688.0
2011-03-09 17:00:00	AAPL	Stock	12.5786	12.5929	12.5732	12.5732	255080.0
2011-03-09 17:30:00	AAPL	Stock	12.5732	12.5732	12.57	12.5718	111972.0
2011-03-09 18:00:00	AAPL	Stock	12.5711	12.5882	12.5711	12.5804	168448.0
2011-03-09 18:30:00	AAPL	Stock	12.5804	12.5857	12.5768	12.5768	92904.0
2011-03-09 19:00:00	AAPL	Stock	12.58	12.58	12.5732	12.5732	14000.0
2011-03-09 19:30:00	AAPL	Stock	12.5796	12.5796	12.5714	12.5743	163156.0
2011-03-09 04:00:00	MSFT	Stock	25.9	25.9	25.9	25.9	200.0
2011-03-09 06:30:00	MSFT	Stock	26.09	26.09	26.02	26.02	500.0
2011-03-09 07:00:00	MSFT	Stock	26.03	26.03	26.0	26.0	1200.0
2011-03-09 07:30:00	MSFT	Stock	25.95	25.98	25.95	25.97	1500.0
2011-03-09 08:00:00	MSFT	Stock	25.95	25.97	25.95	25.96	2177.0
2011-03-09 08:30:00	MSFT	Stock	25.96	25.96	25.89	25.91	24203.0
2011-03-09 09:00:00	MSFT	Stock	25.86	25.9	25.8	25.8	48335.0
2011-03-09 09:30:00	MSFT	Stock	25.8	25.86	25.66	25.71	4726154.0
2011-03-09 10:00:00	MSFT	Stock	25.71	25.98	25.7	25.97	4359856.0
2011-03-09 10:30:00	MSFT	Stock	25.96	25.965	25.69	25.74	4017435.0
2011-03-09 11:00:00	MSFT	Stock	25.74	25.83	25.69	25.789	2326816.0
2011-03-09 11:30:00	MSFT	Stock	25.79	25.88	25.76	25.88	2866110.0
2011-03-09 12:00:00	MSFT	Stock	25.875	25.94	25.8	25.81	2296118.0
2011-03-09 12:30:00	MSFT	Stock	25.809	25.83	25.75	25.79	2343816.0
2011-03-09 13:00:00	MSFT	Stock	25.798	25.82	25.74	25.802	1893800.0
2011-03-09 13:30:00	MSFT	Stock	25.808	25.81	25.695	25.74	1746074.0
2011-03-09 14:00:00	MSFT	Stock	25.75	25.85	25.75	25.82	1670560.0
2011-03-09 14:30:00	MSFT	Stock	25.823	25.84	25.8	25.82	1757306.0
2011-03-09 15:00:00	MSFT	Stock	25.82	25.85	25.8	25.81	1833592.0
2011-03-09 15:30:00	MSFT	Stock	25.805	25.89	25.76	25.88	5009474.0

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

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