PREVIEW / stock_30min / 2007-08-07

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-07.parquet
  size:    1.2 MB
  rows:    65,815
  symbols: 3,117

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-08-07 09:30:00	AAPL	Stock	4.8193	4.8929	4.8007	4.875	116710048.0
2007-08-07 10:00:00	AAPL	Stock	4.875	4.9014	4.8511	4.8661	76653612.0
2007-08-07 10:30:00	AAPL	Stock	4.8657	4.8929	4.85	4.8925	49514920.0
2007-08-07 11:00:00	AAPL	Stock	4.8925	4.8929	4.8625	4.882	39859008.0
2007-08-07 11:30:00	AAPL	Stock	4.8818	4.8929	4.87	4.885	32817232.0
2007-08-07 12:00:00	AAPL	Stock	4.8857	4.8893	4.875	4.8768	24172232.0
2007-08-07 12:30:00	AAPL	Stock	4.8771	4.8911	4.8707	4.8804	23645048.0
2007-08-07 13:00:00	AAPL	Stock	4.88	4.8886	4.8507	4.8789	60077192.0
2007-08-07 13:30:00	AAPL	Stock	4.8789	4.8843	4.8464	4.8529	35745024.0
2007-08-07 14:00:00	AAPL	Stock	4.8543	4.8643	4.75	4.7782	108140144.0
2007-08-07 14:30:00	AAPL	Stock	4.7793	4.8254	4.7368	4.8254	134541036.0
2007-08-07 15:00:00	AAPL	Stock	4.8246	4.8636	4.8243	4.8507	66677996.0
2007-08-07 15:30:00	AAPL	Stock	4.8511	4.8986	4.7954	4.8243	109305308.0
2007-08-07 16:00:00	AAPL	Stock	4.8207	4.8296	4.8207	4.8225	15085476.0
2007-08-07 09:30:00	MSFT	Stock	29.33	29.41	29.22	29.26	3042401.0
2007-08-07 10:00:00	MSFT	Stock	29.25	29.35	29.22	29.26	3315321.0
2007-08-07 10:30:00	MSFT	Stock	29.26	29.26	29.15	29.159	2303828.0
2007-08-07 11:00:00	MSFT	Stock	29.15	29.22	29.14	29.189	1750412.0
2007-08-07 11:30:00	MSFT	Stock	29.18	29.24	29.15	29.19	2598583.0
2007-08-07 12:00:00	MSFT	Stock	29.19	29.23	29.14	29.17	1850757.0
2007-08-07 12:30:00	MSFT	Stock	29.16	29.24	29.16	29.2	1973148.0
2007-08-07 13:00:00	MSFT	Stock	29.2	29.38	29.2	29.35	2223445.0
2007-08-07 13:30:00	MSFT	Stock	29.34	29.39	29.3	29.3	1778682.0
2007-08-07 14:00:00	MSFT	Stock	29.31	29.4	29.1	29.15	4671061.0
2007-08-07 14:30:00	MSFT	Stock	29.15	29.38	29.05	29.35	4626608.0
2007-08-07 15:00:00	MSFT	Stock	29.36	29.55	29.33	29.53	3830372.0
2007-08-07 15:30:00	MSFT	Stock	29.54	29.79	29.48	29.54	7555232.0
2007-08-07 16:00:00	MSFT	Stock	29.52	29.55	29.52	29.55	2811434.0
2007-08-07 08:00:00	NVDA	Stock	0.7183	0.7183	0.7175	0.7175	444000.0
2007-08-07 08:30:00	NVDA	Stock	0.7175	0.7175	0.7118	0.7118	30000.0
2007-08-07 09:00:00	NVDA	Stock	0.7158	0.7158	0.7118	0.7118	141900.0
2007-08-07 09:30:00	NVDA	Stock	0.715	0.7322	0.7092	0.7313	59614200.0
2007-08-07 10:00:00	NVDA	Stock	0.7313	0.7317	0.7168	0.7227	63172140.0
2007-08-07 10:30:00	NVDA	Stock	0.7227	0.7233	0.7167	0.7223	26689380.0
2007-08-07 11:00:00	NVDA	Stock	0.7223	0.7233	0.719	0.7197	19300380.0
2007-08-07 11:30:00	NVDA	Stock	0.7195	0.7215	0.7172	0.718	21891000.0
2007-08-07 12:00:00	NVDA	Stock	0.7178	0.7202	0.7163	0.718	22119720.0
2007-08-07 12:30:00	NVDA	Stock	0.7178	0.7195	0.7132	0.7133	16015920.0
2007-08-07 13:00:00	NVDA	Stock	0.7133	0.7302	0.711	0.7147	16224660.0
2007-08-07 13:30:00	NVDA	Stock	0.7145	0.717	0.7112	0.7117	33214680.0
2007-08-07 14:00:00	NVDA	Stock	0.7117	0.7178	0.7067	0.7078	75976260.0
2007-08-07 14:30:00	NVDA	Stock	0.7078	0.7238	0.7055	0.7238	57791940.0
2007-08-07 15:00:00	NVDA	Stock	0.7243	0.7267	0.72	0.7267	42060720.0
2007-08-07 15:30:00	NVDA	Stock	0.7267	0.7382	0.7242	0.7263	74228340.0
2007-08-07 16:00:00	NVDA	Stock	0.7263	0.7263	0.7242	0.7245	10934940.0
2007-08-07 16:30:00	NVDA	Stock	0.725	0.7308	0.7207	0.7308	1517520.0
2007-08-07 17:00:00	NVDA	Stock	0.7305	0.7333	0.7263	0.7333	517560.0
2007-08-07 17:30:00	NVDA	Stock	0.737	0.7417	0.7333	0.7407	582960.0
2007-08-07 18:00:00	NVDA	Stock	0.715	0.7413	0.715	0.7412	535800.0
2007-08-07 18:30:00	NVDA	Stock	0.7412	0.7417	0.7412	0.7417	153000.0

> showing 50 of 65,815 rows — these rows as CSV

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