PREVIEW / stock_30min / 2010-03-17

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-17.parquet
  size:    1.4 MB
  rows:    73,592
  symbols: 3,473

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
2010-03-17 04:30:00	AAPL	Stock	8.0221	8.025	8.0221	8.025	16800.0
2010-03-17 05:00:00	AAPL	Stock	8.0214	8.0339	8.0211	8.0339	67200.0
2010-03-17 07:00:00	AAPL	Stock	8.0357	8.0389	8.0357	8.0389	21784.0
2010-03-17 07:30:00	AAPL	Stock	8.0357	8.0357	8.0304	8.0321	18620.0
2010-03-17 08:00:00	AAPL	Stock	8.0329	8.0357	8.0143	8.0264	705852.0
2010-03-17 08:30:00	AAPL	Stock	8.0261	8.0304	8.0232	8.0289	527212.0
2010-03-17 09:00:00	AAPL	Stock	8.0321	8.0425	8.0218	8.0311	1132516.0
2010-03-17 09:30:00	AAPL	Stock	8.0339	8.0875	8.0243	8.0768	68772508.0
2010-03-17 10:00:00	AAPL	Stock	8.0775	8.0832	8.0604	8.0693	35243992.0
2010-03-17 10:30:00	AAPL	Stock	8.0693	8.075	8.0596	8.0725	20791344.0
2010-03-17 11:00:00	AAPL	Stock	8.0725	8.075	8.0607	8.0679	19753412.0
2010-03-17 11:30:00	AAPL	Stock	8.0689	8.0721	8.0646	8.0689	12105800.0
2010-03-17 12:00:00	AAPL	Stock	8.0696	8.0739	8.0668	8.0689	13208020.0
2010-03-17 12:30:00	AAPL	Stock	8.0693	8.0696	8.0604	8.0675	12335792.0
2010-03-17 13:00:00	AAPL	Stock	8.0675	8.0679	8.0579	8.0629	10371368.0
2010-03-17 13:30:00	AAPL	Stock	8.0646	8.0704	8.0418	8.0521	22413160.0
2010-03-17 14:00:00	AAPL	Stock	8.0525	8.0536	8.0314	8.0332	23190916.0
2010-03-17 14:30:00	AAPL	Stock	8.0336	8.0339	7.9814	7.9839	61745208.0
2010-03-17 15:00:00	AAPL	Stock	7.985	8.0071	7.9739	7.9959	40957504.0
2010-03-17 15:30:00	AAPL	Stock	7.9961	8.0107	7.9739	8.0025	46225116.0
2010-03-17 16:00:00	AAPL	Stock	8.0029	8.0707	7.9975	8.0046	7185220.0
2010-03-17 16:30:00	AAPL	Stock	7.9961	8.0054	7.9961	7.9982	136528.0
2010-03-17 17:00:00	AAPL	Stock	7.9982	8.0018	7.9982	8.0014	189140.0
2010-03-17 17:30:00	AAPL	Stock	8.0014	8.0036	7.9943	7.9964	257124.0
2010-03-17 18:00:00	AAPL	Stock	8.0018	8.0043	7.9948	7.9948	55916.0
2010-03-17 18:30:00	AAPL	Stock	7.9968	8.0029	7.9961	8.0029	67172.0
2010-03-17 19:00:00	AAPL	Stock	8.0	8.0036	7.9968	8.0	70616.0
2010-03-17 19:30:00	AAPL	Stock	8.0029	8.0079	8.0	8.0079	438256.0
2010-03-17 07:00:00	MSFT	Stock	29.5	29.5	29.45	29.45	600.0
2010-03-17 07:30:00	MSFT	Stock	29.47	29.47	29.46	29.46	300.0
2010-03-17 08:00:00	MSFT	Stock	29.41	29.45	29.39	29.45	15300.0
2010-03-17 08:30:00	MSFT	Stock	29.45	29.45	29.44	29.45	8115.0
2010-03-17 09:00:00	MSFT	Stock	29.45	29.5	29.41	29.5	39053.0
2010-03-17 09:30:00	MSFT	Stock	29.5	29.69	29.4	29.64	6133047.0
2010-03-17 10:00:00	MSFT	Stock	29.638	29.785	29.62	29.76	6019061.0
2010-03-17 10:30:00	MSFT	Stock	29.765	29.77	29.65	29.672	3540538.0
2010-03-17 11:00:00	MSFT	Stock	29.67	29.73	29.6	29.62	3455717.0
2010-03-17 11:30:00	MSFT	Stock	29.63	29.65	29.56	29.62	2995221.0
2010-03-17 12:00:00	MSFT	Stock	29.63	29.72	29.61	29.69	2003007.0
2010-03-17 12:30:00	MSFT	Stock	29.68	29.745	29.67	29.72	1682942.0
2010-03-17 13:00:00	MSFT	Stock	29.72	29.8	29.71	29.76	1880248.0
2010-03-17 13:30:00	MSFT	Stock	29.76	29.87	29.76	29.8	3316467.0
2010-03-17 14:00:00	MSFT	Stock	29.8	29.822	29.71	29.71	3912001.0
2010-03-17 14:30:00	MSFT	Stock	29.715	29.72	29.55	29.58	4873932.0
2010-03-17 15:00:00	MSFT	Stock	29.58	29.62	29.53	29.58	3602232.0
2010-03-17 15:30:00	MSFT	Stock	29.575	29.66	29.54	29.63	4526341.0
2010-03-17 16:00:00	MSFT	Stock	29.64	29.684	29.535	29.62	1036737.0
2010-03-17 16:30:00	MSFT	Stock	29.563	29.63	29.563	29.63	32300.0
2010-03-17 17:00:00	MSFT	Stock	29.37	29.63	29.37	29.63	200.0
2010-03-17 17:30:00	MSFT	Stock	29.63	29.63	29.63	29.63	100.0

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

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