PREVIEW / stock_30min / 2006-04-27

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-04-27.parquet
  size:    911 KB
  rows:    48,872
  symbols: 2,237

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
2006-04-27 07:30:00	AAPL	Stock	2.4196	2.4196	2.4143	2.4143	14000.0
2006-04-27 08:00:00	AAPL	Stock	2.4136	2.4196	2.4125	2.4168	589988.0
2006-04-27 08:30:00	AAPL	Stock	2.4175	2.4211	2.415	2.415	1095332.0
2006-04-27 09:00:00	AAPL	Stock	2.4168	2.4196	2.4146	2.4196	1045436.0
2006-04-27 09:30:00	AAPL	Stock	2.4189	2.4339	2.4054	2.4236	101109792.0
2006-04-27 10:00:00	AAPL	Stock	2.4232	2.4475	2.4179	2.4436	111099016.0
2006-04-27 10:30:00	AAPL	Stock	2.4436	2.4514	2.4243	2.4421	68027792.0
2006-04-27 11:00:00	AAPL	Stock	2.4421	2.4782	2.4357	2.4743	88185244.0
2006-04-27 11:30:00	AAPL	Stock	2.4746	2.4779	2.4359	2.4714	49679420.0
2006-04-27 12:00:00	AAPL	Stock	2.4718	2.4818	2.4707	2.4811	44668708.0
2006-04-27 12:30:00	AAPL	Stock	2.4811	2.485	2.4725	2.48	46368700.0
2006-04-27 13:00:00	AAPL	Stock	2.4796	2.48	2.4725	2.4768	35466032.0
2006-04-27 13:30:00	AAPL	Stock	2.4771	2.4779	2.4654	2.4704	34933360.0
2006-04-27 14:00:00	AAPL	Stock	2.4704	2.4811	2.4668	2.4736	58345644.0
2006-04-27 14:30:00	AAPL	Stock	2.4732	2.495	2.4711	2.4907	69550124.0
2006-04-27 15:00:00	AAPL	Stock	2.4904	2.4929	2.4811	2.485	45025764.0
2006-04-27 15:30:00	AAPL	Stock	2.485	2.4875	2.4632	2.4743	79362556.0
2006-04-27 16:00:00	AAPL	Stock	2.4768	2.4786	2.4736	2.4757	734076.0
2006-04-27 16:30:00	AAPL	Stock	2.4754	2.4754	2.4632	2.4632	351400.0
2006-04-27 17:00:00	AAPL	Stock	2.4679	2.4696	2.4636	2.4696	318808.0
2006-04-27 17:30:00	AAPL	Stock	2.4679	2.4679	2.4643	2.4661	99260.0
2006-04-27 18:00:00	AAPL	Stock	2.4661	2.4679	2.4661	2.4679	63000.0
2006-04-27 06:00:00	MSFT	Stock	27.01	27.03	27.01	27.03	700.0
2006-04-27 06:30:00	MSFT	Stock	26.9	26.9	26.9	26.9	1100.0
2006-04-27 07:00:00	MSFT	Stock	26.97	26.97	26.97	26.97	500.0
2006-04-27 07:30:00	MSFT	Stock	26.97	26.97	26.97	26.97	1500.0
2006-04-27 08:00:00	MSFT	Stock	26.97	27.02	26.97	26.98	48021.0
2006-04-27 08:30:00	MSFT	Stock	26.99	27.0	26.96	27.0	19765.0
2006-04-27 09:00:00	MSFT	Stock	27.0	27.02	26.95	26.96	238200.0
2006-04-27 09:30:00	MSFT	Stock	26.97	27.1	26.94	27.09	5750320.0
2006-04-27 10:00:00	MSFT	Stock	27.09	27.26	27.08	27.16	8099204.0
2006-04-27 10:30:00	MSFT	Stock	27.16	27.27	27.08	27.25	5460177.0
2006-04-27 11:00:00	MSFT	Stock	27.24	27.63	27.23	27.54	7460277.0
2006-04-27 11:30:00	MSFT	Stock	27.54	27.59	27.44	27.51	5106466.0
2006-04-27 12:00:00	MSFT	Stock	27.52	27.6	27.5	27.58	3297228.0
2006-04-27 12:30:00	MSFT	Stock	27.59	27.59	27.48	27.56	2448895.0
2006-04-27 13:00:00	MSFT	Stock	27.56	27.58	27.48	27.51	1984772.0
2006-04-27 13:30:00	MSFT	Stock	27.51	27.51	27.42	27.43	2211924.0
2006-04-27 14:00:00	MSFT	Stock	27.43	27.5	27.4	27.48	2334382.0
2006-04-27 14:30:00	MSFT	Stock	27.48	27.57	27.45	27.48	4145660.0
2006-04-27 15:00:00	MSFT	Stock	27.49	27.5	27.28	27.32	6018741.0
2006-04-27 15:30:00	MSFT	Stock	27.31	27.35	27.25	27.28	11244434.0
2006-04-27 16:00:00	MSFT	Stock	27.29	27.6	26.77	26.79	4739097.0
2006-04-27 16:30:00	MSFT	Stock	26.79	26.8	25.65	25.78	12187072.0
2006-04-27 17:00:00	MSFT	Stock	25.78	25.84	25.54	25.63	8430015.0
2006-04-27 17:30:00	MSFT	Stock	25.59	25.64	25.5	25.53	4786909.0
2006-04-27 18:00:00	MSFT	Stock	25.53	25.58	25.48	25.5	3254294.0
2006-04-27 08:30:00	NVDA	Stock	0.4732	0.4732	0.4732	0.4732	12000.0
2006-04-27 09:00:00	NVDA	Stock	0.4748	0.4785	0.4733	0.4763	1791780.0
2006-04-27 09:30:00	NVDA	Stock	0.4767	0.4767	0.4663	0.4707	55821540.0

> showing 50 of 48,872 rows — these rows as CSV

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