PREVIEW / stock_30min / 2011-03-07

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-07.parquet
  size:    1.4 MB
  rows:    75,180
  symbols: 3,531

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-07 07:00:00	AAPL	Stock	12.8929	12.9286	12.8786	12.9232	127400.0
2011-03-07 07:30:00	AAPL	Stock	12.9107	12.9107	12.8461	12.8482	455448.0
2011-03-07 08:00:00	AAPL	Stock	12.8468	12.8571	12.8279	12.8446	1364468.0
2011-03-07 08:30:00	AAPL	Stock	12.8429	12.8739	12.8429	12.8696	451612.0
2011-03-07 09:00:00	AAPL	Stock	12.8696	12.9071	12.8518	12.9064	2033304.0
2011-03-07 09:30:00	AAPL	Stock	12.9064	12.9168	12.7918	12.8325	66153360.0
2011-03-07 10:00:00	AAPL	Stock	12.8325	12.8464	12.7968	12.8179	27158796.0
2011-03-07 10:30:00	AAPL	Stock	12.8179	12.8193	12.7046	12.7306	52400796.0
2011-03-07 11:00:00	AAPL	Stock	12.7325	12.7329	12.6671	12.6889	43801324.0
2011-03-07 11:30:00	AAPL	Stock	12.6872	12.6939	12.6003	12.6289	50030092.0
2011-03-07 12:00:00	AAPL	Stock	12.6293	12.6704	12.6107	12.6164	33623016.0
2011-03-07 12:30:00	AAPL	Stock	12.6164	12.6282	12.5893	12.6032	34382992.0
2011-03-07 13:00:00	AAPL	Stock	12.6004	12.6143	12.5468	12.5818	48566140.0
2011-03-07 13:30:00	AAPL	Stock	12.5811	12.6207	12.5714	12.6043	29658888.0
2011-03-07 14:00:00	AAPL	Stock	12.6029	12.6586	12.5939	12.6464	28125244.0
2011-03-07 14:30:00	AAPL	Stock	12.6482	12.6621	12.6325	12.6471	23999108.0
2011-03-07 15:00:00	AAPL	Stock	12.6461	12.7018	12.6357	12.6929	33574268.0
2011-03-07 15:30:00	AAPL	Stock	12.6914	12.7282	12.6546	12.6929	50347808.0
2011-03-07 16:00:00	AAPL	Stock	12.6922	12.6964	12.6267	12.6914	10704176.0
2011-03-07 16:30:00	AAPL	Stock	12.6764	12.7068	12.632	12.6786	326144.0
2011-03-07 17:00:00	AAPL	Stock	12.6786	12.6786	12.6679	12.67	168252.0
2011-03-07 17:30:00	AAPL	Stock	12.6679	12.6679	12.6571	12.6668	184632.0
2011-03-07 18:00:00	AAPL	Stock	12.6668	12.6914	12.6668	12.6714	120232.0
2011-03-07 18:30:00	AAPL	Stock	12.6736	12.6754	12.6532	12.675	342972.0
2011-03-07 19:00:00	AAPL	Stock	12.6711	12.6746	12.6711	12.6746	104356.0
2011-03-07 19:30:00	AAPL	Stock	12.6725	12.675	12.6689	12.6689	158788.0
2011-03-07 07:30:00	MSFT	Stock	26.04	26.04	26.01	26.01	1900.0
2011-03-07 08:00:00	MSFT	Stock	26.01	26.01	25.98	25.98	4051.0
2011-03-07 08:30:00	MSFT	Stock	25.95	26.0	25.9	26.0	9906.0
2011-03-07 09:00:00	MSFT	Stock	25.99	26.13	25.99	26.13	78515.0
2011-03-07 09:30:00	MSFT	Stock	26.13	26.27	26.05	26.142	7811348.0
2011-03-07 10:00:00	MSFT	Stock	26.145	26.15	25.91	26.012	4344074.0
2011-03-07 10:30:00	MSFT	Stock	26.015	26.02	25.77	25.86	6368121.0
2011-03-07 11:00:00	MSFT	Stock	25.86	25.86	25.75	25.799	4135149.0
2011-03-07 11:30:00	MSFT	Stock	25.792	25.81	25.66	25.74	5233154.0
2011-03-07 12:00:00	MSFT	Stock	25.73	25.79	25.71	25.718	3035583.0
2011-03-07 12:30:00	MSFT	Stock	25.715	25.75	25.66	25.67	2975804.0
2011-03-07 13:00:00	MSFT	Stock	25.67	25.68	25.6	25.611	3325029.0
2011-03-07 13:30:00	MSFT	Stock	25.619	25.7	25.58	25.61	5822638.0
2011-03-07 14:00:00	MSFT	Stock	25.62	25.66	25.55	25.63	5075972.0
2011-03-07 14:30:00	MSFT	Stock	25.63	25.7	25.58	25.68	2878546.0
2011-03-07 15:00:00	MSFT	Stock	25.675	25.785	25.645	25.738	4036932.0
2011-03-07 15:30:00	MSFT	Stock	25.74	25.8	25.67	25.71	6063540.0
2011-03-07 16:00:00	MSFT	Stock	25.72	25.97	25.67	25.72	3662090.0
2011-03-07 16:30:00	MSFT	Stock	25.71	25.73	25.71	25.72	2300.0
2011-03-07 17:00:00	MSFT	Stock	25.79	25.79	25.72	25.72	1616.0
2011-03-07 18:00:00	MSFT	Stock	25.74	25.78	25.72	25.78	6138.0
2011-03-07 18:30:00	MSFT	Stock	25.79	25.79	25.76	25.76	2200.0
2011-03-07 19:00:00	MSFT	Stock	25.76	25.8	25.76	25.8	4300.0
2011-03-07 07:30:00	NVDA	Stock	0.52	0.52	0.52	0.52	16000.0

> showing 50 of 75,180 rows — these rows as CSV

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