PREVIEW / stock_30min / 2008-01-17

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-17.parquet
  size:    1.2 MB
  rows:    70,357
  symbols: 3,283

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-01-17 05:30:00	AAPL	Stock	5.75	5.7718	5.75	5.7718	34524.0
2008-01-17 06:00:00	AAPL	Stock	5.775	5.775	5.75	5.75	30800.0
2008-01-17 06:30:00	AAPL	Stock	5.7729	5.7732	5.7536	5.7589	234920.0
2008-01-17 07:00:00	AAPL	Stock	5.7589	5.7589	5.7164	5.7321	1161076.0
2008-01-17 07:30:00	AAPL	Stock	5.7318	5.7429	5.7118	5.7389	819784.0
2008-01-17 08:00:00	AAPL	Stock	5.7389	5.7389	5.6986	5.7039	6285496.0
2008-01-17 08:30:00	AAPL	Stock	5.7039	5.8068	5.7018	5.7939	9148048.0
2008-01-17 09:00:00	AAPL	Stock	5.7925	5.7986	5.7704	5.7704	7939036.0
2008-01-17 09:30:00	AAPL	Stock	5.7682	5.9918	5.74	5.8318	194715360.0
2008-01-17 10:00:00	AAPL	Stock	5.8318	5.9918	5.7232	5.7689	186559548.0
2008-01-17 10:30:00	AAPL	Stock	5.7689	5.7857	5.6579	5.7407	201176080.0
2008-01-17 11:00:00	AAPL	Stock	5.7396	5.8167	5.7393	5.7682	103984356.0
2008-01-17 11:30:00	AAPL	Stock	5.7696	5.79	5.7075	5.7239	85879584.0
2008-01-17 12:00:00	AAPL	Stock	5.7239	5.7646	5.6611	5.755	107484160.0
2008-01-17 12:30:00	AAPL	Stock	5.7554	5.8104	5.7329	5.7712	89565196.0
2008-01-17 13:00:00	AAPL	Stock	5.7714	5.7904	5.6875	5.7846	106799476.0
2008-01-17 13:30:00	AAPL	Stock	5.7843	5.8311	5.7361	5.7711	114962512.0
2008-01-17 14:00:00	AAPL	Stock	5.7711	5.7875	5.7082	5.7282	98908768.0
2008-01-17 14:30:00	AAPL	Stock	5.7282	5.7654	5.7143	5.7321	114694664.0
2008-01-17 15:00:00	AAPL	Stock	5.7321	5.7707	5.6914	5.695	134087100.0
2008-01-17 15:30:00	AAPL	Stock	5.6954	5.7511	5.6743	5.73	162672188.0
2008-01-17 16:00:00	AAPL	Stock	5.7125	5.765	5.7029	5.7443	20848016.0
2008-01-17 16:30:00	AAPL	Stock	5.7429	5.7964	5.7068	5.7925	5683692.0
2008-01-17 17:00:00	AAPL	Stock	5.7911	5.8143	5.7911	5.7993	1237152.0
2008-01-17 17:30:00	AAPL	Stock	5.7029	5.7996	5.7029	5.795	2910096.0
2008-01-17 18:00:00	AAPL	Stock	5.7943	5.8036	5.7857	5.8	806232.0
2008-01-17 18:30:00	AAPL	Stock	5.8043	5.8043	5.7932	5.7946	467908.0
2008-01-17 19:00:00	AAPL	Stock	5.7964	5.8036	5.7946	5.7964	173824.0
2008-01-17 19:30:00	AAPL	Stock	5.8011	5.8125	5.8	5.8125	595084.0
2008-01-17 06:30:00	MSFT	Stock	33.51	33.51	33.51	33.51	2500.0
2008-01-17 07:00:00	MSFT	Stock	33.51	33.77	33.41	33.41	88200.0
2008-01-17 07:30:00	MSFT	Stock	33.41	33.53	33.37	33.5	62100.0
2008-01-17 08:00:00	MSFT	Stock	33.51	33.51	33.35	33.4	65048.0
2008-01-17 08:30:00	MSFT	Stock	33.4	33.8	33.4	33.78	169922.0
2008-01-17 09:00:00	MSFT	Stock	33.75	33.78	33.52	33.73	169955.0
2008-01-17 09:30:00	MSFT	Stock	33.73	33.8	33.46	33.73	9484973.0
2008-01-17 10:00:00	MSFT	Stock	33.73	33.76	33.2	33.23	12287488.0
2008-01-17 10:30:00	MSFT	Stock	33.23	33.39	33.06	33.34	8077350.0
2008-01-17 11:00:00	MSFT	Stock	33.35	33.5	33.28	33.4	3982458.0
2008-01-17 11:30:00	MSFT	Stock	33.39	33.47	33.17	33.21	4325551.0
2008-01-17 12:00:00	MSFT	Stock	33.21	33.31	33.05	33.3	5408091.0
2008-01-17 12:30:00	MSFT	Stock	33.3	33.54	33.29	33.4	4454275.0
2008-01-17 13:00:00	MSFT	Stock	33.4	33.47	33.25	33.39	4892689.0
2008-01-17 13:30:00	MSFT	Stock	33.4	33.5	33.29	33.34	4281389.0
2008-01-17 14:00:00	MSFT	Stock	33.34	33.37	33.16	33.17	5647506.0
2008-01-17 14:30:00	MSFT	Stock	33.18	33.38	33.11	33.3	5810439.0
2008-01-17 15:00:00	MSFT	Stock	33.3	33.42	33.21	33.21	6665506.0
2008-01-17 15:30:00	MSFT	Stock	33.21	33.29	32.97	33.03	13104772.0
2008-01-17 16:00:00	MSFT	Stock	33.02	33.4	32.99	33.236	5479751.0
2008-01-17 16:30:00	MSFT	Stock	33.15	33.3	33.01	33.11	251298.0

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

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