PREVIEW / stock_30min / 2009-10-02

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-10-02.parquet
  size:    1.4 MB
  rows:    74,813
  symbols: 3,385

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
2009-10-02 04:00:00	AAPL	Stock	6.535	6.535	6.535	6.535	2800.0
2009-10-02 05:00:00	AAPL	Stock	6.5107	6.5107	6.5107	6.5107	28000.0
2009-10-02 05:30:00	AAPL	Stock	6.5146	6.5146	6.5125	6.5125	139720.0
2009-10-02 06:00:00	AAPL	Stock	6.5114	6.5268	6.5114	6.5179	128800.0
2009-10-02 06:30:00	AAPL	Stock	6.5229	6.5232	6.5179	6.5179	16800.0
2009-10-02 07:00:00	AAPL	Stock	6.5304	6.5325	6.5089	6.5179	195020.0
2009-10-02 07:30:00	AAPL	Stock	6.5104	6.5321	6.5	6.5268	907424.0
2009-10-02 08:00:00	AAPL	Stock	6.5232	6.5261	6.5018	6.5168	4099144.0
2009-10-02 08:30:00	AAPL	Stock	6.5168	6.5168	6.4421	6.4479	9544388.0
2009-10-02 09:00:00	AAPL	Stock	6.4429	6.4964	6.4429	6.4821	5087936.0
2009-10-02 09:30:00	AAPL	Stock	6.4786	6.5625	6.4768	6.5402	106652112.0
2009-10-02 10:00:00	AAPL	Stock	6.5404	6.6125	6.5321	6.6025	79919196.0
2009-10-02 10:30:00	AAPL	Stock	6.6025	6.625	6.5907	6.6036	52988488.0
2009-10-02 11:00:00	AAPL	Stock	6.6032	6.6096	6.5918	6.5982	24059448.0
2009-10-02 11:30:00	AAPL	Stock	6.598	6.6125	6.5879	6.6004	32119388.0
2009-10-02 12:00:00	AAPL	Stock	6.5996	6.6325	6.5971	6.6317	32006632.0
2009-10-02 12:30:00	AAPL	Stock	6.6311	6.6386	6.6036	6.6157	26200244.0
2009-10-02 13:00:00	AAPL	Stock	6.6146	6.6225	6.6054	6.6211	16029020.0
2009-10-02 13:30:00	AAPL	Stock	6.6214	6.625	6.6071	6.6161	17349388.0
2009-10-02 14:00:00	AAPL	Stock	6.6161	6.6279	6.6043	6.6264	18921308.0
2009-10-02 14:30:00	AAPL	Stock	6.6264	6.6375	6.6202	6.6329	22207556.0
2009-10-02 15:00:00	AAPL	Stock	6.6339	6.6407	6.62	6.6204	26589164.0
2009-10-02 15:30:00	AAPL	Stock	6.6204	6.6339	6.6021	6.6036	46121796.0
2009-10-02 16:00:00	AAPL	Stock	6.6036	6.622	6.5904	6.6143	28816844.0
2009-10-02 16:30:00	AAPL	Stock	6.6143	6.6179	6.6029	6.6143	372736.0
2009-10-02 17:00:00	AAPL	Stock	6.6161	6.6179	6.6146	6.6179	57092.0
2009-10-02 17:30:00	AAPL	Stock	6.6164	6.6225	6.6164	6.6214	65128.0
2009-10-02 18:00:00	AAPL	Stock	6.6036	6.6179	6.6036	6.6107	580664.0
2009-10-02 18:30:00	AAPL	Stock	6.6089	6.6143	6.6089	6.6132	19964.0
2009-10-02 19:00:00	AAPL	Stock	6.6114	6.6132	6.6114	6.6132	42000.0
2009-10-02 19:30:00	AAPL	Stock	6.6132	6.6139	6.6071	6.6139	51268.0
2009-10-02 08:00:00	MSFT	Stock	24.89	24.89	24.75	24.75	5207.0
2009-10-02 08:30:00	MSFT	Stock	24.75	24.75	24.55	24.57	55330.0
2009-10-02 09:00:00	MSFT	Stock	24.56	24.56	24.38	24.47	203980.0
2009-10-02 09:30:00	MSFT	Stock	24.47	24.88	24.43	24.71	8535440.0
2009-10-02 10:00:00	MSFT	Stock	24.71	24.85	24.65	24.83	4439704.0
2009-10-02 10:30:00	MSFT	Stock	24.83	24.88	24.75	24.76	3785340.0
2009-10-02 11:00:00	MSFT	Stock	24.76	24.8	24.71	24.742	2720283.0
2009-10-02 11:30:00	MSFT	Stock	24.745	24.862	24.72	24.85	3563622.0
2009-10-02 12:00:00	MSFT	Stock	24.86	24.92	24.83	24.88	2330498.0
2009-10-02 12:30:00	MSFT	Stock	24.88	24.89	24.79	24.88	2219876.0
2009-10-02 13:00:00	MSFT	Stock	24.876	24.95	24.86	24.94	1767687.0
2009-10-02 13:30:00	MSFT	Stock	24.94	24.95	24.88	24.92	1701844.0
2009-10-02 14:00:00	MSFT	Stock	24.92	25.0	24.85	25.0	2177348.0
2009-10-02 14:30:00	MSFT	Stock	25.0	25.07	24.96	25.02	2635265.0
2009-10-02 15:00:00	MSFT	Stock	25.02	25.09	24.97	25.0	3629714.0
2009-10-02 15:30:00	MSFT	Stock	25.01	25.04	24.92	24.95	7787046.0
2009-10-02 16:00:00	MSFT	Stock	24.95	25.06	24.856	25.03	1795400.0
2009-10-02 16:30:00	MSFT	Stock	25.03	25.03	24.935	25.0	54572.0
2009-10-02 17:30:00	MSFT	Stock	25.05	25.05	25.04	25.04	2970.0

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

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