PREVIEW / stock_30min / 2010-05-13

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-13.parquet
  size:    1.4 MB
  rows:    74,108
  symbols: 3,484

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-05-13 05:00:00	AAPL	Stock	9.3261	9.3261	9.3179	9.3179	9800.0
2010-05-13 05:30:00	AAPL	Stock	9.3511	9.3511	9.3179	9.3179	14560.0
2010-05-13 06:00:00	AAPL	Stock	9.3339	9.3589	9.3339	9.3589	8400.0
2010-05-13 07:00:00	AAPL	Stock	9.3564	9.4071	9.3554	9.4071	203000.0
2010-05-13 07:30:00	AAPL	Stock	9.4036	9.4107	9.3929	9.3986	325780.0
2010-05-13 08:00:00	AAPL	Stock	9.3964	9.4446	9.3893	9.4393	2505468.0
2010-05-13 08:30:00	AAPL	Stock	9.4361	9.4368	9.4021	9.4039	2721460.0
2010-05-13 09:00:00	AAPL	Stock	9.4032	9.4032	9.3604	9.3979	1698004.0
2010-05-13 09:30:00	AAPL	Stock	9.3979	9.4571	9.3532	9.442	94431288.0
2010-05-13 10:00:00	AAPL	Stock	9.4421	9.4643	9.4196	9.4536	62404048.0
2010-05-13 10:30:00	AAPL	Stock	9.4511	9.4536	9.4036	9.4114	36127056.0
2010-05-13 11:00:00	AAPL	Stock	9.4121	9.4275	9.3893	9.4118	29117956.0
2010-05-13 11:30:00	AAPL	Stock	9.4129	9.4161	9.3629	9.3717	33884732.0
2010-05-13 12:00:00	AAPL	Stock	9.3718	9.3868	9.3393	9.3643	28827232.0
2010-05-13 12:30:00	AAPL	Stock	9.3646	9.375	9.345	9.3596	19597088.0
2010-05-13 13:00:00	AAPL	Stock	9.3607	9.4107	9.3536	9.3968	25533032.0
2010-05-13 13:30:00	AAPL	Stock	9.3968	9.4089	9.3679	9.375	19317760.0
2010-05-13 14:00:00	AAPL	Stock	9.375	9.4007	9.3618	9.3639	13525848.0
2010-05-13 14:30:00	AAPL	Stock	9.3639	9.3746	9.3321	9.3504	29520036.0
2010-05-13 15:00:00	AAPL	Stock	9.35	9.3643	9.2539	9.2571	62994708.0
2010-05-13 15:30:00	AAPL	Stock	9.2564	9.2754	9.1571	9.2239	126490420.0
2010-05-13 16:00:00	AAPL	Stock	9.2232	9.4059	9.2175	9.2214	7958916.0
2010-05-13 16:30:00	AAPL	Stock	9.2289	9.3604	9.2014	9.2314	579180.0
2010-05-13 17:00:00	AAPL	Stock	9.2325	9.2325	9.2179	9.2214	304780.0
2010-05-13 17:30:00	AAPL	Stock	9.2214	9.23	9.2193	9.2196	125776.0
2010-05-13 18:00:00	AAPL	Stock	9.2196	9.2311	9.2193	9.2311	165984.0
2010-05-13 18:30:00	AAPL	Stock	9.2346	9.2371	9.2321	9.2321	90020.0
2010-05-13 19:00:00	AAPL	Stock	9.2286	9.235	9.2286	9.2339	72968.0
2010-05-13 19:30:00	AAPL	Stock	9.2318	9.2518	9.2318	9.25	439348.0
2010-05-13 08:00:00	MSFT	Stock	29.43	29.43	29.4	29.4	1850.0
2010-05-13 08:30:00	MSFT	Stock	29.38	29.47	29.34	29.34	9080.0
2010-05-13 09:00:00	MSFT	Stock	29.35	29.44	29.29	29.31	16843.0
2010-05-13 09:30:00	MSFT	Stock	29.31	29.67	29.2	29.57	6887309.0
2010-05-13 10:00:00	MSFT	Stock	29.57	29.73	29.48	29.6	4505592.0
2010-05-13 10:30:00	MSFT	Stock	29.6	29.7	29.51	29.62	3567787.0
2010-05-13 11:00:00	MSFT	Stock	29.62	29.65	29.58	29.6	2053720.0
2010-05-13 11:30:00	MSFT	Stock	29.59	29.6	29.42	29.42	1930394.0
2010-05-13 12:00:00	MSFT	Stock	29.42	29.55	29.4	29.53	2035431.0
2010-05-13 12:30:00	MSFT	Stock	29.53	29.56	29.49	29.52	1290303.0
2010-05-13 13:00:00	MSFT	Stock	29.52	29.63	29.48	29.59	1811160.0
2010-05-13 13:30:00	MSFT	Stock	29.6	29.64	29.54	29.55	1921765.0
2010-05-13 14:00:00	MSFT	Stock	29.54	29.615	29.52	29.525	1740703.0
2010-05-13 14:30:00	MSFT	Stock	29.52	29.535	29.4	29.41	2611090.0
2010-05-13 15:00:00	MSFT	Stock	29.42	29.45	29.21	29.31	5501761.0
2010-05-13 15:30:00	MSFT	Stock	29.3	29.39	29.18	29.24	7253903.0
2010-05-13 16:00:00	MSFT	Stock	29.23	29.474	29.2	29.24	1372844.0
2010-05-13 16:30:00	MSFT	Stock	29.313	29.44	29.22	29.44	85845.0
2010-05-13 17:00:00	MSFT	Stock	29.3	29.3	29.3	29.3	100.0
2010-05-13 17:30:00	MSFT	Stock	29.22	29.23	29.22	29.23	397.0
2010-05-13 18:00:00	MSFT	Stock	29.24	29.25	29.24	29.25	11639.0

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

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