PREVIEW / stock_30min / 2009-04-29

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-29.parquet
  size:    1.3 MB
  rows:    70,358
  symbols: 3,324

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-04-29 07:30:00	AAPL	Stock	4.4636	4.4732	4.4636	4.4732	61544.0
2009-04-29 08:00:00	AAPL	Stock	4.4732	4.4732	4.4571	4.4664	570192.0
2009-04-29 08:30:00	AAPL	Stock	4.4679	4.4761	4.4575	4.4607	1121512.0
2009-04-29 09:00:00	AAPL	Stock	4.4593	4.4643	4.4536	4.46	470792.0
2009-04-29 09:30:00	AAPL	Stock	4.46	4.47	4.4225	4.4632	52694264.0
2009-04-29 10:00:00	AAPL	Stock	4.4625	4.4679	4.4343	4.4621	43685320.0
2009-04-29 10:30:00	AAPL	Stock	4.4621	4.4668	4.4532	4.463	25121516.0
2009-04-29 11:00:00	AAPL	Stock	4.4625	4.4864	4.4436	4.4821	36998444.0
2009-04-29 11:30:00	AAPL	Stock	4.4829	4.4854	4.4732	4.4771	15704220.0
2009-04-29 12:00:00	AAPL	Stock	4.4771	4.4857	4.4664	4.4729	18080580.0
2009-04-29 12:30:00	AAPL	Stock	4.4729	4.4875	4.4668	4.4821	15804852.0
2009-04-29 13:00:00	AAPL	Stock	4.4818	4.4904	4.4789	4.4843	21284172.0
2009-04-29 13:30:00	AAPL	Stock	4.4843	4.4946	4.4768	4.4893	17234784.0
2009-04-29 14:00:00	AAPL	Stock	4.4882	4.4946	4.4695	4.4907	29411228.0
2009-04-29 14:30:00	AAPL	Stock	4.4909	4.5304	4.4846	4.5089	56985320.0
2009-04-29 15:00:00	AAPL	Stock	4.5089	4.5168	4.4895	4.4911	44114476.0
2009-04-29 15:30:00	AAPL	Stock	4.4918	4.4946	4.4543	4.4789	60724300.0
2009-04-29 16:00:00	AAPL	Stock	4.475	4.4821	4.4601	4.4714	12660144.0
2009-04-29 16:30:00	AAPL	Stock	4.4732	4.4768	4.4686	4.4768	242200.0
2009-04-29 17:00:00	AAPL	Stock	4.475	4.4761	4.4643	4.4761	210000.0
2009-04-29 17:30:00	AAPL	Stock	4.47	4.4732	4.4696	4.4732	34860.0
2009-04-29 18:00:00	AAPL	Stock	4.4689	4.4732	4.4689	4.4732	275240.0
2009-04-29 18:30:00	AAPL	Stock	4.4732	4.4757	4.4732	4.4757	28252.0
2009-04-29 19:00:00	AAPL	Stock	4.475	4.4761	4.4736	4.4736	83160.0
2009-04-29 19:30:00	AAPL	Stock	4.4761	4.4768	4.4736	4.4736	30800.0
2009-04-29 06:00:00	MSFT	Stock	20.14	20.2	20.14	20.2	300.0
2009-04-29 06:30:00	MSFT	Stock	20.2	20.2	20.03	20.03	1000.0
2009-04-29 07:00:00	MSFT	Stock	20.23	20.23	20.23	20.23	100.0
2009-04-29 07:30:00	MSFT	Stock	20.23	20.23	20.11	20.15	6300.0
2009-04-29 08:00:00	MSFT	Stock	20.1	20.16	20.03	20.16	41325.0
2009-04-29 08:30:00	MSFT	Stock	20.16	20.16	20.07	20.14	21456.0
2009-04-29 09:00:00	MSFT	Stock	20.14	20.14	20.05	20.08	2600.0
2009-04-29 09:30:00	MSFT	Stock	20.1	20.71	20.06	20.71	10103168.0
2009-04-29 10:00:00	MSFT	Stock	20.7	20.76	20.55	20.74	7359647.0
2009-04-29 10:30:00	MSFT	Stock	20.741	20.89	20.69	20.83	5035911.0
2009-04-29 11:00:00	MSFT	Stock	20.83	20.87	20.73	20.828	3459546.0
2009-04-29 11:30:00	MSFT	Stock	20.83	20.84	20.61	20.62	2302427.0
2009-04-29 12:00:00	MSFT	Stock	20.61	20.64	20.5	20.5	2342206.0
2009-04-29 12:30:00	MSFT	Stock	20.5	20.505	20.27	20.29	6247580.0
2009-04-29 13:00:00	MSFT	Stock	20.29	20.39	20.23	20.35	6017440.0
2009-04-29 13:30:00	MSFT	Stock	20.35	20.36	20.17	20.17	5084969.0
2009-04-29 14:00:00	MSFT	Stock	20.16	20.23	20.09	20.23	5321094.0
2009-04-29 14:30:00	MSFT	Stock	20.223	20.41	20.17	20.27	5697955.0
2009-04-29 15:00:00	MSFT	Stock	20.27	20.3	20.13	20.181	3448544.0
2009-04-29 15:30:00	MSFT	Stock	20.185	20.3	20.1	20.25	9724269.0
2009-04-29 16:00:00	MSFT	Stock	20.23	20.64	20.101	20.318	2418371.0
2009-04-29 16:30:00	MSFT	Stock	20.19	20.25	20.17	20.21	89490.0
2009-04-29 17:00:00	MSFT	Stock	20.2	20.22	20.2	20.22	25219.0
2009-04-29 17:30:00	MSFT	Stock	20.2	20.22	20.18	20.18	5086.0
2009-04-29 18:00:00	MSFT	Stock	20.2	20.321	20.18	20.321	449899.0

> showing 50 of 70,358 rows — these rows as CSV

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