PREVIEW / stock_30min / 2013-03-25

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-25.parquet
  size:    1.5 MB
  rows:    77,696
  symbols: 3,481

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
2013-03-25 04:00:00	AAPL	Stock	16.6071	16.6429	16.5943	16.6429	25116.0
2013-03-25 04:30:00	AAPL	Stock	16.5857	16.5857	16.5857	16.5857	2800.0
2013-03-25 05:00:00	AAPL	Stock	16.6071	16.6071	16.6071	16.6071	36400.0
2013-03-25 05:30:00	AAPL	Stock	16.6746	16.675	16.6746	16.675	15316.0
2013-03-25 06:00:00	AAPL	Stock	16.675	16.6786	16.6429	16.6429	77924.0
2013-03-25 06:30:00	AAPL	Stock	16.6429	16.6518	16.5468	16.6171	223076.0
2013-03-25 07:00:00	AAPL	Stock	16.5946	16.6054	16.5579	16.59	388584.0
2013-03-25 07:30:00	AAPL	Stock	16.5921	16.6518	16.5921	16.6389	1134616.0
2013-03-25 08:00:00	AAPL	Stock	16.6386	16.6429	16.4286	16.6407	1547280.0
2013-03-25 08:30:00	AAPL	Stock	16.6411	16.6414	16.5536	16.5571	2647848.0
2013-03-25 09:00:00	AAPL	Stock	16.5621	16.6029	16.5321	16.5929	3625832.0
2013-03-25 09:30:00	AAPL	Stock	16.5918	16.7429	16.5718	16.7184	89645920.0
2013-03-25 10:00:00	AAPL	Stock	16.7189	16.7839	16.6975	16.7214	52977428.0
2013-03-25 10:30:00	AAPL	Stock	16.7225	16.7318	16.615	16.6536	44853620.0
2013-03-25 11:00:00	AAPL	Stock	16.6582	16.6589	16.5168	16.5759	47402376.0
2013-03-25 11:30:00	AAPL	Stock	16.5764	16.6568	16.5736	16.6036	29943172.0
2013-03-25 12:00:00	AAPL	Stock	16.5987	16.6229	16.5179	16.5429	27541892.0
2013-03-25 12:30:00	AAPL	Stock	16.5404	16.5843	16.5225	16.5261	14782376.0
2013-03-25 13:00:00	AAPL	Stock	16.5243	16.5968	16.495	16.5909	24407376.0
2013-03-25 13:30:00	AAPL	Stock	16.5896	16.6711	16.5566	16.65	25188156.0
2013-03-25 14:00:00	AAPL	Stock	16.6511	16.6814	16.6004	16.6021	22740256.0
2013-03-25 14:30:00	AAPL	Stock	16.6036	16.6304	16.5786	16.6088	17858624.0
2013-03-25 15:00:00	AAPL	Stock	16.6104	16.6136	16.4921	16.5286	34005860.0
2013-03-25 15:30:00	AAPL	Stock	16.525	16.5893	16.5	16.5546	41230644.0
2013-03-25 16:00:00	AAPL	Stock	16.5564	16.6223	16.5548	16.5693	9559536.0
2013-03-25 16:30:00	AAPL	Stock	16.565	16.6982	16.5246	16.5704	431116.0
2013-03-25 17:00:00	AAPL	Stock	16.5704	16.5711	16.5536	16.5657	426860.0
2013-03-25 17:30:00	AAPL	Stock	16.5582	16.5582	16.5439	16.5439	311864.0
2013-03-25 18:00:00	AAPL	Stock	16.5471	16.5536	16.5329	16.5536	108052.0
2013-03-25 18:30:00	AAPL	Stock	16.5386	16.545	16.5207	16.5339	210644.0
2013-03-25 19:00:00	AAPL	Stock	16.5282	16.5386	16.525	16.5386	105000.0
2013-03-25 19:30:00	AAPL	Stock	16.5321	16.5429	16.5232	16.5232	417396.0
2013-03-25 08:00:00	MSFT	Stock	28.2	28.35	28.2	28.34	6471.0
2013-03-25 08:30:00	MSFT	Stock	28.32	28.32	28.32	28.32	400.0
2013-03-25 09:00:00	MSFT	Stock	28.31	28.35	28.31	28.35	9223.0
2013-03-25 09:30:00	MSFT	Stock	28.3	28.35	28.2	28.265	2541297.0
2013-03-25 10:00:00	MSFT	Stock	28.26	28.28	28.11	28.15	2105039.0
2013-03-25 10:30:00	MSFT	Stock	28.145	28.18	28.08	28.09	2508243.0
2013-03-25 11:00:00	MSFT	Stock	28.1	28.1	27.96	28.057	4599525.0
2013-03-25 11:30:00	MSFT	Stock	28.055	28.13	28.035	28.105	2557942.0
2013-03-25 12:00:00	MSFT	Stock	28.1	28.12	28.05	28.06	1904797.0
2013-03-25 12:30:00	MSFT	Stock	28.06	28.13	28.05	28.08	2922543.0
2013-03-25 13:00:00	MSFT	Stock	28.08	28.16	28.04	28.114	3515578.0
2013-03-25 13:30:00	MSFT	Stock	28.11	28.3	28.09	28.235	4654760.0
2013-03-25 14:00:00	MSFT	Stock	28.236	28.25	28.18	28.188	1378244.0
2013-03-25 14:30:00	MSFT	Stock	28.18	28.19	28.132	28.162	1425930.0
2013-03-25 15:00:00	MSFT	Stock	28.17	28.18	28.095	28.11	2167947.0
2013-03-25 15:30:00	MSFT	Stock	28.115	28.19	28.08	28.16	4643499.0
2013-03-25 16:00:00	MSFT	Stock	28.17	28.19	28.1	28.16	6366967.0
2013-03-25 16:30:00	MSFT	Stock	28.16	28.22	28.16	28.22	502932.0

> showing 50 of 77,696 rows — these rows as CSV

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