PREVIEW / stock_30min / 2008-06-05

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-05.parquet
  size:    1.3 MB
  rows:    68,758
  symbols: 3,298

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-06-05 06:00:00	AAPL	Stock	6.6293	6.6293	6.6293	6.6293	2800.0
2008-06-05 06:30:00	AAPL	Stock	6.6189	6.6189	6.6189	6.6189	2800.0
2008-06-05 07:00:00	AAPL	Stock	6.6161	6.6311	6.6161	6.6304	8400.0
2008-06-05 07:30:00	AAPL	Stock	6.6379	6.7229	6.6379	6.6879	184380.0
2008-06-05 08:00:00	AAPL	Stock	6.6661	6.6721	6.6543	6.6582	1056580.0
2008-06-05 08:30:00	AAPL	Stock	6.66	6.6836	6.66	6.6661	2673412.0
2008-06-05 09:00:00	AAPL	Stock	6.6664	6.6682	6.6511	6.6536	1421056.0
2008-06-05 09:30:00	AAPL	Stock	6.6536	6.7036	6.6321	6.6932	91144032.0
2008-06-05 10:00:00	AAPL	Stock	6.6932	6.6946	6.6686	6.6786	59698828.0
2008-06-05 10:30:00	AAPL	Stock	6.6789	6.7011	6.6743	6.6938	56051380.0
2008-06-05 11:00:00	AAPL	Stock	6.6939	6.7189	6.6914	6.7129	55565496.0
2008-06-05 11:30:00	AAPL	Stock	6.7125	6.7457	6.7086	6.7382	54372528.0
2008-06-05 12:00:00	AAPL	Stock	6.7386	6.75	6.7332	6.7479	41587168.0
2008-06-05 12:30:00	AAPL	Stock	6.7479	6.755	6.7143	6.7266	44650900.0
2008-06-05 13:00:00	AAPL	Stock	6.7257	6.7389	6.7157	6.7279	28105364.0
2008-06-05 13:30:00	AAPL	Stock	6.7268	6.7457	6.725	6.7425	31719576.0
2008-06-05 14:00:00	AAPL	Stock	6.7425	6.7557	6.7054	6.7107	70442008.0
2008-06-05 14:30:00	AAPL	Stock	6.7096	6.7436	6.7029	6.7375	49413588.0
2008-06-05 15:00:00	AAPL	Stock	6.7375	6.7714	6.7339	6.7575	65910152.0
2008-06-05 15:30:00	AAPL	Stock	6.7575	6.78	6.7479	6.7632	74549580.0
2008-06-05 16:00:00	AAPL	Stock	6.7607	6.7689	6.7206	6.7643	11119472.0
2008-06-05 16:30:00	AAPL	Stock	6.7643	6.7696	6.7643	6.7657	330848.0
2008-06-05 17:00:00	AAPL	Stock	6.7657	6.7707	6.6139	6.7707	1854944.0
2008-06-05 17:30:00	AAPL	Stock	6.7654	6.7818	6.7654	6.7814	705432.0
2008-06-05 18:00:00	AAPL	Stock	6.7793	6.7821	6.7786	6.7821	472444.0
2008-06-05 18:30:00	AAPL	Stock	6.7814	6.7825	6.7786	6.7786	197204.0
2008-06-05 19:00:00	AAPL	Stock	6.7789	6.7818	6.7786	6.78	97412.0
2008-06-05 19:30:00	AAPL	Stock	6.7818	6.7832	6.7786	6.7832	324800.0
2008-06-05 07:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	400.0
2008-06-05 08:00:00	MSFT	Stock	27.68	27.75	27.65	27.71	26979.0
2008-06-05 08:30:00	MSFT	Stock	27.71	27.8	27.7	27.75	78967.0
2008-06-05 09:00:00	MSFT	Stock	27.77	27.78	27.69	27.71	86949.0
2008-06-05 09:30:00	MSFT	Stock	27.73	28.02	27.6	28.01	10113515.0
2008-06-05 10:00:00	MSFT	Stock	28.002	28.3	28.0	28.23	12500305.0
2008-06-05 10:30:00	MSFT	Stock	28.23	28.26	28.07	28.1	5544151.0
2008-06-05 11:00:00	MSFT	Stock	28.092	28.15	28.03	28.1	3360836.0
2008-06-05 11:30:00	MSFT	Stock	28.1	28.13	28.06	28.08	3864770.0
2008-06-05 12:00:00	MSFT	Stock	28.08	28.21	28.02	28.165	5283654.0
2008-06-05 12:30:00	MSFT	Stock	28.16	28.21	28.11	28.152	2519321.0
2008-06-05 13:00:00	MSFT	Stock	28.16	28.18	28.04	28.082	2801599.0
2008-06-05 13:30:00	MSFT	Stock	28.08	28.11	28.03	28.06	2200013.0
2008-06-05 14:00:00	MSFT	Stock	28.055	28.08	27.98	28.015	4383398.0
2008-06-05 14:30:00	MSFT	Stock	28.02	28.14	27.98	28.138	3425136.0
2008-06-05 15:00:00	MSFT	Stock	28.13	28.23	28.1	28.19	3944228.0
2008-06-05 15:30:00	MSFT	Stock	28.18	28.3	28.13	28.21	8992341.0
2008-06-05 16:00:00	MSFT	Stock	28.2	28.31	27.54	28.3	5187675.0
2008-06-05 16:30:00	MSFT	Stock	28.081	28.31	28.081	28.25	122475.0
2008-06-05 17:00:00	MSFT	Stock	28.24	28.24	28.23	28.23	6000.0
2008-06-05 17:30:00	MSFT	Stock	28.3	28.3	28.23	28.26	18371.0
2008-06-05 18:00:00	MSFT	Stock	28.28	28.3	28.27	28.3	15271.0

> showing 50 of 68,758 rows — these rows as CSV

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