PREVIEW / stock_30min / 2008-04-10

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-10.parquet
  size:    1.2 MB
  rows:    67,661
  symbols: 3,282

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
2008-04-10 05:00:00	AAPL	Stock	5.4086	5.4086	5.4086	5.4086	11200.0
2008-04-10 05:30:00	AAPL	Stock	5.4104	5.4104	5.4104	5.4104	3220.0
2008-04-10 07:00:00	AAPL	Stock	5.4057	5.4057	5.3939	5.3939	16800.0
2008-04-10 07:30:00	AAPL	Stock	5.4057	5.4296	5.4057	5.4264	75600.0
2008-04-10 08:00:00	AAPL	Stock	5.42	5.42	5.3768	5.3893	1089004.0
2008-04-10 08:30:00	AAPL	Stock	5.3911	5.4071	5.3857	5.3979	1617560.0
2008-04-10 09:00:00	AAPL	Stock	5.3989	5.4225	5.3964	5.3979	2687272.0
2008-04-10 09:30:00	AAPL	Stock	5.3975	5.4518	5.3786	5.4436	117739972.0
2008-04-10 10:00:00	AAPL	Stock	5.4436	5.5032	5.4164	5.4957	119260120.0
2008-04-10 10:30:00	AAPL	Stock	5.4957	5.5164	5.4779	5.505	81164244.0
2008-04-10 11:00:00	AAPL	Stock	5.5046	5.5354	5.4968	5.5168	74382924.0
2008-04-10 11:30:00	AAPL	Stock	5.5168	5.54	5.5036	5.5182	54559288.0
2008-04-10 12:00:00	AAPL	Stock	5.5186	5.5271	5.5079	5.52	36568952.0
2008-04-10 12:30:00	AAPL	Stock	5.5193	5.5339	5.5107	5.5139	32257344.0
2008-04-10 13:00:00	AAPL	Stock	5.514	5.5461	5.5107	5.5402	42887376.0
2008-04-10 13:30:00	AAPL	Stock	5.5404	5.5507	5.53	5.5321	58414580.0
2008-04-10 14:00:00	AAPL	Stock	5.5318	5.5439	5.5182	5.5232	58610720.0
2008-04-10 14:30:00	AAPL	Stock	5.5229	5.5407	5.5118	5.5375	63110376.0
2008-04-10 15:00:00	AAPL	Stock	5.5378	5.5425	5.5161	5.5271	59303888.0
2008-04-10 15:30:00	AAPL	Stock	5.5271	5.5271	5.4929	5.5196	113608600.0
2008-04-10 16:00:00	AAPL	Stock	5.5179	5.5237	5.5	5.5196	31578736.0
2008-04-10 16:30:00	AAPL	Stock	5.5179	5.525	5.5179	5.5243	272720.0
2008-04-10 17:00:00	AAPL	Stock	5.5233	5.5257	5.5196	5.5257	883624.0
2008-04-10 17:30:00	AAPL	Stock	5.5261	5.5282	5.5261	5.5264	99960.0
2008-04-10 18:00:00	AAPL	Stock	5.5268	5.5282	5.5196	5.5282	304948.0
2008-04-10 18:30:00	AAPL	Stock	5.5282	5.53	5.5282	5.5282	63140.0
2008-04-10 19:00:00	AAPL	Stock	5.5282	5.5296	5.5282	5.5293	85120.0
2008-04-10 19:30:00	AAPL	Stock	5.5293	5.5296	5.5271	5.5296	275240.0
2008-04-10 07:00:00	MSFT	Stock	29.12	29.12	29.12	29.12	200.0
2008-04-10 07:30:00	MSFT	Stock	29.0	29.1	29.0	29.0	22185.0
2008-04-10 08:00:00	MSFT	Stock	29.08	29.08	28.91	28.95	102987.0
2008-04-10 08:30:00	MSFT	Stock	28.95	28.95	28.88	28.9	62774.0
2008-04-10 09:00:00	MSFT	Stock	28.9	29.04	28.83	28.83	110755.0
2008-04-10 09:30:00	MSFT	Stock	28.85	29.11	28.8	28.94	6896920.0
2008-04-10 10:00:00	MSFT	Stock	28.94	29.18	28.87	29.12	4966730.0
2008-04-10 10:30:00	MSFT	Stock	29.1	29.34	29.1	29.31	5860498.0
2008-04-10 11:00:00	MSFT	Stock	29.31	29.37	29.26	29.322	3188515.0
2008-04-10 11:30:00	MSFT	Stock	29.33	29.4	29.3	29.33	2651568.0
2008-04-10 12:00:00	MSFT	Stock	29.33	29.38	29.19	29.24	3893679.0
2008-04-10 12:30:00	MSFT	Stock	29.23	29.3	29.15	29.19	2755803.0
2008-04-10 13:00:00	MSFT	Stock	29.19	29.26	29.16	29.223	2063591.0
2008-04-10 13:30:00	MSFT	Stock	29.23	29.29	29.13	29.14	3437542.0
2008-04-10 14:00:00	MSFT	Stock	29.13	29.3	29.12	29.14	3163872.0
2008-04-10 14:30:00	MSFT	Stock	29.13	29.25	29.07	29.21	4443158.0
2008-04-10 15:00:00	MSFT	Stock	29.2	29.24	29.13	29.16	3479875.0
2008-04-10 15:30:00	MSFT	Stock	29.16	29.18	28.95	29.1	9462438.0
2008-04-10 16:00:00	MSFT	Stock	29.1	29.285	29.05	29.15	7471548.0
2008-04-10 16:30:00	MSFT	Stock	29.15	29.16	29.15	29.15	7500.0
2008-04-10 17:00:00	MSFT	Stock	29.15	29.21	29.11	29.21	77600.0
2008-04-10 17:30:00	MSFT	Stock	29.14	29.14	29.14	29.14	3000.0

> showing 50 of 67,661 rows — these rows as CSV

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