PREVIEW / stock_30min / 2007-08-17

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-17.parquet
  size:    1.2 MB
  rows:    67,738
  symbols: 3,145

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-17 09:30:00	AAPL	Stock	4.3575	4.3964	4.2936	4.3068	245111440.0
2007-08-17 10:00:00	AAPL	Stock	4.3068	4.3389	4.2857	4.3104	116544400.0
2007-08-17 10:30:00	AAPL	Stock	4.3104	4.3343	4.2793	4.3029	104627992.0
2007-08-17 11:00:00	AAPL	Stock	4.3039	4.3204	4.2886	4.3111	57207948.0
2007-08-17 11:30:00	AAPL	Stock	4.3107	4.3389	4.3011	4.3229	56771624.0
2007-08-17 12:00:00	AAPL	Stock	4.3236	4.3311	4.3143	4.325	39689132.0
2007-08-17 12:30:00	AAPL	Stock	4.3246	4.3357	4.3171	4.3204	31446772.0
2007-08-17 13:00:00	AAPL	Stock	4.3214	4.3725	4.3207	4.3518	64321432.0
2007-08-17 13:30:00	AAPL	Stock	4.3511	4.3618	4.3271	4.3371	45012100.0
2007-08-17 14:00:00	AAPL	Stock	4.3364	4.3568	4.3214	4.3568	43287916.0
2007-08-17 14:30:00	AAPL	Stock	4.3564	4.3657	4.3468	4.365	52596320.0
2007-08-17 15:00:00	AAPL	Stock	4.365	4.4107	4.3593	4.3689	117784520.0
2007-08-17 15:30:00	AAPL	Stock	4.3693	4.3893	4.3571	4.3593	108462032.0
2007-08-17 16:00:00	AAPL	Stock	4.3643	4.3643	4.3593	4.3593	15547728.0
2007-08-17 09:30:00	MSFT	Stock	28.09	28.2	27.86	27.94	12035278.0
2007-08-17 10:00:00	MSFT	Stock	27.94	28.05	27.87	27.9	4914656.0
2007-08-17 10:30:00	MSFT	Stock	27.9	28.0	27.82	27.97	5017666.0
2007-08-17 11:00:00	MSFT	Stock	27.98	28.04	27.84	28.01	4045048.0
2007-08-17 11:30:00	MSFT	Stock	28.01	28.19	27.94	27.993	2871406.0
2007-08-17 12:00:00	MSFT	Stock	27.992	28.05	27.85	27.98	3313047.0
2007-08-17 12:30:00	MSFT	Stock	27.97	28.04	27.94	27.985	2166783.0
2007-08-17 13:00:00	MSFT	Stock	27.98	28.24	27.98	28.12	3182784.0
2007-08-17 13:30:00	MSFT	Stock	28.11	28.13	28.0	28.041	3160651.0
2007-08-17 14:00:00	MSFT	Stock	28.04	28.04	27.89	27.899	3383717.0
2007-08-17 14:30:00	MSFT	Stock	27.89	27.92	27.83	27.86	4269579.0
2007-08-17 15:00:00	MSFT	Stock	27.85	28.03	27.83	28.0	6287308.0
2007-08-17 15:30:00	MSFT	Stock	28.01	28.25	28.0	28.25	9781981.0
2007-08-17 16:00:00	MSFT	Stock	28.23	28.25	28.23	28.25	2654735.0
2007-08-17 07:00:00	NVDA	Stock	0.7083	0.7083	0.7083	0.7083	6000.0
2007-08-17 07:30:00	NVDA	Stock	0.7042	0.7042	0.7042	0.7042	12000.0
2007-08-17 08:00:00	NVDA	Stock	0.7008	0.725	0.7008	0.725	259200.0
2007-08-17 08:30:00	NVDA	Stock	0.725	0.734	0.7183	0.7333	2903520.0
2007-08-17 09:00:00	NVDA	Stock	0.734	0.7383	0.7292	0.7358	3072480.0
2007-08-17 09:30:00	NVDA	Stock	0.731	0.7375	0.7065	0.716	115715340.0
2007-08-17 10:00:00	NVDA	Stock	0.7155	0.7227	0.7085	0.7173	66001260.0
2007-08-17 10:30:00	NVDA	Stock	0.7172	0.721	0.7122	0.7173	39736920.0
2007-08-17 11:00:00	NVDA	Stock	0.7173	0.7218	0.7141	0.7168	33357960.0
2007-08-17 11:30:00	NVDA	Stock	0.7178	0.7247	0.7158	0.7207	44265060.0
2007-08-17 12:00:00	NVDA	Stock	0.7207	0.7267	0.7185	0.726	29569560.0
2007-08-17 12:30:00	NVDA	Stock	0.7258	0.7302	0.722	0.7248	28949580.0
2007-08-17 13:00:00	NVDA	Stock	0.7248	0.7315	0.7245	0.7303	32298240.0
2007-08-17 13:30:00	NVDA	Stock	0.7302	0.7323	0.73	0.7305	23520540.0
2007-08-17 14:00:00	NVDA	Stock	0.7307	0.7345	0.7273	0.7312	37750500.0
2007-08-17 14:30:00	NVDA	Stock	0.7312	0.7395	0.7312	0.7387	45057120.0
2007-08-17 15:00:00	NVDA	Stock	0.7387	0.7497	0.7363	0.7458	78760560.0
2007-08-17 15:30:00	NVDA	Stock	0.7458	0.752	0.7435	0.7507	113529600.0
2007-08-17 16:00:00	NVDA	Stock	0.7513	0.7513	0.7478	0.7503	13916520.0
2007-08-17 16:30:00	NVDA	Stock	0.7497	0.7513	0.7495	0.7503	1468740.0
2007-08-17 17:30:00	NVDA	Stock	0.749	0.749	0.7488	0.7488	45000.0
2007-08-17 18:30:00	NVDA	Stock	0.7513	0.7513	0.7513	0.7513	66000.0

> showing 50 of 67,738 rows — these rows as CSV

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