PREVIEW / stock_30min / 2009-05-01

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-01.parquet
  size:    1.3 MB
  rows:    70,808
  symbols: 3,319

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-05-01 05:30:00	AAPL	Stock	4.4964	4.4964	4.4964	4.4964	5600.0
2009-05-01 07:00:00	AAPL	Stock	4.5071	4.5071	4.5071	4.5071	2800.0
2009-05-01 08:00:00	AAPL	Stock	4.5079	4.5193	4.5071	4.5179	615440.0
2009-05-01 08:30:00	AAPL	Stock	4.5121	4.5121	4.4961	4.4964	221844.0
2009-05-01 09:00:00	AAPL	Stock	4.4968	4.4982	4.4886	4.4954	278796.0
2009-05-01 09:30:00	AAPL	Stock	4.4929	4.5357	4.4929	4.5307	55063120.0
2009-05-01 10:00:00	AAPL	Stock	4.5307	4.5382	4.5	4.5075	36342964.0
2009-05-01 10:30:00	AAPL	Stock	4.5086	4.5339	4.4936	4.5257	24933076.0
2009-05-01 11:00:00	AAPL	Stock	4.525	4.5464	4.5196	4.5444	29559544.0
2009-05-01 11:30:00	AAPL	Stock	4.5443	4.5518	4.525	4.5279	24031028.0
2009-05-01 12:00:00	AAPL	Stock	4.5289	4.5589	4.52	4.5475	25928952.0
2009-05-01 12:30:00	AAPL	Stock	4.5471	4.5571	4.5436	4.5557	17569496.0
2009-05-01 13:00:00	AAPL	Stock	4.5557	4.5596	4.5446	4.5561	17258724.0
2009-05-01 13:30:00	AAPL	Stock	4.5575	4.5679	4.5523	4.5664	17868984.0
2009-05-01 14:00:00	AAPL	Stock	4.5671	4.5696	4.5568	4.5575	22614200.0
2009-05-01 14:30:00	AAPL	Stock	4.5568	4.5589	4.5396	4.5411	26836208.0
2009-05-01 15:00:00	AAPL	Stock	4.5414	4.5536	4.5182	4.5232	30622424.0
2009-05-01 15:30:00	AAPL	Stock	4.5232	4.5464	4.5132	4.5429	47683020.0
2009-05-01 16:00:00	AAPL	Stock	4.5432	4.5632	4.4939	4.5443	6693960.0
2009-05-01 16:30:00	AAPL	Stock	4.5443	4.5468	4.5443	4.5464	2205252.0
2009-05-01 17:00:00	AAPL	Stock	4.5482	4.55	4.5464	4.5464	36400.0
2009-05-01 17:30:00	AAPL	Stock	4.5464	4.5464	4.5464	4.5464	22400.0
2009-05-01 18:00:00	AAPL	Stock	4.5464	4.5479	4.545	4.545	44296.0
2009-05-01 18:30:00	AAPL	Stock	4.545	4.5464	4.545	4.5464	30100.0
2009-05-01 19:30:00	AAPL	Stock	4.5446	4.5518	4.5446	4.5518	18760.0
2009-05-01 20:00:00	AAPL	Stock	4.5279	4.5279	4.5279	4.5279	33600.0
2009-05-01 05:30:00	MSFT	Stock	21.1	21.1	21.1	21.1	200.0
2009-05-01 08:00:00	MSFT	Stock	20.35	20.59	20.35	20.45	24500.0
2009-05-01 08:30:00	MSFT	Stock	20.37	20.44	20.37	20.4	1700.0
2009-05-01 09:00:00	MSFT	Stock	20.26	20.42	20.16	20.21	85820.0
2009-05-01 09:30:00	MSFT	Stock	20.22	20.35	19.87	19.99	5833372.0
2009-05-01 10:00:00	MSFT	Stock	19.99	20.055	19.87	19.93	5007516.0
2009-05-01 10:30:00	MSFT	Stock	19.94	19.98	19.9	19.94	3950446.0
2009-05-01 11:00:00	MSFT	Stock	19.94	20.01	19.92	19.948	4281958.0
2009-05-01 11:30:00	MSFT	Stock	19.94	20.0	19.94	19.97	1602624.0
2009-05-01 12:00:00	MSFT	Stock	19.965	20.0	19.94	19.95	1758476.0
2009-05-01 12:30:00	MSFT	Stock	19.95	20.0	19.91	19.96	2596157.0
2009-05-01 13:00:00	MSFT	Stock	19.97	19.98	19.92	19.97	2960174.0
2009-05-01 13:30:00	MSFT	Stock	19.97	20.0	19.93	19.96	3671152.0
2009-05-01 14:00:00	MSFT	Stock	19.95	20.02	19.93	19.96	3837733.0
2009-05-01 14:30:00	MSFT	Stock	19.96	20.05	19.95	20.001	5271001.0
2009-05-01 15:00:00	MSFT	Stock	20.0	20.07	19.95	20.01	6995938.0
2009-05-01 15:30:00	MSFT	Stock	20.0	20.23	19.862	20.22	8867613.0
2009-05-01 16:00:00	MSFT	Stock	20.22	20.25	19.991	20.2	1928572.0
2009-05-01 16:30:00	MSFT	Stock	20.24	20.24	20.18	20.18	2278752.0
2009-05-01 17:00:00	MSFT	Stock	20.18	20.19	20.18	20.18	2771.0
2009-05-01 17:30:00	MSFT	Stock	20.18	20.19	20.18	20.18	2200.0
2009-05-01 18:00:00	MSFT	Stock	20.18	20.19	20.16	20.19	1381.0
2009-05-01 19:00:00	MSFT	Stock	20.18	20.18	20.14	20.14	2200.0
2009-05-01 19:30:00	MSFT	Stock	20.15	20.15	20.12	20.12	1944.0

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

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