PREVIEW / stock_30min / 2012-06-14

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-14.parquet
  size:    1.4 MB
  rows:    75,163
  symbols: 3,515

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
2012-06-14 04:00:00	AAPL	Stock	20.4996	20.4996	20.4996	20.4996	2800.0
2012-06-14 04:30:00	AAPL	Stock	20.4464	20.4464	20.4464	20.4464	5460.0
2012-06-14 05:00:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	5600.0
2012-06-14 06:00:00	AAPL	Stock	20.4286	20.4454	20.4286	20.4454	14420.0
2012-06-14 07:00:00	AAPL	Stock	20.4643	20.4746	20.4429	20.4429	124516.0
2012-06-14 07:30:00	AAPL	Stock	20.4464	20.4464	20.4036	20.4161	63280.0
2012-06-14 08:00:00	AAPL	Stock	20.4289	20.4325	20.375	20.4107	334040.0
2012-06-14 08:30:00	AAPL	Stock	20.4054	20.4568	20.375	20.4518	774368.0
2012-06-14 09:00:00	AAPL	Stock	20.4461	20.4525	20.4	20.4	766948.0
2012-06-14 09:30:00	AAPL	Stock	20.4018	20.4643	20.3046	20.4421	48177388.0
2012-06-14 10:00:00	AAPL	Stock	20.4343	20.4525	20.3293	20.36	27317836.0
2012-06-14 10:30:00	AAPL	Stock	20.3607	20.4464	20.3289	20.4375	23341136.0
2012-06-14 11:00:00	AAPL	Stock	20.4332	20.4821	20.4004	20.4611	20972168.0
2012-06-14 11:30:00	AAPL	Stock	20.4568	20.4757	20.42	20.4232	16733864.0
2012-06-14 12:00:00	AAPL	Stock	20.4268	20.4532	20.4143	20.4379	9570316.0
2012-06-14 12:30:00	AAPL	Stock	20.4376	20.4679	20.4171	20.4536	10463460.0
2012-06-14 13:00:00	AAPL	Stock	20.4529	20.4571	20.3729	20.3904	18719372.0
2012-06-14 13:30:00	AAPL	Stock	20.3896	20.4018	20.3443	20.3818	13463100.0
2012-06-14 14:00:00	AAPL	Stock	20.3804	20.3993	20.325	20.3336	11748688.0
2012-06-14 14:30:00	AAPL	Stock	20.3286	20.3586	20.2596	20.2654	24128216.0
2012-06-14 15:00:00	AAPL	Stock	20.2646	20.4389	20.2593	20.3443	56916972.0
2012-06-14 15:30:00	AAPL	Stock	20.3443	20.4546	20.3325	20.4111	47454232.0
2012-06-14 16:00:00	AAPL	Stock	20.4209	20.4271	20.3795	20.4179	11853912.0
2012-06-14 16:30:00	AAPL	Stock	20.4146	20.4275	20.3525	20.4232	348712.0
2012-06-14 17:00:00	AAPL	Stock	20.4268	20.4321	20.4118	20.4118	171276.0
2012-06-14 17:30:00	AAPL	Stock	20.4243	20.4286	20.4243	20.4279	77672.0
2012-06-14 18:00:00	AAPL	Stock	20.4232	20.4286	20.4232	20.4282	160720.0
2012-06-14 18:30:00	AAPL	Stock	20.4286	20.4325	20.4286	20.4286	88144.0
2012-06-14 19:00:00	AAPL	Stock	20.4286	20.4314	20.4243	20.4243	57960.0
2012-06-14 19:30:00	AAPL	Stock	20.4246	20.4271	20.4136	20.4271	121940.0
2012-06-14 07:30:00	MSFT	Stock	29.17	29.17	29.17	29.17	1000.0
2012-06-14 08:00:00	MSFT	Stock	29.23	29.23	29.01	29.09	8165.0
2012-06-14 08:30:00	MSFT	Stock	29.05	29.18	29.03	29.18	8499.0
2012-06-14 09:00:00	MSFT	Stock	29.2	29.36	29.15	29.32	159897.0
2012-06-14 09:30:00	MSFT	Stock	29.32	29.33	28.88	29.05	5028773.0
2012-06-14 10:00:00	MSFT	Stock	29.04	29.13	29.02	29.1	3925359.0
2012-06-14 10:30:00	MSFT	Stock	29.1	29.32	29.07	29.29	3052273.0
2012-06-14 11:00:00	MSFT	Stock	29.295	29.39	29.26	29.38	2253663.0
2012-06-14 11:30:00	MSFT	Stock	29.38	29.39	29.28	29.31	1831827.0
2012-06-14 12:00:00	MSFT	Stock	29.32	29.325	29.23	29.27	1512594.0
2012-06-14 12:30:00	MSFT	Stock	29.275	29.35	29.25	29.3	1281894.0
2012-06-14 13:00:00	MSFT	Stock	29.3	29.33	29.22	29.23	1408170.0
2012-06-14 13:30:00	MSFT	Stock	29.22	29.37	29.21	29.29	1726397.0
2012-06-14 14:00:00	MSFT	Stock	29.29	29.31	29.14	29.14	1418026.0
2012-06-14 14:30:00	MSFT	Stock	29.15	29.18	29.09	29.1	1395883.0
2012-06-14 15:00:00	MSFT	Stock	29.1	29.46	29.09	29.215	5685850.0
2012-06-14 15:30:00	MSFT	Stock	29.215	29.39	29.21	29.33	5293597.0
2012-06-14 16:00:00	MSFT	Stock	29.315	29.4	29.149	29.34	3141688.0
2012-06-14 16:30:00	MSFT	Stock	29.34	29.4	29.202	29.4	50034.0
2012-06-14 17:30:00	MSFT	Stock	29.39	29.39	29.39	29.39	200.0

> showing 50 of 75,163 rows — these rows as CSV

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