PREVIEW / stock_30min / 2009-04-02

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-02.parquet
  size:    1.3 MB
  rows:    73,401
  symbols: 3,334

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-04-02 04:30:00	AAPL	Stock	3.9321	3.9321	3.9321	3.9321	2800.0
2009-04-02 05:00:00	AAPL	Stock	3.9321	3.9696	3.9321	3.9696	20048.0
2009-04-02 05:30:00	AAPL	Stock	3.9779	3.9796	3.9779	3.9796	16100.0
2009-04-02 06:00:00	AAPL	Stock	3.9582	3.9589	3.9582	3.9589	12600.0
2009-04-02 06:30:00	AAPL	Stock	3.965	3.9821	3.9646	3.9646	11200.0
2009-04-02 07:00:00	AAPL	Stock	3.9646	3.9646	3.9643	3.9643	8400.0
2009-04-02 07:30:00	AAPL	Stock	3.9546	3.9546	3.9371	3.9371	79520.0
2009-04-02 08:00:00	AAPL	Stock	3.9411	3.9518	3.8818	3.9446	2838724.0
2009-04-02 08:30:00	AAPL	Stock	3.9439	3.9464	3.93	3.9375	1117396.0
2009-04-02 09:00:00	AAPL	Stock	3.9364	3.95	3.9289	3.9289	1311492.0
2009-04-02 09:30:00	AAPL	Stock	3.9336	3.9732	3.9207	3.9732	89045684.0
2009-04-02 10:00:00	AAPL	Stock	3.9732	4.0014	3.9694	3.9851	69096916.0
2009-04-02 10:30:00	AAPL	Stock	3.9846	4.0171	3.9821	4.0154	68539800.0
2009-04-02 11:00:00	AAPL	Stock	4.0157	4.0475	4.0136	4.0379	57638056.0
2009-04-02 11:30:00	AAPL	Stock	4.0375	4.0536	4.0268	4.0489	47322240.0
2009-04-02 12:00:00	AAPL	Stock	4.0496	4.0982	4.0421	4.0918	60173344.0
2009-04-02 12:30:00	AAPL	Stock	4.0921	4.0936	4.0646	4.0668	50803004.0
2009-04-02 13:00:00	AAPL	Stock	4.0668	4.0675	4.0382	4.0593	55719160.0
2009-04-02 13:30:00	AAPL	Stock	4.0593	4.0668	4.0296	4.0469	48793668.0
2009-04-02 14:00:00	AAPL	Stock	4.0467	4.0668	4.0411	4.0657	27794200.0
2009-04-02 14:30:00	AAPL	Stock	4.0661	4.0761	4.0486	4.0557	44098992.0
2009-04-02 15:00:00	AAPL	Stock	4.0561	4.0671	4.0446	4.0536	45089968.0
2009-04-02 15:30:00	AAPL	Stock	4.0532	4.0607	3.995	4.025	98675080.0
2009-04-02 16:00:00	AAPL	Stock	4.025	4.1357	4.0052	4.1286	22024632.0
2009-04-02 16:30:00	AAPL	Stock	4.1254	4.1411	4.0361	4.1182	8029784.0
2009-04-02 17:00:00	AAPL	Stock	4.1193	4.1232	4.1093	4.1121	746032.0
2009-04-02 17:30:00	AAPL	Stock	4.1129	4.115	4.1071	4.1125	483616.0
2009-04-02 18:00:00	AAPL	Stock	4.1125	4.1161	4.1079	4.1079	1466108.0
2009-04-02 18:30:00	AAPL	Stock	4.1082	4.1118	4.1075	4.1079	140812.0
2009-04-02 19:00:00	AAPL	Stock	4.1079	4.1104	4.1071	4.1082	92064.0
2009-04-02 19:30:00	AAPL	Stock	4.1089	4.1118	4.1079	4.1089	209664.0
2009-04-02 05:00:00	MSFT	Stock	19.4	19.4	19.4	19.4	2000.0
2009-04-02 06:00:00	MSFT	Stock	19.58	19.59	19.58	19.58	2600.0
2009-04-02 06:30:00	MSFT	Stock	19.66	19.66	19.66	19.66	900.0
2009-04-02 07:00:00	MSFT	Stock	19.66	19.68	19.66	19.66	2558.0
2009-04-02 07:30:00	MSFT	Stock	19.64	19.64	19.64	19.64	2000.0
2009-04-02 08:00:00	MSFT	Stock	19.6	19.6	19.31	19.5	622604.0
2009-04-02 08:30:00	MSFT	Stock	19.48	19.59	19.44	19.5	100535.0
2009-04-02 09:00:00	MSFT	Stock	19.51	19.56	19.41	19.52	176505.0
2009-04-02 09:30:00	MSFT	Stock	19.53	19.77	19.38	19.67	11928501.0
2009-04-02 10:00:00	MSFT	Stock	19.66	19.88	19.658	19.782	8698897.0
2009-04-02 10:30:00	MSFT	Stock	19.79	19.83	19.66	19.73	8141185.0
2009-04-02 11:00:00	MSFT	Stock	19.72	19.81	19.67	19.702	6363380.0
2009-04-02 11:30:00	MSFT	Stock	19.702	19.71	19.57	19.66	5055581.0
2009-04-02 12:00:00	MSFT	Stock	19.66	19.86	19.65	19.832	3616221.0
2009-04-02 12:30:00	MSFT	Stock	19.84	19.89	19.63	19.63	4631047.0
2009-04-02 13:00:00	MSFT	Stock	19.63	19.67	19.5	19.538	5798538.0
2009-04-02 13:30:00	MSFT	Stock	19.536	19.59	19.3	19.38	8709127.0
2009-04-02 14:00:00	MSFT	Stock	19.37	19.5	19.36	19.5	4083535.0
2009-04-02 14:30:00	MSFT	Stock	19.5	19.55	19.39	19.41	4529093.0

> showing 50 of 73,401 rows — these rows as CSV

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