PREVIEW / stock_30min / 2009-11-03

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-11-03.parquet
  size:    1.4 MB
  rows:    72,341
  symbols: 3,417

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-11-03 05:00:00	AAPL	Stock	6.715	6.715	6.715	6.715	5600.0
2009-11-03 06:00:00	AAPL	Stock	6.6661	6.6804	6.6607	6.6804	58800.0
2009-11-03 06:30:00	AAPL	Stock	6.6786	6.6839	6.6786	6.6839	11200.0
2009-11-03 07:00:00	AAPL	Stock	6.6786	6.7104	6.6786	6.705	45136.0
2009-11-03 07:30:00	AAPL	Stock	6.7068	6.7068	6.6825	6.6904	82012.0
2009-11-03 08:00:00	AAPL	Stock	6.7	6.7193	6.6896	6.7107	1158332.0
2009-11-03 08:30:00	AAPL	Stock	6.7139	6.7364	6.7018	6.7071	568456.0
2009-11-03 09:00:00	AAPL	Stock	6.7011	6.7143	6.6964	6.7132	1214080.0
2009-11-03 09:30:00	AAPL	Stock	6.7132	6.7411	6.6761	6.7354	70319368.0
2009-11-03 10:00:00	AAPL	Stock	6.7354	6.7686	6.6982	6.7018	57822352.0
2009-11-03 10:30:00	AAPL	Stock	6.7021	6.7404	6.6975	6.7164	29273328.0
2009-11-03 11:00:00	AAPL	Stock	6.7163	6.7318	6.7039	6.7139	21651084.0
2009-11-03 11:30:00	AAPL	Stock	6.7139	6.7193	6.6893	6.7	20729884.0
2009-11-03 12:00:00	AAPL	Stock	6.6996	6.7068	6.64	6.6696	46532192.0
2009-11-03 12:30:00	AAPL	Stock	6.6682	6.7318	6.6675	6.7111	39117820.0
2009-11-03 13:00:00	AAPL	Stock	6.7114	6.7289	6.6975	6.7193	22109052.0
2009-11-03 13:30:00	AAPL	Stock	6.7197	6.7429	6.7096	6.7368	22890448.0
2009-11-03 14:00:00	AAPL	Stock	6.7382	6.7536	6.7318	6.7329	27763680.0
2009-11-03 14:30:00	AAPL	Stock	6.7321	6.7457	6.7025	6.7175	27133204.0
2009-11-03 15:00:00	AAPL	Stock	6.7157	6.7346	6.7079	6.7339	21613424.0
2009-11-03 15:30:00	AAPL	Stock	6.7325	6.7464	6.7218	6.7396	40900412.0
2009-11-03 16:00:00	AAPL	Stock	6.74	6.7475	6.713	6.7425	9959320.0
2009-11-03 16:30:00	AAPL	Stock	6.7436	6.75	6.7429	6.7464	203448.0
2009-11-03 17:00:00	AAPL	Stock	6.7611	6.7611	6.7081	6.7482	32732.0
2009-11-03 17:30:00	AAPL	Stock	6.7432	6.7479	6.7432	6.7457	71932.0
2009-11-03 18:00:00	AAPL	Stock	6.7482	6.7486	6.7411	6.7446	3081120.0
2009-11-03 18:30:00	AAPL	Stock	6.7464	6.7464	6.7414	6.7418	26124.0
2009-11-03 19:00:00	AAPL	Stock	6.7411	6.7514	6.7411	6.7414	44744.0
2009-11-03 19:30:00	AAPL	Stock	6.7496	6.7554	6.7439	6.7554	71456.0
2009-11-03 04:30:00	MSFT	Stock	27.79	27.79	27.79	27.79	100.0
2009-11-03 05:00:00	MSFT	Stock	27.59	27.59	27.59	27.59	100.0
2009-11-03 05:30:00	MSFT	Stock	27.57	27.57	27.49	27.49	300.0
2009-11-03 06:00:00	MSFT	Stock	27.49	27.7	27.49	27.7	5070.0
2009-11-03 06:30:00	MSFT	Stock	27.7	27.7	27.7	27.7	100.0
2009-11-03 07:00:00	MSFT	Stock	27.67	27.67	27.67	27.67	200.0
2009-11-03 07:30:00	MSFT	Stock	27.75	27.75	27.75	27.75	1950.0
2009-11-03 08:00:00	MSFT	Stock	27.61	27.88	27.61	27.88	23347.0
2009-11-03 08:30:00	MSFT	Stock	27.72	27.81	27.69	27.7	8703.0
2009-11-03 09:00:00	MSFT	Stock	27.79	27.79	27.62	27.62	29689.0
2009-11-03 09:30:00	MSFT	Stock	27.64	27.74	27.5	27.61	3978241.0
2009-11-03 10:00:00	MSFT	Stock	27.61	27.655	27.5	27.511	3938082.0
2009-11-03 10:30:00	MSFT	Stock	27.51	27.57	27.45	27.46	3625257.0
2009-11-03 11:00:00	MSFT	Stock	27.46	27.59	27.43	27.49	3744081.0
2009-11-03 11:30:00	MSFT	Stock	27.49	27.54	27.44	27.465	2370943.0
2009-11-03 12:00:00	MSFT	Stock	27.465	27.58	27.44	27.54	2076462.0
2009-11-03 12:30:00	MSFT	Stock	27.54	27.68	27.52	27.56	2897418.0
2009-11-03 13:00:00	MSFT	Stock	27.56	27.63	27.54	27.567	2033691.0
2009-11-03 13:30:00	MSFT	Stock	27.56	27.66	27.55	27.58	2223351.0
2009-11-03 14:00:00	MSFT	Stock	27.57	27.61	27.54	27.58	2269557.0
2009-11-03 14:30:00	MSFT	Stock	27.58	27.62	27.46	27.5	3660095.0

> showing 50 of 72,341 rows — these rows as CSV

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