PREVIEW / stock_30min / 2007-11-01

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-01.parquet
  size:    1.3 MB
  rows:    71,630
  symbols: 3,193

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
2007-11-01 04:30:00	AAPL	Stock	6.7757	6.7757	6.7757	6.7757	16800.0
2007-11-01 07:00:00	AAPL	Stock	6.7686	6.7686	6.7646	6.7646	35616.0
2007-11-01 07:30:00	AAPL	Stock	6.7511	6.7636	6.7511	6.7554	203056.0
2007-11-01 08:00:00	AAPL	Stock	6.7554	6.8211	6.7321	6.7411	3388588.0
2007-11-01 08:30:00	AAPL	Stock	6.7443	6.7536	6.7143	6.7243	3245592.0
2007-11-01 09:00:00	AAPL	Stock	6.7271	6.7839	6.7107	6.7321	5212872.0
2007-11-01 09:30:00	AAPL	Stock	6.7321	6.7454	6.7	6.7157	119529760.0
2007-11-01 10:00:00	AAPL	Stock	6.7164	6.7286	6.6643	6.7075	88707976.0
2007-11-01 10:30:00	AAPL	Stock	6.7079	6.7268	6.7029	6.725	49414092.0
2007-11-01 11:00:00	AAPL	Stock	6.7243	6.7404	6.7107	6.7375	45938256.0
2007-11-01 11:30:00	AAPL	Stock	6.7371	6.7375	6.7111	6.72	36215032.0
2007-11-01 12:00:00	AAPL	Stock	6.7193	6.7321	6.7146	6.7175	25236008.0
2007-11-01 12:30:00	AAPL	Stock	6.7175	6.7446	6.7154	6.7404	30219812.0
2007-11-01 13:00:00	AAPL	Stock	6.7411	6.7893	6.7329	6.7696	59491236.0
2007-11-01 13:30:00	AAPL	Stock	6.7693	6.7711	6.7207	6.7325	49492352.0
2007-11-01 14:00:00	AAPL	Stock	6.7307	6.7571	6.7275	6.7382	44623656.0
2007-11-01 14:30:00	AAPL	Stock	6.7386	6.7746	6.7382	6.7686	53591104.0
2007-11-01 15:00:00	AAPL	Stock	6.7689	6.7821	6.7143	6.7325	68110196.0
2007-11-01 15:30:00	AAPL	Stock	6.7325	6.7411	6.4286	6.6978	98423248.0
2007-11-01 16:00:00	AAPL	Stock	6.6979	6.7679	6.6893	6.6964	18433072.0
2007-11-01 16:30:00	AAPL	Stock	6.6964	6.7181	6.6879	6.6964	2598932.0
2007-11-01 17:00:00	AAPL	Stock	6.6943	6.7839	6.6875	6.6893	3360924.0
2007-11-01 17:30:00	AAPL	Stock	6.6893	6.6961	6.6893	6.6946	101640.0
2007-11-01 18:00:00	AAPL	Stock	6.6961	6.7	6.6946	6.7	129220.0
2007-11-01 18:30:00	AAPL	Stock	6.7	6.7	6.6982	6.6993	93240.0
2007-11-01 19:00:00	AAPL	Stock	6.6964	6.6982	6.6936	6.6982	186564.0
2007-11-01 19:30:00	AAPL	Stock	6.6939	6.6982	6.6929	6.6943	219380.0
2007-11-01 07:00:00	MSFT	Stock	36.71	36.71	36.5	36.5	3892.0
2007-11-01 07:30:00	MSFT	Stock	36.52	36.61	36.5	36.61	7800.0
2007-11-01 08:00:00	MSFT	Stock	36.68	36.81	36.5	36.81	82233.0
2007-11-01 08:30:00	MSFT	Stock	36.52	36.57	36.43	36.43	49588.0
2007-11-01 09:00:00	MSFT	Stock	36.45	36.81	36.4	36.53	328056.0
2007-11-01 09:30:00	MSFT	Stock	36.53	36.87	36.5	36.702	15405887.0
2007-11-01 10:00:00	MSFT	Stock	36.71	36.81	36.36	36.72	15514504.0
2007-11-01 10:30:00	MSFT	Stock	36.71	37.36	36.65	37.33	13099167.0
2007-11-01 11:00:00	MSFT	Stock	37.33	37.49	36.878	37.25	13978253.0
2007-11-01 11:30:00	MSFT	Stock	37.26	37.26	37.0	37.18	8223561.0
2007-11-01 12:00:00	MSFT	Stock	37.19	37.31	37.17	37.27	5696698.0
2007-11-01 12:30:00	MSFT	Stock	37.27	37.44	37.26	37.42	6095721.0
2007-11-01 13:00:00	MSFT	Stock	37.41	37.44	37.31	37.32	4764037.0
2007-11-01 13:30:00	MSFT	Stock	37.31	37.42	37.05	37.11	7248429.0
2007-11-01 14:00:00	MSFT	Stock	37.11	37.19	36.92	36.98	11308056.0
2007-11-01 14:30:00	MSFT	Stock	36.985	37.2	36.985	37.16	10435486.0
2007-11-01 15:00:00	MSFT	Stock	37.17	37.2	36.99	37.02	17399559.0
2007-11-01 15:30:00	MSFT	Stock	37.02	37.13	37.0	37.06	16219236.0
2007-11-01 16:00:00	MSFT	Stock	37.066	37.174	36.36	37.08	3493551.0
2007-11-01 16:30:00	MSFT	Stock	37.05	37.11	36.453	37.1	602132.0
2007-11-01 17:00:00	MSFT	Stock	37.09	37.09	36.81	37.06	1174879.0
2007-11-01 17:30:00	MSFT	Stock	37.06	37.09	37.05	37.09	976980.0
2007-11-01 18:00:00	MSFT	Stock	37.08	37.1	37.04	37.06	22220.0

> showing 50 of 71,630 rows — these rows as CSV

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