PREVIEW / stock_30min / 2008-05-21

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-21.parquet
  size:    1.3 MB
  rows:    69,194
  symbols: 3,309

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-05-21 05:30:00	AAPL	Stock	6.64	6.64	6.64	6.64	2800.0
2008-05-21 06:00:00	AAPL	Stock	6.6393	6.6393	6.6393	6.6393	2800.0
2008-05-21 07:30:00	AAPL	Stock	6.6182	6.6182	6.5929	6.6071	99120.0
2008-05-21 08:00:00	AAPL	Stock	6.6193	6.6318	6.6071	6.6304	888608.0
2008-05-21 08:30:00	AAPL	Stock	6.6304	6.6318	6.6171	6.6239	809620.0
2008-05-21 09:00:00	AAPL	Stock	6.6236	6.6321	6.6214	6.6296	1060164.0
2008-05-21 09:30:00	AAPL	Stock	6.6311	6.7125	6.6264	6.6854	101216024.0
2008-05-21 10:00:00	AAPL	Stock	6.6861	6.7107	6.6189	6.625	87542112.0
2008-05-21 10:30:00	AAPL	Stock	6.6257	6.6261	6.5714	6.5918	74494728.0
2008-05-21 11:00:00	AAPL	Stock	6.5914	6.6107	6.5661	6.6011	55483232.0
2008-05-21 11:30:00	AAPL	Stock	6.6018	6.6036	6.5446	6.5725	56005516.0
2008-05-21 12:00:00	AAPL	Stock	6.5721	6.5761	6.5393	6.5707	38066784.0
2008-05-21 12:30:00	AAPL	Stock	6.5707	6.6021	6.5564	6.5982	37183132.0
2008-05-21 13:00:00	AAPL	Stock	6.5986	6.6057	6.5268	6.5371	42502404.0
2008-05-21 13:30:00	AAPL	Stock	6.5371	6.5554	6.5036	6.5079	54638332.0
2008-05-21 14:00:00	AAPL	Stock	6.5082	6.5089	6.3289	6.4061	207574248.0
2008-05-21 14:30:00	AAPL	Stock	6.4064	6.4175	6.3482	6.415	116424532.0
2008-05-21 15:00:00	AAPL	Stock	6.4161	6.4246	6.3664	6.3821	94204740.0
2008-05-21 15:30:00	AAPL	Stock	6.3821	6.7143	6.2946	6.3671	156490152.0
2008-05-21 16:00:00	AAPL	Stock	6.3639	6.6393	6.3639	6.3771	17388000.0
2008-05-21 16:30:00	AAPL	Stock	6.3771	6.6393	6.3714	6.3768	1425032.0
2008-05-21 17:00:00	AAPL	Stock	6.3771	6.3782	6.3721	6.3768	238392.0
2008-05-21 17:30:00	AAPL	Stock	6.375	6.375	6.3686	6.3686	263116.0
2008-05-21 18:00:00	AAPL	Stock	6.3696	6.3746	6.3639	6.3639	194292.0
2008-05-21 18:30:00	AAPL	Stock	6.3732	6.3746	6.37	6.3714	143388.0
2008-05-21 19:00:00	AAPL	Stock	6.37	6.3718	6.3679	6.3689	187488.0
2008-05-21 19:30:00	AAPL	Stock	6.3714	6.3807	6.3711	6.3757	191688.0
2008-05-21 05:30:00	MSFT	Stock	29.01	29.01	29.01	29.01	1000.0
2008-05-21 07:00:00	MSFT	Stock	29.07	29.07	29.07	29.07	260.0
2008-05-21 07:30:00	MSFT	Stock	29.07	29.07	28.9	28.9	5500.0
2008-05-21 08:00:00	MSFT	Stock	28.85	28.96	28.8	28.96	27038.0
2008-05-21 08:30:00	MSFT	Stock	28.94	28.95	28.76	28.9	820153.0
2008-05-21 09:00:00	MSFT	Stock	28.95	28.95	28.8	28.84	13400.0
2008-05-21 09:30:00	MSFT	Stock	28.82	29.05	28.65	28.78	5829012.0
2008-05-21 10:00:00	MSFT	Stock	28.77	28.88	28.67	28.78	4353511.0
2008-05-21 10:30:00	MSFT	Stock	28.79	28.9	28.68	28.78	3711425.0
2008-05-21 11:00:00	MSFT	Stock	28.78	28.88	28.71	28.79	2086412.0
2008-05-21 11:30:00	MSFT	Stock	28.79	28.85	28.76	28.78	1854657.0
2008-05-21 12:00:00	MSFT	Stock	28.775	28.85	28.76	28.833	1667641.0
2008-05-21 12:30:00	MSFT	Stock	28.84	28.95	28.78	28.94	2057780.0
2008-05-21 13:00:00	MSFT	Stock	28.948	28.95	28.71	28.73	3209638.0
2008-05-21 13:30:00	MSFT	Stock	28.72	28.78	28.62	28.68	4282247.0
2008-05-21 14:00:00	MSFT	Stock	28.68	28.68	28.36	28.41	7077882.0
2008-05-21 14:30:00	MSFT	Stock	28.41	28.438	28.27	28.38	5666969.0
2008-05-21 15:00:00	MSFT	Stock	28.39	28.44	28.3	28.39	4773416.0
2008-05-21 15:30:00	MSFT	Stock	28.39	28.41	28.19	28.23	8676217.0
2008-05-21 16:00:00	MSFT	Stock	28.26	28.76	28.24	28.35	2358682.0
2008-05-21 16:30:00	MSFT	Stock	28.37	28.76	28.25	28.39	388288.0
2008-05-21 17:00:00	MSFT	Stock	28.37	28.39	28.31	28.35	8358.0
2008-05-21 17:30:00	MSFT	Stock	28.35	28.38	28.33	28.38	6267.0

> showing 50 of 69,194 rows — these rows as CSV

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