PREVIEW / stock_30min / 2010-01-21

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-21.parquet
  size:    1.4 MB
  rows:    74,085
  symbols: 3,437

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-01-21 04:30:00	AAPL	Stock	7.5714	7.5714	7.5714	7.5714	2800.0
2010-01-21 05:00:00	AAPL	Stock	7.5618	7.5618	7.5618	7.5618	5600.0
2010-01-21 06:30:00	AAPL	Stock	7.5679	7.5679	7.5679	7.5679	5600.0
2010-01-21 07:00:00	AAPL	Stock	7.5918	7.5918	7.5821	7.5821	90160.0
2010-01-21 07:30:00	AAPL	Stock	7.5921	7.6036	7.5893	7.5918	151060.0
2010-01-21 08:00:00	AAPL	Stock	7.6032	7.6032	7.5611	7.5614	5437740.0
2010-01-21 08:30:00	AAPL	Stock	7.5696	7.5696	7.5404	7.5536	1300264.0
2010-01-21 09:00:00	AAPL	Stock	7.5529	7.5771	7.5486	7.5768	705768.0
2010-01-21 09:30:00	AAPL	Stock	7.5743	7.6184	7.5082	7.5468	78445584.0
2010-01-21 10:00:00	AAPL	Stock	7.5471	7.5725	7.4821	7.4839	57331148.0
2010-01-21 10:30:00	AAPL	Stock	7.4846	7.4882	7.4357	7.4557	63355992.0
2010-01-21 11:00:00	AAPL	Stock	7.4561	7.4657	7.4259	7.4361	40180532.0
2010-01-21 11:30:00	AAPL	Stock	7.4361	7.4643	7.4011	7.4411	42957600.0
2010-01-21 12:00:00	AAPL	Stock	7.4418	7.4561	7.4107	7.4193	30440172.0
2010-01-21 12:30:00	AAPL	Stock	7.4149	7.4343	7.4093	7.4141	25372200.0
2010-01-21 13:00:00	AAPL	Stock	7.415	7.4432	7.4004	7.4431	28759808.0
2010-01-21 13:30:00	AAPL	Stock	7.4436	7.4554	7.4361	7.4536	22148224.0
2010-01-21 14:00:00	AAPL	Stock	7.4532	7.4871	7.4364	7.4768	31564176.0
2010-01-21 14:30:00	AAPL	Stock	7.4768	7.4929	7.4457	7.4509	33839624.0
2010-01-21 15:00:00	AAPL	Stock	7.4511	7.4557	7.4107	7.4389	47095748.0
2010-01-21 15:30:00	AAPL	Stock	7.4391	7.4646	7.4225	7.4371	81783044.0
2010-01-21 16:00:00	AAPL	Stock	7.4382	7.4682	7.375	7.3857	10466344.0
2010-01-21 16:30:00	AAPL	Stock	7.3857	7.468	7.3768	7.3889	1136856.0
2010-01-21 17:00:00	AAPL	Stock	7.3929	7.3964	7.3857	7.3907	264432.0
2010-01-21 17:30:00	AAPL	Stock	7.3896	7.4064	7.3879	7.4	243068.0
2010-01-21 18:00:00	AAPL	Stock	7.4043	7.4311	7.3893	7.3946	325444.0
2010-01-21 18:30:00	AAPL	Stock	7.3982	7.4107	7.3946	7.4071	72828.0
2010-01-21 19:00:00	AAPL	Stock	7.4096	7.4107	7.4046	7.4054	76160.0
2010-01-21 19:30:00	AAPL	Stock	7.4025	7.4071	7.3946	7.4018	258300.0
2010-01-21 20:00:00	AAPL	Stock	7.5971	7.5971	7.5971	7.5971	262472.0
2010-01-21 05:30:00	MSFT	Stock	30.35	30.35	30.32	30.32	1000.0
2010-01-21 07:00:00	MSFT	Stock	30.51	30.61	30.51	30.61	4600.0
2010-01-21 07:30:00	MSFT	Stock	30.61	30.62	30.61	30.62	1144.0
2010-01-21 08:00:00	MSFT	Stock	30.6	30.6	30.53	30.54	8822.0
2010-01-21 08:30:00	MSFT	Stock	30.54	30.58	30.46	30.58	8694.0
2010-01-21 09:00:00	MSFT	Stock	30.58	30.66	30.55	30.61	6150.0
2010-01-21 09:30:00	MSFT	Stock	30.59	30.72	30.52	30.56	5699012.0
2010-01-21 10:00:00	MSFT	Stock	30.56	30.71	30.2	30.22	5664882.0
2010-01-21 10:30:00	MSFT	Stock	30.22	30.28	30.12	30.162	5849573.0
2010-01-21 11:00:00	MSFT	Stock	30.17	30.22	30.05	30.14	5356721.0
2010-01-21 11:30:00	MSFT	Stock	30.15	30.24	30.0	30.08	5917163.0
2010-01-21 12:00:00	MSFT	Stock	30.08	30.24	30.01	30.03	3729329.0
2010-01-21 12:30:00	MSFT	Stock	30.02	30.11	30.0	30.05	3091884.0
2010-01-21 13:00:00	MSFT	Stock	30.05	30.17	30.04	30.14	4180431.0
2010-01-21 13:30:00	MSFT	Stock	30.14	30.292	30.13	30.17	3641748.0
2010-01-21 14:00:00	MSFT	Stock	30.16	30.21	30.06	30.18	3766646.0
2010-01-21 14:30:00	MSFT	Stock	30.182	30.21	30.07	30.14	4257965.0
2010-01-21 15:00:00	MSFT	Stock	30.14	30.16	30.03	30.13	4951268.0
2010-01-21 15:30:00	MSFT	Stock	30.14	30.16	30.0	30.06	9698896.0
2010-01-21 16:00:00	MSFT	Stock	30.06	30.35	29.92	29.97	5796146.0

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

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