PREVIEW / stock_30min / 2011-06-10

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-10.parquet
  size:    1.4 MB
  rows:    78,740
  symbols: 3,540

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-06-10 04:00:00	AAPL	Stock	11.8268	11.8286	11.8268	11.8275	30800.0
2011-06-10 05:00:00	AAPL	Stock	11.8571	11.8571	11.8571	11.8571	5600.0
2011-06-10 05:30:00	AAPL	Stock	11.8571	11.8571	11.8571	11.8571	2800.0
2011-06-10 07:00:00	AAPL	Stock	11.8482	11.8482	11.8375	11.8375	25200.0
2011-06-10 07:30:00	AAPL	Stock	11.8482	11.8568	11.835	11.85	136780.0
2011-06-10 08:00:00	AAPL	Stock	11.8468	11.8482	11.8286	11.8286	328020.0
2011-06-10 08:30:00	AAPL	Stock	11.8293	11.8332	11.8075	11.8193	872228.0
2011-06-10 09:00:00	AAPL	Stock	11.8118	11.8179	11.7775	11.8107	1804768.0
2011-06-10 09:30:00	AAPL	Stock	11.8054	11.845	11.7846	11.8279	60982460.0
2011-06-10 10:00:00	AAPL	Stock	11.8254	11.83	11.7882	11.8003	31285436.0
2011-06-10 10:30:00	AAPL	Stock	11.7993	11.8143	11.6964	11.7061	59404492.0
2011-06-10 11:00:00	AAPL	Stock	11.7071	11.7243	11.6639	11.69	41848856.0
2011-06-10 11:30:00	AAPL	Stock	11.6924	11.7164	11.6718	11.6975	20442240.0
2011-06-10 12:00:00	AAPL	Stock	11.6975	11.7096	11.6789	11.7051	15407280.0
2011-06-10 12:30:00	AAPL	Stock	11.7043	11.7204	11.6939	11.6964	14611996.0
2011-06-10 13:00:00	AAPL	Stock	11.6968	11.6979	11.6607	11.6812	16925496.0
2011-06-10 13:30:00	AAPL	Stock	11.6804	11.6811	11.6514	11.6775	22035076.0
2011-06-10 14:00:00	AAPL	Stock	11.6775	11.7214	11.6746	11.6907	27947080.0
2011-06-10 14:30:00	AAPL	Stock	11.6879	11.7189	11.6611	11.7164	22462440.0
2011-06-10 15:00:00	AAPL	Stock	11.7161	11.72	11.6732	11.6796	24899644.0
2011-06-10 15:30:00	AAPL	Stock	11.68	11.6871	11.6254	11.6275	54231632.0
2011-06-10 16:00:00	AAPL	Stock	11.6325	11.7275	11.6093	11.6289	11869088.0
2011-06-10 16:30:00	AAPL	Stock	11.6275	11.6794	11.625	11.6257	955192.0
2011-06-10 17:00:00	AAPL	Stock	11.6282	11.6286	11.6214	11.6218	113568.0
2011-06-10 17:30:00	AAPL	Stock	11.6214	11.6214	11.6182	11.6196	64400.0
2011-06-10 18:00:00	AAPL	Stock	11.6196	11.6393	11.6182	11.6182	68992.0
2011-06-10 18:30:00	AAPL	Stock	11.62	11.6214	11.6182	11.6211	106764.0
2011-06-10 19:00:00	AAPL	Stock	11.6214	11.6261	11.6214	11.6218	22736.0
2011-06-10 19:30:00	AAPL	Stock	11.6221	11.6279	11.6196	11.6279	40824.0
2011-06-10 05:00:00	MSFT	Stock	23.99	23.99	23.99	23.99	100.0
2011-06-10 07:30:00	MSFT	Stock	23.92	23.92	23.92	23.92	378.0
2011-06-10 08:00:00	MSFT	Stock	23.88	23.92	23.88	23.92	7986.0
2011-06-10 08:30:00	MSFT	Stock	23.92	23.92	23.92	23.92	500.0
2011-06-10 09:00:00	MSFT	Stock	23.91	24.02	23.91	24.01	39918.0
2011-06-10 09:30:00	MSFT	Stock	24.01	24.02	23.84	23.93	5243841.0
2011-06-10 10:00:00	MSFT	Stock	23.935	23.98	23.83	23.88	3668239.0
2011-06-10 10:30:00	MSFT	Stock	23.88	23.9	23.8	23.85	3445662.0
2011-06-10 11:00:00	MSFT	Stock	23.85	23.89	23.81	23.865	2797488.0
2011-06-10 11:30:00	MSFT	Stock	23.865	23.89	23.83	23.855	3087249.0
2011-06-10 12:00:00	MSFT	Stock	23.86	23.89	23.83	23.86	2177284.0
2011-06-10 12:30:00	MSFT	Stock	23.86	23.88	23.81	23.83	3428515.0
2011-06-10 13:00:00	MSFT	Stock	23.84	23.84	23.77	23.78	2530184.0
2011-06-10 13:30:00	MSFT	Stock	23.79	23.79	23.72	23.77	2376587.0
2011-06-10 14:00:00	MSFT	Stock	23.77	23.86	23.77	23.814	3355615.0
2011-06-10 14:30:00	MSFT	Stock	23.815	23.888	23.79	23.886	2692238.0
2011-06-10 15:00:00	MSFT	Stock	23.885	23.89	23.82	23.84	2997599.0
2011-06-10 15:30:00	MSFT	Stock	23.85	23.87	23.69	23.69	7022091.0
2011-06-10 16:00:00	MSFT	Stock	23.7	23.852	23.64	23.746	2879456.0
2011-06-10 16:30:00	MSFT	Stock	23.69	23.842	23.69	23.69	280041.0
2011-06-10 17:00:00	MSFT	Stock	23.69	23.69	23.68	23.69	6780.0

> showing 50 of 78,740 rows — these rows as CSV

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