PREVIEW / stock_30min / 2011-06-01

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-01.parquet
  size:    1.5 MB
  rows:    78,731
  symbols: 3,564

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
2011-06-01 04:00:00	AAPL	Stock	12.4607	12.4607	12.4607	12.4607	2800.0
2011-06-01 04:30:00	AAPL	Stock	12.4339	12.4339	12.4339	12.4339	2800.0
2011-06-01 05:00:00	AAPL	Stock	12.4286	12.4286	12.4286	12.4286	5600.0
2011-06-01 05:30:00	AAPL	Stock	12.4286	12.4286	12.4054	12.4107	60480.0
2011-06-01 06:30:00	AAPL	Stock	12.4	12.4071	12.3929	12.4036	55888.0
2011-06-01 07:00:00	AAPL	Stock	12.4161	12.4461	12.4107	12.4268	285208.0
2011-06-01 07:30:00	AAPL	Stock	12.4318	12.4318	12.4196	12.425	133280.0
2011-06-01 08:00:00	AAPL	Stock	12.4225	12.4621	12.4139	12.4179	2266712.0
2011-06-01 08:30:00	AAPL	Stock	12.4146	12.4321	12.4086	12.4286	906444.0
2011-06-01 09:00:00	AAPL	Stock	12.4218	12.47	12.4143	12.4596	1931524.0
2011-06-01 09:30:00	AAPL	Stock	12.4643	12.5761	12.4343	12.5414	112065212.0
2011-06-01 10:00:00	AAPL	Stock	12.5414	12.5536	12.4944	12.5093	57053276.0
2011-06-01 10:30:00	AAPL	Stock	12.5082	12.5125	12.4725	12.4843	44233532.0
2011-06-01 11:00:00	AAPL	Stock	12.4846	12.5	12.4189	12.4629	38528924.0
2011-06-01 11:30:00	AAPL	Stock	12.4643	12.4907	12.4539	12.4768	20372408.0
2011-06-01 12:00:00	AAPL	Stock	12.4764	12.485	12.3986	12.4271	28906920.0
2011-06-01 12:30:00	AAPL	Stock	12.426	12.4814	12.4243	12.4661	18434668.0
2011-06-01 13:00:00	AAPL	Stock	12.4657	12.4839	12.4089	12.4196	26050920.0
2011-06-01 13:30:00	AAPL	Stock	12.4207	12.455	12.3986	12.4436	18449928.0
2011-06-01 14:00:00	AAPL	Stock	12.4432	12.4439	12.3957	12.4107	23376500.0
2011-06-01 14:30:00	AAPL	Stock	12.4119	12.4119	12.3107	12.3654	53181436.0
2011-06-01 15:00:00	AAPL	Stock	12.3646	12.3925	12.3277	12.3561	30276148.0
2011-06-01 15:30:00	AAPL	Stock	12.3564	12.3818	12.3089	12.3393	49981764.0
2011-06-01 16:00:00	AAPL	Stock	12.3393	12.4496	12.3179	12.3371	20406764.0
2011-06-01 16:30:00	AAPL	Stock	12.3375	12.3555	12.3368	12.34	386456.0
2011-06-01 17:00:00	AAPL	Stock	12.3443	12.3446	12.3325	12.3325	231000.0
2011-06-01 17:30:00	AAPL	Stock	12.3307	12.3851	12.3307	12.3393	654024.0
2011-06-01 18:00:00	AAPL	Stock	12.3393	12.3396	12.3304	12.3321	79912.0
2011-06-01 18:30:00	AAPL	Stock	12.3321	12.3346	12.3271	12.3271	59612.0
2011-06-01 19:00:00	AAPL	Stock	12.3304	12.3357	12.3304	12.3325	135492.0
2011-06-01 19:30:00	AAPL	Stock	12.3354	12.3682	12.3354	12.3571	450240.0
2011-06-01 07:30:00	MSFT	Stock	25.02	25.04	25.02	25.04	772.0
2011-06-01 08:00:00	MSFT	Stock	25.02	25.04	24.94	24.95	9960.0
2011-06-01 08:30:00	MSFT	Stock	24.95	25.01	24.93	24.93	8060.0
2011-06-01 09:00:00	MSFT	Stock	24.93	25.0	24.93	25.0	16565.0
2011-06-01 09:30:00	MSFT	Stock	24.98	25.1	24.93	24.97	3896475.0
2011-06-01 10:00:00	MSFT	Stock	24.96	24.969	24.8	24.81	3809686.0
2011-06-01 10:30:00	MSFT	Stock	24.805	24.81	24.61	24.67	7196723.0
2011-06-01 11:00:00	MSFT	Stock	24.68	24.68	24.46	24.51	10214201.0
2011-06-01 11:30:00	MSFT	Stock	24.52	24.69	24.44	24.544	10671381.0
2011-06-01 12:00:00	MSFT	Stock	24.55	24.58	24.44	24.55	3930213.0
2011-06-01 12:30:00	MSFT	Stock	24.55	24.58	24.48	24.522	1879384.0
2011-06-01 13:00:00	MSFT	Stock	24.52	24.61	24.5	24.54	2652947.0
2011-06-01 13:30:00	MSFT	Stock	24.539	24.54	24.49	24.53	1160500.0
2011-06-01 14:00:00	MSFT	Stock	24.53	24.55	24.48	24.489	1648322.0
2011-06-01 14:30:00	MSFT	Stock	24.48	24.52	24.42	24.49	3145874.0
2011-06-01 15:00:00	MSFT	Stock	24.488	24.49	24.37	24.436	3952224.0
2011-06-01 15:30:00	MSFT	Stock	24.44	24.46	24.4	24.43	8185949.0
2011-06-01 16:00:00	MSFT	Stock	24.43	24.594	24.41	24.537	10835335.0
2011-06-01 16:30:00	MSFT	Stock	24.42	24.48	24.42	24.47	93827.0

> showing 50 of 78,731 rows — these rows as CSV

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