PREVIEW / stock_30min / 2007-07-09

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-09.parquet
  size:    1.1 MB
  rows:    64,723
  symbols: 3,067

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-07-09 09:30:00	AAPL	Stock	4.7279	4.7464	4.6789	4.6993	163812264.0
2007-07-09 10:00:00	AAPL	Stock	4.6986	4.7111	4.6875	4.6982	82586616.0
2007-07-09 10:30:00	AAPL	Stock	4.6979	4.6996	4.6514	4.6518	117670868.0
2007-07-09 11:00:00	AAPL	Stock	4.6511	4.6725	4.6504	4.6682	62510952.0
2007-07-09 11:30:00	AAPL	Stock	4.6682	4.6704	4.6554	4.6616	31245816.0
2007-07-09 12:00:00	AAPL	Stock	4.6621	4.665	4.6464	4.6561	37951032.0
2007-07-09 12:30:00	AAPL	Stock	4.6564	4.6711	4.6543	4.6629	36829072.0
2007-07-09 13:00:00	AAPL	Stock	4.6632	4.6643	4.6446	4.6525	47995612.0
2007-07-09 13:30:00	AAPL	Stock	4.6525	4.6532	4.6136	4.635	95280500.0
2007-07-09 14:00:00	AAPL	Stock	4.6354	4.6396	4.6161	4.6221	47903576.0
2007-07-09 14:30:00	AAPL	Stock	4.6221	4.6571	4.6214	4.6479	80900120.0
2007-07-09 15:00:00	AAPL	Stock	4.6475	4.6657	4.6446	4.6446	65816100.0
2007-07-09 15:30:00	AAPL	Stock	4.6446	4.6586	4.6411	4.6539	92618540.0
2007-07-09 16:00:00	AAPL	Stock	4.6575	4.6579	4.6539	4.6546	9001328.0
2007-07-09 09:30:00	MSFT	Stock	29.86	29.95	29.84	29.92	3540649.0
2007-07-09 10:00:00	MSFT	Stock	29.92	29.94	29.88	29.9	2707464.0
2007-07-09 10:30:00	MSFT	Stock	29.9	29.922	29.85	29.9	3730626.0
2007-07-09 11:00:00	MSFT	Stock	29.902	29.92	29.89	29.9	1264817.0
2007-07-09 11:30:00	MSFT	Stock	29.9	29.91	29.86	29.87	1472506.0
2007-07-09 12:00:00	MSFT	Stock	29.87	29.89	29.83	29.852	2530972.0
2007-07-09 12:30:00	MSFT	Stock	29.86	29.92	29.85	29.885	2001802.0
2007-07-09 13:00:00	MSFT	Stock	29.885	29.89	29.85	29.862	1357841.0
2007-07-09 13:30:00	MSFT	Stock	29.87	29.87	29.83	29.85	934314.0
2007-07-09 14:00:00	MSFT	Stock	29.84	29.85	29.81	29.82	1651252.0
2007-07-09 14:30:00	MSFT	Stock	29.83	29.93	29.82	29.92	2352269.0
2007-07-09 15:00:00	MSFT	Stock	29.92	29.94	29.87	29.9	2772485.0
2007-07-09 15:30:00	MSFT	Stock	29.905	29.91	29.85	29.85	3448912.0
2007-07-09 16:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	1306103.0
2007-07-09 07:30:00	NVDA	Stock	0.7333	0.7333	0.7333	0.7333	30000.0
2007-07-09 08:00:00	NVDA	Stock	0.7325	0.7335	0.7325	0.7335	360000.0
2007-07-09 08:30:00	NVDA	Stock	0.7392	0.7392	0.7383	0.7383	81000.0
2007-07-09 09:00:00	NVDA	Stock	0.7355	0.7372	0.7328	0.7328	408300.0
2007-07-09 09:30:00	NVDA	Stock	0.7322	0.7398	0.732	0.7363	50352420.0
2007-07-09 10:00:00	NVDA	Stock	0.7362	0.7458	0.7362	0.7458	43519080.0
2007-07-09 10:30:00	NVDA	Stock	0.7458	0.7458	0.739	0.7398	39020100.0
2007-07-09 11:00:00	NVDA	Stock	0.7397	0.7453	0.7397	0.7425	31729560.0
2007-07-09 11:30:00	NVDA	Stock	0.7425	0.7463	0.7423	0.7447	25402200.0
2007-07-09 12:00:00	NVDA	Stock	0.7445	0.7462	0.7427	0.7462	23179980.0
2007-07-09 12:30:00	NVDA	Stock	0.746	0.748	0.744	0.7475	24102780.0
2007-07-09 13:00:00	NVDA	Stock	0.7473	0.75	0.7463	0.75	25420260.0
2007-07-09 13:30:00	NVDA	Stock	0.7498	0.752	0.7498	0.751	34618920.0
2007-07-09 14:00:00	NVDA	Stock	0.751	0.7542	0.7495	0.751	44794260.0
2007-07-09 14:30:00	NVDA	Stock	0.751	0.7522	0.7491	0.75	32545320.0
2007-07-09 15:00:00	NVDA	Stock	0.75	0.7518	0.7493	0.7508	27998400.0
2007-07-09 15:30:00	NVDA	Stock	0.7507	0.7518	0.7493	0.7513	46147200.0
2007-07-09 16:00:00	NVDA	Stock	0.7512	0.7512	0.7417	0.75	63507720.0
2007-07-09 16:30:00	NVDA	Stock	0.75	0.7507	0.7495	0.7495	438780.0
2007-07-09 17:00:00	NVDA	Stock	0.7507	0.7507	0.7295	0.75	569040.0
2007-07-09 17:30:00	NVDA	Stock	0.7455	0.752	0.7455	0.752	257760.0
2007-07-09 18:00:00	NVDA	Stock	0.752	0.752	0.752	0.752	6600.0

> showing 50 of 64,723 rows — these rows as CSV

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