PREVIEW / stock_30min / 2010-01-06

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-06.parquet
  size:    1.4 MB
  rows:    74,247
  symbols: 3,442

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
2010-01-06 04:00:00	AAPL	Stock	7.6668	7.6696	7.6668	7.6696	5600.0
2010-01-06 04:30:00	AAPL	Stock	7.6714	7.675	7.6714	7.675	8400.0
2010-01-06 06:00:00	AAPL	Stock	7.6782	7.6782	7.6782	7.6782	3584.0
2010-01-06 07:00:00	AAPL	Stock	7.6782	7.6782	7.6521	7.6521	80668.0
2010-01-06 07:30:00	AAPL	Stock	7.6518	7.6611	7.6464	7.6611	71848.0
2010-01-06 08:00:00	AAPL	Stock	7.6607	7.6629	7.6507	7.6611	316540.0
2010-01-06 08:30:00	AAPL	Stock	7.6596	7.6696	7.6571	7.6679	248808.0
2010-01-06 09:00:00	AAPL	Stock	7.6682	7.6714	7.6518	7.6596	478940.0
2010-01-06 09:30:00	AAPL	Stock	7.6564	7.6868	7.6346	7.6536	66026716.0
2010-01-06 10:00:00	AAPL	Stock	7.6529	7.6736	7.6457	7.655	42734272.0
2010-01-06 10:30:00	AAPL	Stock	7.6543	7.6696	7.6489	7.6661	31813964.0
2010-01-06 11:00:00	AAPL	Stock	7.6664	7.6821	7.6571	7.6746	26450704.0
2010-01-06 11:30:00	AAPL	Stock	7.6746	7.6761	7.6168	7.6254	37926448.0
2010-01-06 12:00:00	AAPL	Stock	7.6257	7.6304	7.5857	7.592	49957012.0
2010-01-06 12:30:00	AAPL	Stock	7.5914	7.6214	7.5893	7.5946	28536984.0
2010-01-06 13:00:00	AAPL	Stock	7.5946	7.6193	7.5943	7.6145	17413620.0
2010-01-06 13:30:00	AAPL	Stock	7.6139	7.6179	7.5432	7.5579	58200212.0
2010-01-06 14:00:00	AAPL	Stock	7.5568	7.5796	7.5446	7.5789	40171516.0
2010-01-06 14:30:00	AAPL	Stock	7.5779	7.6107	7.5754	7.5786	39264092.0
2010-01-06 15:00:00	AAPL	Stock	7.5779	7.5825	7.5579	7.5739	28088508.0
2010-01-06 15:30:00	AAPL	Stock	7.5739	7.5779	7.5268	7.5336	66618860.0
2010-01-06 16:00:00	AAPL	Stock	7.5346	7.617	7.5311	7.5354	7803824.0
2010-01-06 16:30:00	AAPL	Stock	7.5495	7.5495	7.5343	7.5393	394576.0
2010-01-06 17:00:00	AAPL	Stock	7.5614	7.5614	7.5339	7.5339	277228.0
2010-01-06 17:30:00	AAPL	Stock	7.5354	7.5439	7.5334	7.5439	201404.0
2010-01-06 18:00:00	AAPL	Stock	7.5446	7.5536	7.5346	7.5532	1300544.0
2010-01-06 18:30:00	AAPL	Stock	7.5532	7.5536	7.55	7.5525	190484.0
2010-01-06 19:00:00	AAPL	Stock	7.5507	7.5529	7.5507	7.5518	61180.0
2010-01-06 19:30:00	AAPL	Stock	7.5518	7.5564	7.55	7.5561	416612.0
2010-01-06 20:00:00	AAPL	Stock	7.6521	7.6521	7.6521	7.6521	5600.0
2010-01-06 07:30:00	MSFT	Stock	30.9	30.9	30.9	30.9	1400.0
2010-01-06 08:00:00	MSFT	Stock	30.97	30.99	30.97	30.99	2000.0
2010-01-06 08:30:00	MSFT	Stock	31.0	31.06	31.0	31.06	1526.0
2010-01-06 09:00:00	MSFT	Stock	31.04	31.06	30.88	30.92	58236.0
2010-01-06 09:30:00	MSFT	Stock	30.91	31.08	30.88	31.0	5202727.0
2010-01-06 10:00:00	MSFT	Stock	31.0	31.05	30.97	31.01	4366891.0
2010-01-06 10:30:00	MSFT	Stock	31.0	31.02	30.915	30.96	3409800.0
2010-01-06 11:00:00	MSFT	Stock	30.96	31.0	30.88	30.88	2509104.0
2010-01-06 11:30:00	MSFT	Stock	30.89	30.947	30.68	30.69	3767362.0
2010-01-06 12:00:00	MSFT	Stock	30.68	30.861	30.52	30.59	5678042.0
2010-01-06 12:30:00	MSFT	Stock	30.59	30.62	30.53	30.62	2208029.0
2010-01-06 13:00:00	MSFT	Stock	30.62	30.71	30.61	30.69	2283472.0
2010-01-06 13:30:00	MSFT	Stock	30.69	30.695	30.53	30.54	2649879.0
2010-01-06 14:00:00	MSFT	Stock	30.54	30.72	30.538	30.698	3746983.0
2010-01-06 14:30:00	MSFT	Stock	30.7	30.83	30.69	30.76	4572591.0
2010-01-06 15:00:00	MSFT	Stock	30.76	30.79	30.56	30.78	3646504.0
2010-01-06 15:30:00	MSFT	Stock	30.78	30.8	30.65	30.77	7044912.0
2010-01-06 16:00:00	MSFT	Stock	30.77	30.8	30.612	30.797	4473768.0
2010-01-06 16:30:00	MSFT	Stock	30.736	30.77	30.615	30.73	213423.0
2010-01-06 17:00:00	MSFT	Stock	30.64	30.77	30.64	30.77	41550.0

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

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