PREVIEW / stock_30min / 2009-02-05

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-05.parquet
  size:    1.2 MB
  rows:    66,318
  symbols: 3,312

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-02-05 07:30:00	AAPL	Stock	3.3125	3.3164	3.3107	3.3164	30800.0
2009-02-05 08:00:00	AAPL	Stock	3.3243	3.3293	3.3079	3.3179	281120.0
2009-02-05 08:30:00	AAPL	Stock	3.3161	3.3307	3.3071	3.3161	917308.0
2009-02-05 09:00:00	AAPL	Stock	3.3186	3.3214	3.3075	3.315	805140.0
2009-02-05 09:30:00	AAPL	Stock	3.315	3.3514	3.3079	3.3432	73871224.0
2009-02-05 10:00:00	AAPL	Stock	3.3432	3.3825	3.3343	3.3711	66805844.0
2009-02-05 10:30:00	AAPL	Stock	3.3704	3.4314	3.3657	3.4179	67126360.0
2009-02-05 11:00:00	AAPL	Stock	3.4186	3.4286	3.3996	3.4204	45738392.0
2009-02-05 11:30:00	AAPL	Stock	3.4196	3.4357	3.4186	3.4357	50866816.0
2009-02-05 12:00:00	AAPL	Stock	3.435	3.4529	3.4236	3.4246	51100616.0
2009-02-05 12:30:00	AAPL	Stock	3.4243	3.4314	3.4093	3.4236	38867836.0
2009-02-05 13:00:00	AAPL	Stock	3.4236	3.4493	3.4225	3.4364	45497200.0
2009-02-05 13:30:00	AAPL	Stock	3.4364	3.4518	3.4339	3.4364	34688052.0
2009-02-05 14:00:00	AAPL	Stock	3.4361	3.4571	3.435	3.4554	39180624.0
2009-02-05 14:30:00	AAPL	Stock	3.4554	3.4732	3.4461	3.4486	56656656.0
2009-02-05 15:00:00	AAPL	Stock	3.4486	3.4532	3.425	3.4479	63067284.0
2009-02-05 15:30:00	AAPL	Stock	3.4471	3.4557	3.4318	3.4439	77334040.0
2009-02-05 16:00:00	AAPL	Stock	3.4479	3.4571	3.4177	3.443	17723748.0
2009-02-05 16:30:00	AAPL	Stock	3.4496	3.4532	3.4493	3.4493	183960.0
2009-02-05 17:00:00	AAPL	Stock	3.4471	3.4532	3.4471	3.4532	46088.0
2009-02-05 17:30:00	AAPL	Stock	3.4507	3.4554	3.4507	3.4518	82600.0
2009-02-05 18:00:00	AAPL	Stock	3.4518	3.4554	3.445	3.4518	14544208.0
2009-02-05 19:00:00	AAPL	Stock	3.45	3.4521	3.45	3.4521	38248.0
2009-02-05 19:30:00	AAPL	Stock	3.4521	3.4625	3.4518	3.4518	130200.0
2009-02-05 07:00:00	MSFT	Stock	18.55	18.55	18.55	18.55	9500.0
2009-02-05 07:30:00	MSFT	Stock	18.55	18.55	18.45	18.49	15900.0
2009-02-05 08:00:00	MSFT	Stock	18.63	18.63	18.5	18.58	84546.0
2009-02-05 08:30:00	MSFT	Stock	18.55	18.57	18.41	18.5	39288.0
2009-02-05 09:00:00	MSFT	Stock	18.53	18.55	18.45	18.51	70787.0
2009-02-05 09:30:00	MSFT	Stock	18.51	18.52	18.26	18.3	6455335.0
2009-02-05 10:00:00	MSFT	Stock	18.3	18.49	18.25	18.431	5693693.0
2009-02-05 10:30:00	MSFT	Stock	18.435	18.99	18.43	18.88	7094527.0
2009-02-05 11:00:00	MSFT	Stock	18.88	19.0	18.85	18.9	4997583.0
2009-02-05 11:30:00	MSFT	Stock	18.91	18.99	18.86	18.97	3243289.0
2009-02-05 12:00:00	MSFT	Stock	18.97	19.1	18.95	18.955	5141329.0
2009-02-05 12:30:00	MSFT	Stock	18.95	19.0	18.88	18.974	4054488.0
2009-02-05 13:00:00	MSFT	Stock	18.97	19.04	18.82	18.87	3149191.0
2009-02-05 13:30:00	MSFT	Stock	18.88	19.0	18.85	18.94	2897835.0
2009-02-05 14:00:00	MSFT	Stock	18.95	19.1	18.93	19.1	3666188.0
2009-02-05 14:30:00	MSFT	Stock	19.1	19.14	18.92	18.95	4801959.0
2009-02-05 15:00:00	MSFT	Stock	18.951	19.0	18.82	18.97	4837854.0
2009-02-05 15:30:00	MSFT	Stock	18.98	19.05	18.86	19.05	10324036.0
2009-02-05 16:00:00	MSFT	Stock	19.04	19.1	18.831	18.959	5646566.0
2009-02-05 16:30:00	MSFT	Stock	19.04	19.06	18.99	19.06	322334.0
2009-02-05 17:00:00	MSFT	Stock	19.06	19.06	19.06	19.06	3651.0
2009-02-05 17:30:00	MSFT	Stock	19.03	19.03	18.99	18.99	1249.0
2009-02-05 18:00:00	MSFT	Stock	19.02	19.04	18.99	19.04	32358.0
2009-02-05 18:30:00	MSFT	Stock	19.0	19.0	19.0	19.0	200.0
2009-02-05 19:00:00	MSFT	Stock	18.97	18.97	18.97	18.97	1636.0
2009-02-05 19:30:00	MSFT	Stock	18.98	18.98	18.98	18.98	936.0

> showing 50 of 66,318 rows — these rows as CSV

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