PREVIEW / stock_30min / 2008-02-01

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-01.parquet
  size:    1.2 MB
  rows:    70,678
  symbols: 3,260

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-02-01 04:00:00	AAPL	Stock	4.8593	4.8593	4.8282	4.8282	37548.0
2008-02-01 04:30:00	AAPL	Stock	4.8568	4.8568	4.8568	4.8568	5600.0
2008-02-01 05:00:00	AAPL	Stock	4.8568	4.8596	4.8568	4.8593	63560.0
2008-02-01 05:30:00	AAPL	Stock	4.8604	4.8611	4.8536	4.8536	25200.0
2008-02-01 06:00:00	AAPL	Stock	4.8543	4.8543	4.8536	4.8536	25200.0
2008-02-01 06:30:00	AAPL	Stock	4.8893	4.9261	4.8893	4.9143	156240.0
2008-02-01 07:00:00	AAPL	Stock	4.9075	4.9107	4.8696	4.8821	724920.0
2008-02-01 07:30:00	AAPL	Stock	4.8804	4.8964	4.875	4.8929	768796.0
2008-02-01 08:00:00	AAPL	Stock	4.8929	4.9107	4.8343	4.9032	3040828.0
2008-02-01 08:30:00	AAPL	Stock	4.9032	4.9036	4.8343	4.8661	6983844.0
2008-02-01 09:00:00	AAPL	Stock	4.8643	4.875	4.8357	4.8671	4514748.0
2008-02-01 09:30:00	AAPL	Stock	4.8671	4.8732	4.7968	4.8221	133369012.0
2008-02-01 10:00:00	AAPL	Stock	4.8214	4.8782	4.8036	4.825	137940348.0
2008-02-01 10:30:00	AAPL	Stock	4.8246	4.8282	4.725	4.7329	124226676.0
2008-02-01 11:00:00	AAPL	Stock	4.7329	4.7668	4.7207	4.7554	80412640.0
2008-02-01 11:30:00	AAPL	Stock	4.7543	4.7911	4.75	4.7887	50307880.0
2008-02-01 12:00:00	AAPL	Stock	4.7889	4.7911	4.7582	4.7704	42802872.0
2008-02-01 12:30:00	AAPL	Stock	4.7711	4.7846	4.7593	4.7711	34336596.0
2008-02-01 13:00:00	AAPL	Stock	4.7711	4.8075	4.77	4.7904	56551404.0
2008-02-01 13:30:00	AAPL	Stock	4.79	4.8025	4.7725	4.7739	46100572.0
2008-02-01 14:00:00	AAPL	Stock	4.7736	4.8036	4.7679	4.7979	54587960.0
2008-02-01 14:30:00	AAPL	Stock	4.7993	4.8143	4.7839	4.79	64895012.0
2008-02-01 15:00:00	AAPL	Stock	4.79	4.7957	4.7704	4.7839	64570660.0
2008-02-01 15:30:00	AAPL	Stock	4.7832	4.7925	4.7631	4.7754	79738316.0
2008-02-01 16:00:00	AAPL	Stock	4.7743	4.7941	4.7707	4.7856	20513416.0
2008-02-01 16:30:00	AAPL	Stock	4.7768	4.7873	4.7743	4.7743	3651620.0
2008-02-01 17:00:00	AAPL	Stock	4.775	4.7827	4.7743	4.7827	125412.0
2008-02-01 17:30:00	AAPL	Stock	4.7786	4.7814	4.7768	4.7807	68712.0
2008-02-01 18:00:00	AAPL	Stock	4.7775	4.7775	4.7682	4.7689	235088.0
2008-02-01 18:30:00	AAPL	Stock	4.7689	4.7743	4.7682	4.7696	77056.0
2008-02-01 19:00:00	AAPL	Stock	4.7696	4.7786	4.7696	4.7782	117712.0
2008-02-01 19:30:00	AAPL	Stock	4.7814	4.7814	4.775	4.7761	136668.0
2008-02-01 05:00:00	MSFT	Stock	32.6	32.6	32.6	32.6	100.0
2008-02-01 05:30:00	MSFT	Stock	32.6	32.6	32.6	32.6	500.0
2008-02-01 06:30:00	MSFT	Stock	31.68	32.7	31.65	31.8	135616.0
2008-02-01 07:00:00	MSFT	Stock	31.79	31.85	30.5	30.55	1090692.0
2008-02-01 07:30:00	MSFT	Stock	30.55	31.05	30.35	30.9	3673585.0
2008-02-01 08:00:00	MSFT	Stock	30.94	31.56	30.287	31.49	6552681.0
2008-02-01 08:30:00	MSFT	Stock	31.5	31.64	30.79	31.31	7823710.0
2008-02-01 09:00:00	MSFT	Stock	31.32	32.54	31.0	31.06	6287734.0
2008-02-01 09:30:00	MSFT	Stock	31.06	33.25	30.82	31.11	55111742.0
2008-02-01 10:00:00	MSFT	Stock	31.1	31.17	30.89	30.968	30366731.0
2008-02-01 10:30:00	MSFT	Stock	30.96	31.03	29.59	30.5	25409762.0
2008-02-01 11:00:00	MSFT	Stock	30.5	31.1	30.48	30.75	18268958.0
2008-02-01 11:30:00	MSFT	Stock	30.75	30.77	30.59	30.65	10657596.0
2008-02-01 12:00:00	MSFT	Stock	30.642	30.65	30.47	30.519	13188177.0
2008-02-01 12:30:00	MSFT	Stock	30.51	30.52	30.25	30.39	16718531.0
2008-02-01 13:00:00	MSFT	Stock	30.39	30.58	30.38	30.49	10294223.0
2008-02-01 13:30:00	MSFT	Stock	30.5	30.55	30.4	30.4	10849080.0
2008-02-01 14:00:00	MSFT	Stock	30.4	30.5	30.36	30.43	8401569.0

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

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