PREVIEW / stock_30min / 2007-12-31

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-31.parquet
  size:    1.3 MB
  rows:    72,077
  symbols: 3,282

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-12-31 07:00:00	AAPL	Stock	7.1379	7.1379	7.1379	7.1379	2800.0
2007-12-31 07:30:00	AAPL	Stock	7.1429	7.1429	7.1429	7.1429	28000.0
2007-12-31 08:00:00	AAPL	Stock	7.1429	7.1696	7.1429	7.1607	2559060.0
2007-12-31 08:30:00	AAPL	Stock	7.1607	7.1607	7.1429	7.15	895300.0
2007-12-31 09:00:00	AAPL	Stock	7.15	7.1525	7.1236	7.1275	1765176.0
2007-12-31 09:30:00	AAPL	Stock	7.1236	7.1411	7.0704	7.1036	78479296.0
2007-12-31 10:00:00	AAPL	Stock	7.1029	7.1371	7.0921	7.1196	47004496.0
2007-12-31 10:30:00	AAPL	Stock	7.1196	7.1281	7.0936	7.1182	29253588.0
2007-12-31 11:00:00	AAPL	Stock	7.1182	7.1393	7.1089	7.1339	33544924.0
2007-12-31 11:30:00	AAPL	Stock	7.1339	7.1607	7.1304	7.1461	41146448.0
2007-12-31 12:00:00	AAPL	Stock	7.1468	7.1504	7.1039	7.1107	29581328.0
2007-12-31 12:30:00	AAPL	Stock	7.1107	7.1286	7.1	7.1204	33944372.0
2007-12-31 13:00:00	AAPL	Stock	7.12	7.1411	7.1161	7.1286	22597792.0
2007-12-31 13:30:00	AAPL	Stock	7.1286	7.1346	7.1168	7.1196	15773520.0
2007-12-31 14:00:00	AAPL	Stock	7.1186	7.1318	7.1	7.1054	24904656.0
2007-12-31 14:30:00	AAPL	Stock	7.1054	7.1289	7.1039	7.1246	28143052.0
2007-12-31 15:00:00	AAPL	Stock	7.1243	7.1529	7.1207	7.1371	38810856.0
2007-12-31 15:30:00	AAPL	Stock	7.1368	7.1421	7.0625	7.0743	88409216.0
2007-12-31 16:00:00	AAPL	Stock	7.0714	7.1214	7.0696	7.0786	19062204.0
2007-12-31 16:30:00	AAPL	Stock	7.0761	7.0907	7.0743	7.0875	847308.0
2007-12-31 17:00:00	AAPL	Stock	7.0857	7.0918	7.0821	7.0911	455560.0
2007-12-31 17:30:00	AAPL	Stock	7.0889	7.0911	7.0839	7.0839	67704.0
2007-12-31 18:00:00	AAPL	Stock	7.0893	7.1439	7.0743	7.0857	1912372.0
2007-12-31 18:30:00	AAPL	Stock	7.0857	7.09	7.0807	7.09	81088.0
2007-12-31 19:00:00	AAPL	Stock	7.0896	7.0911	7.0896	7.0911	93800.0
2007-12-31 19:30:00	AAPL	Stock	7.0911	7.0911	7.0857	7.0893	162260.0
2007-12-31 08:30:00	MSFT	Stock	36.05	36.12	36.05	36.12	1799.0
2007-12-31 09:00:00	MSFT	Stock	36.12	36.12	35.9	35.92	114540.0
2007-12-31 09:30:00	MSFT	Stock	35.98	35.99	35.7	35.75	3788315.0
2007-12-31 10:00:00	MSFT	Stock	35.76	35.85	35.7	35.75	2043675.0
2007-12-31 10:30:00	MSFT	Stock	35.75	35.76	35.57	35.71	2018099.0
2007-12-31 11:00:00	MSFT	Stock	35.72	35.72	35.62	35.72	1861708.0
2007-12-31 11:30:00	MSFT	Stock	35.72	35.86	35.71	35.75	1545570.0
2007-12-31 12:00:00	MSFT	Stock	35.75	35.79	35.65	35.67	1680932.0
2007-12-31 12:30:00	MSFT	Stock	35.67	35.75	35.65	35.687	1241411.0
2007-12-31 13:00:00	MSFT	Stock	35.69	35.8	35.61	35.75	1692815.0
2007-12-31 13:30:00	MSFT	Stock	35.76	35.79	35.7	35.72	850209.0
2007-12-31 14:00:00	MSFT	Stock	35.72	35.74	35.67	35.68	1841845.0
2007-12-31 14:30:00	MSFT	Stock	35.69	35.78	35.68	35.75	1255128.0
2007-12-31 15:00:00	MSFT	Stock	35.76	35.82	35.71	35.782	2005174.0
2007-12-31 15:30:00	MSFT	Stock	35.79	35.79	35.52	35.59	8365946.0
2007-12-31 16:00:00	MSFT	Stock	35.59	35.75	33.59	35.61	4954814.0
2007-12-31 16:30:00	MSFT	Stock	35.6	35.63	35.5	35.59	74504.0
2007-12-31 17:00:00	MSFT	Stock	35.59	35.64	35.59	35.62	252779.0
2007-12-31 17:30:00	MSFT	Stock	35.63	35.69	35.63	35.69	2100.0
2007-12-31 18:00:00	MSFT	Stock	35.78	35.78	35.6	35.6	530759.0
2007-12-31 18:30:00	MSFT	Stock	35.6	35.6	35.48	35.51	2610.0
2007-12-31 19:30:00	MSFT	Stock	35.48	35.48	35.48	35.48	200.0
2007-12-31 09:00:00	NVDA	Stock	0.8662	0.8662	0.8625	0.8625	117600.0
2007-12-31 09:30:00	NVDA	Stock	0.8628	0.867	0.8575	0.867	24840280.0

> showing 50 of 72,077 rows — these rows as CSV

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