PREVIEW / stock_30min / 2012-06-21

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-21.parquet
  size:    1.4 MB
  rows:    75,790
  symbols: 3,491

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
2012-06-21 04:00:00	AAPL	Stock	20.8571	20.8571	20.8393	20.8393	30800.0
2012-06-21 07:00:00	AAPL	Stock	20.8929	20.8929	20.8925	20.8929	25620.0
2012-06-21 07:30:00	AAPL	Stock	20.9196	20.9375	20.9111	20.9125	58800.0
2012-06-21 08:00:00	AAPL	Stock	20.9125	20.9268	20.8932	20.8932	231056.0
2012-06-21 08:30:00	AAPL	Stock	20.8968	20.9221	20.8857	20.8929	175756.0
2012-06-21 09:00:00	AAPL	Stock	20.8929	20.9361	20.8736	20.915	631708.0
2012-06-21 09:30:00	AAPL	Stock	20.9086	20.9925	20.8771	20.9273	32196976.0
2012-06-21 10:00:00	AAPL	Stock	20.9293	20.9536	20.8643	20.925	26112604.0
2012-06-21 10:30:00	AAPL	Stock	20.9221	21.0079	20.9086	20.9943	24639244.0
2012-06-21 11:00:00	AAPL	Stock	20.9932	20.9996	20.9	20.9065	23157904.0
2012-06-21 11:30:00	AAPL	Stock	20.9125	20.9125	20.8689	20.8889	20222440.0
2012-06-21 12:00:00	AAPL	Stock	20.8883	20.9007	20.8018	20.8146	19557244.0
2012-06-21 12:30:00	AAPL	Stock	20.8132	20.8511	20.7954	20.8279	15016148.0
2012-06-21 13:00:00	AAPL	Stock	20.8286	20.8704	20.8007	20.8071	14762216.0
2012-06-21 13:30:00	AAPL	Stock	20.8071	20.8329	20.7736	20.8212	15626828.0
2012-06-21 14:00:00	AAPL	Stock	20.8205	20.8318	20.7275	20.7557	22145340.0
2012-06-21 14:30:00	AAPL	Stock	20.7556	20.7921	20.7464	20.7846	18125968.0
2012-06-21 15:00:00	AAPL	Stock	20.7811	20.7822	20.6868	20.7075	26461344.0
2012-06-21 15:30:00	AAPL	Stock	20.7096	20.7096	20.6229	20.6286	51317056.0
2012-06-21 16:00:00	AAPL	Stock	20.63	20.9262	20.6254	20.63	8272572.0
2012-06-21 16:30:00	AAPL	Stock	20.6389	20.9442	20.63	20.6429	867944.0
2012-06-21 17:00:00	AAPL	Stock	20.6429	20.6518	20.63	20.6518	194376.0
2012-06-21 17:30:00	AAPL	Stock	20.6575	20.6768	20.6529	20.67	136976.0
2012-06-21 18:00:00	AAPL	Stock	20.6607	20.6714	20.6607	20.6714	89124.0
2012-06-21 18:30:00	AAPL	Stock	20.6682	20.6682	20.6643	20.6671	29456.0
2012-06-21 19:00:00	AAPL	Stock	20.6607	20.67	20.6504	20.6618	33180.0
2012-06-21 19:30:00	AAPL	Stock	20.6671	20.6789	20.6654	20.6789	115892.0
2012-06-21 07:00:00	MSFT	Stock	30.9	30.98	30.9	30.98	200.0
2012-06-21 07:30:00	MSFT	Stock	31.0	31.0	31.0	31.0	5200.0
2012-06-21 08:00:00	MSFT	Stock	30.94	30.98	30.87	30.9	10304.0
2012-06-21 08:30:00	MSFT	Stock	30.92	30.96	30.92	30.93	8300.0
2012-06-21 09:00:00	MSFT	Stock	30.94	31.02	30.87	30.97	93467.0
2012-06-21 09:30:00	MSFT	Stock	30.98	31.14	30.87	30.89	4873822.0
2012-06-21 10:00:00	MSFT	Stock	30.885	30.99	30.65	30.842	5368695.0
2012-06-21 10:30:00	MSFT	Stock	30.845	30.955	30.83	30.895	3154854.0
2012-06-21 11:00:00	MSFT	Stock	30.9	30.93	30.7	30.737	2844381.0
2012-06-21 11:30:00	MSFT	Stock	30.73	30.74	30.62	30.675	2525293.0
2012-06-21 12:00:00	MSFT	Stock	30.67	30.69	30.39	30.4	2728071.0
2012-06-21 12:30:00	MSFT	Stock	30.403	30.545	30.403	30.46	2229563.0
2012-06-21 13:00:00	MSFT	Stock	30.46	30.51	30.4	30.436	1858186.0
2012-06-21 13:30:00	MSFT	Stock	30.43	30.475	30.35	30.435	1732820.0
2012-06-21 14:00:00	MSFT	Stock	30.43	30.438	30.27	30.33	1969390.0
2012-06-21 14:30:00	MSFT	Stock	30.32	30.38	30.29	30.307	1996309.0
2012-06-21 15:00:00	MSFT	Stock	30.3	30.32	30.17	30.195	4207185.0
2012-06-21 15:30:00	MSFT	Stock	30.195	30.245	30.06	30.135	9275006.0
2012-06-21 16:00:00	MSFT	Stock	30.145	30.536	30.125	30.135	2394558.0
2012-06-21 16:30:00	MSFT	Stock	30.15	30.295	30.124	30.2	206491.0
2012-06-21 17:00:00	MSFT	Stock	30.135	30.18	30.135	30.18	23335.0
2012-06-21 17:30:00	MSFT	Stock	30.16	30.18	30.15	30.18	4467.0
2012-06-21 18:00:00	MSFT	Stock	30.19	30.22	30.18	30.18	4025.0

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

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