PREVIEW / stock_30min / 2011-04-26

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-26.parquet
  size:    1.4 MB
  rows:    75,737
  symbols: 3,564

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-04-26 04:00:00	AAPL	Stock	12.6432	12.6514	12.6432	12.6514	5600.0
2011-04-26 04:30:00	AAPL	Stock	12.6518	12.6518	12.6375	12.6496	16800.0
2011-04-26 05:30:00	AAPL	Stock	12.6607	12.6607	12.6607	12.6607	4200.0
2011-04-26 07:00:00	AAPL	Stock	12.6429	12.6464	12.6375	12.6464	85344.0
2011-04-26 07:30:00	AAPL	Stock	12.6464	12.65	12.6418	12.6482	84000.0
2011-04-26 08:00:00	AAPL	Stock	12.65	12.6571	12.6393	12.645	436688.0
2011-04-26 08:30:00	AAPL	Stock	12.645	12.645	12.6243	12.6243	330092.0
2011-04-26 09:00:00	AAPL	Stock	12.6243	12.6421	12.6111	12.63	375424.0
2011-04-26 09:30:00	AAPL	Stock	12.6293	12.6782	12.5636	12.6006	50074360.0
2011-04-26 10:00:00	AAPL	Stock	12.6	12.605	12.5536	12.5796	27407996.0
2011-04-26 10:30:00	AAPL	Stock	12.5804	12.6264	12.5607	12.6257	24388056.0
2011-04-26 11:00:00	AAPL	Stock	12.6243	12.625	12.5839	12.5918	17144624.0
2011-04-26 11:30:00	AAPL	Stock	12.5932	12.6011	12.5743	12.5949	11146660.0
2011-04-26 12:00:00	AAPL	Stock	12.5959	12.6107	12.5679	12.5757	17092012.0
2011-04-26 12:30:00	AAPL	Stock	12.5754	12.5754	12.5479	12.5602	14425628.0
2011-04-26 13:00:00	AAPL	Stock	12.5607	12.5611	12.5175	12.5372	19359984.0
2011-04-26 13:30:00	AAPL	Stock	12.5379	12.5379	12.4768	12.5217	28687680.0
2011-04-26 14:00:00	AAPL	Stock	12.5214	12.544	12.5061	12.5418	15609272.0
2011-04-26 14:30:00	AAPL	Stock	12.5418	12.5439	12.4975	12.5066	16965844.0
2011-04-26 15:00:00	AAPL	Stock	12.5071	12.5425	12.5039	12.5118	21166516.0
2011-04-26 15:30:00	AAPL	Stock	12.5131	12.5211	12.4864	12.5164	39306960.0
2011-04-26 16:00:00	AAPL	Stock	12.5161	12.6155	12.4786	12.5075	26253752.0
2011-04-26 16:30:00	AAPL	Stock	12.5054	12.5179	12.5011	12.5011	384860.0
2011-04-26 17:00:00	AAPL	Stock	12.5036	12.5157	12.5014	12.5071	78568.0
2011-04-26 17:30:00	AAPL	Stock	12.5089	12.5089	12.5014	12.5014	12600.0
2011-04-26 18:00:00	AAPL	Stock	12.5036	12.515	12.5018	12.5018	154000.0
2011-04-26 18:30:00	AAPL	Stock	12.515	12.515	12.5054	12.5071	78204.0
2011-04-26 19:00:00	AAPL	Stock	12.5071	12.5071	12.5018	12.5071	78624.0
2011-04-26 19:30:00	AAPL	Stock	12.5071	12.5146	12.5	12.5036	169596.0
2011-04-26 04:00:00	MSFT	Stock	25.76	25.79	25.76	25.79	200.0
2011-04-26 04:30:00	MSFT	Stock	25.79	25.79	25.79	25.79	500.0
2011-04-26 05:30:00	MSFT	Stock	25.79	25.79	25.65	25.65	300.0
2011-04-26 06:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	200.0
2011-04-26 07:00:00	MSFT	Stock	25.78	25.78	25.78	25.78	200.0
2011-04-26 07:30:00	MSFT	Stock	25.74	25.74	25.69	25.69	4620.0
2011-04-26 08:00:00	MSFT	Stock	25.69	25.8	25.69	25.77	38016.0
2011-04-26 08:30:00	MSFT	Stock	25.76	25.79	25.72	25.79	17418.0
2011-04-26 09:00:00	MSFT	Stock	25.78	25.79	25.76	25.77	55145.0
2011-04-26 09:30:00	MSFT	Stock	25.74	25.97	25.67	25.92	7078034.0
2011-04-26 10:00:00	MSFT	Stock	25.92	26.05	25.87	26.034	6594998.0
2011-04-26 10:30:00	MSFT	Stock	26.035	26.23	26.03	26.18	6774428.0
2011-04-26 11:00:00	MSFT	Stock	26.175	26.245	26.15	26.24	5013364.0
2011-04-26 11:30:00	MSFT	Stock	26.24	26.34	26.19	26.34	7059988.0
2011-04-26 12:00:00	MSFT	Stock	26.335	26.44	26.31	26.328	4216965.0
2011-04-26 12:30:00	MSFT	Stock	26.32	26.33	26.26	26.28	2757436.0
2011-04-26 13:00:00	MSFT	Stock	26.28	26.28	26.16	26.185	2902099.0
2011-04-26 13:30:00	MSFT	Stock	26.18	26.21	26.13	26.165	3067373.0
2011-04-26 14:00:00	MSFT	Stock	26.17	26.28	26.16	26.215	3607891.0
2011-04-26 14:30:00	MSFT	Stock	26.215	26.25	26.17	26.24	2661888.0
2011-04-26 15:00:00	MSFT	Stock	26.235	26.35	26.23	26.285	3872730.0

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

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