PREVIEW / stock_30min / 2008-01-18

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-18.parquet
  size:    1.2 MB
  rows:    70,164
  symbols: 3,274

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-18 05:30:00	AAPL	Stock	5.82	5.82	5.82	5.82	28000.0
2008-01-18 06:30:00	AAPL	Stock	5.8482	5.8482	5.8482	5.8482	2800.0
2008-01-18 07:00:00	AAPL	Stock	5.8211	5.8571	5.8211	5.8571	243152.0
2008-01-18 07:30:00	AAPL	Stock	5.8554	5.8554	5.8179	5.8482	1638000.0
2008-01-18 08:00:00	AAPL	Stock	5.8571	5.8929	5.8321	5.8839	6050660.0
2008-01-18 08:30:00	AAPL	Stock	5.8821	5.8925	5.8607	5.8743	4149768.0
2008-01-18 09:00:00	AAPL	Stock	5.8718	5.8821	5.7979	5.8007	14157584.0
2008-01-18 09:30:00	AAPL	Stock	5.8007	5.875	5.7754	5.8482	261453108.0
2008-01-18 10:00:00	AAPL	Stock	5.8482	5.9196	5.8382	5.9129	173647068.0
2008-01-18 10:30:00	AAPL	Stock	5.9129	5.9154	5.8604	5.8729	100309552.0
2008-01-18 11:00:00	AAPL	Stock	5.8725	5.8804	5.7846	5.8121	155382388.0
2008-01-18 11:30:00	AAPL	Stock	5.8104	5.8893	5.7282	5.7639	138598124.0
2008-01-18 12:00:00	AAPL	Stock	5.765	5.8504	5.7464	5.8468	106738660.0
2008-01-18 12:30:00	AAPL	Stock	5.8468	5.8593	5.8107	5.8175	81433660.0
2008-01-18 13:00:00	AAPL	Stock	5.8175	5.8539	5.7675	5.7814	83741644.0
2008-01-18 13:30:00	AAPL	Stock	5.7818	5.8068	5.7529	5.7818	73232488.0
2008-01-18 14:00:00	AAPL	Stock	5.7814	5.7857	5.7143	5.7179	98276080.0
2008-01-18 14:30:00	AAPL	Stock	5.7182	5.7489	5.7004	5.7471	108518424.0
2008-01-18 15:00:00	AAPL	Stock	5.7471	5.775	5.7225	5.7389	114110304.0
2008-01-18 15:30:00	AAPL	Stock	5.7396	5.7771	5.7179	5.7579	164269084.0
2008-01-18 16:00:00	AAPL	Stock	5.7579	5.8893	5.7469	5.775	29093652.0
2008-01-18 16:30:00	AAPL	Stock	5.7761	5.8893	5.7507	5.7586	2846256.0
2008-01-18 17:00:00	AAPL	Stock	5.7582	5.7679	5.7536	5.7571	1152256.0
2008-01-18 17:30:00	AAPL	Stock	5.7593	5.8839	5.7571	5.7604	6564516.0
2008-01-18 18:00:00	AAPL	Stock	5.7604	5.7625	5.7593	5.7607	204064.0
2008-01-18 18:30:00	AAPL	Stock	5.7607	5.7607	5.7518	5.7571	313936.0
2008-01-18 19:00:00	AAPL	Stock	5.7543	5.7575	5.75	5.75	576436.0
2008-01-18 19:30:00	AAPL	Stock	5.7532	5.7625	5.7518	5.7596	245504.0
2008-01-18 07:00:00	MSFT	Stock	33.6	33.6	33.53	33.53	1500.0
2008-01-18 07:30:00	MSFT	Stock	33.53	33.6	33.43	33.6	1800.0
2008-01-18 08:00:00	MSFT	Stock	33.65	33.65	33.5	33.56	39872.0
2008-01-18 08:30:00	MSFT	Stock	33.56	33.58	33.5	33.51	4140.0
2008-01-18 09:00:00	MSFT	Stock	33.51	33.51	33.05	33.16	997665.0
2008-01-18 09:30:00	MSFT	Stock	33.19	33.45	33.1	33.3	18879287.0
2008-01-18 10:00:00	MSFT	Stock	33.3	33.89	33.293	33.81	9593464.0
2008-01-18 10:30:00	MSFT	Stock	33.81	33.84	33.64	33.78	6463767.0
2008-01-18 11:00:00	MSFT	Stock	33.78	33.89	33.65	33.79	8113693.0
2008-01-18 11:30:00	MSFT	Stock	33.79	34.0	33.2	33.28	9657378.0
2008-01-18 12:00:00	MSFT	Stock	33.27	33.53	33.24	33.46	7201996.0
2008-01-18 12:30:00	MSFT	Stock	33.46	33.52	33.36	33.43	4710397.0
2008-01-18 13:00:00	MSFT	Stock	33.43	33.57	33.06	33.14	5097509.0
2008-01-18 13:30:00	MSFT	Stock	33.14	33.25	33.09	33.16	3943341.0
2008-01-18 14:00:00	MSFT	Stock	33.16	33.4	33.07	33.265	6138908.0
2008-01-18 14:30:00	MSFT	Stock	33.26	33.27	33.11	33.23	6846926.0
2008-01-18 15:00:00	MSFT	Stock	33.23	33.3	33.01	33.03	9042341.0
2008-01-18 15:30:00	MSFT	Stock	33.04	33.19	32.97	33.06	11896918.0
2008-01-18 16:00:00	MSFT	Stock	33.06	33.397	32.98	33.03	6689600.0
2008-01-18 16:30:00	MSFT	Stock	33.01	33.04	33.01	33.01	140795.0
2008-01-18 17:00:00	MSFT	Stock	33.01	33.04	33.01	33.02	7771.0
2008-01-18 17:30:00	MSFT	Stock	33.02	33.04	33.01	33.02	569673.0

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

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