PREVIEW / stock_30min / 2008-04-18

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-18.parquet
  size:    1.2 MB
  rows:    68,881
  symbols: 3,291

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
2008-04-18 04:30:00	AAPL	Stock	5.6071	5.6071	5.6071	5.6071	2800.0
2008-04-18 05:30:00	AAPL	Stock	5.5907	5.5907	5.5907	5.5907	5600.0
2008-04-18 06:00:00	AAPL	Stock	5.5893	5.6107	5.5821	5.6046	11200.0
2008-04-18 07:00:00	AAPL	Stock	5.6107	5.6571	5.6071	5.6504	141484.0
2008-04-18 07:30:00	AAPL	Stock	5.6554	5.6786	5.6518	5.6786	679924.0
2008-04-18 08:00:00	AAPL	Stock	5.6782	5.6957	5.6217	5.6696	4637276.0
2008-04-18 08:30:00	AAPL	Stock	5.67	5.6743	5.6554	5.6693	1583988.0
2008-04-18 09:00:00	AAPL	Stock	5.6668	5.6818	5.6579	5.68	5461904.0
2008-04-18 09:30:00	AAPL	Stock	5.68	5.7025	5.6564	5.6757	168612892.0
2008-04-18 10:00:00	AAPL	Stock	5.6757	5.6954	5.66	5.6793	78583736.0
2008-04-18 10:30:00	AAPL	Stock	5.6796	5.74	5.6754	5.7368	112645176.0
2008-04-18 11:00:00	AAPL	Stock	5.7361	5.7661	5.715	5.7282	103205200.0
2008-04-18 11:30:00	AAPL	Stock	5.7282	5.7643	5.7268	5.7632	62566028.0
2008-04-18 12:00:00	AAPL	Stock	5.7629	5.795	5.7511	5.7814	70738024.0
2008-04-18 12:30:00	AAPL	Stock	5.7811	5.7911	5.7386	5.7593	49684432.0
2008-04-18 13:00:00	AAPL	Stock	5.7589	5.7832	5.7579	5.7792	36086400.0
2008-04-18 13:30:00	AAPL	Stock	5.7796	5.7857	5.7554	5.7693	39921252.0
2008-04-18 14:00:00	AAPL	Stock	5.7689	5.775	5.7321	5.7421	53076800.0
2008-04-18 14:30:00	AAPL	Stock	5.7421	5.765	5.7418	5.7522	34340824.0
2008-04-18 15:00:00	AAPL	Stock	5.7521	5.7604	5.7246	5.7271	52603964.0
2008-04-18 15:30:00	AAPL	Stock	5.7271	5.7564	5.7257	5.7543	105671972.0
2008-04-18 16:00:00	AAPL	Stock	5.7532	5.7621	5.7289	5.7589	19302668.0
2008-04-18 16:30:00	AAPL	Stock	5.7571	5.7639	5.7564	5.7589	3621660.0
2008-04-18 17:00:00	AAPL	Stock	5.7625	5.775	5.7625	5.7714	476112.0
2008-04-18 17:30:00	AAPL	Stock	5.7714	5.7743	5.7679	5.7707	223972.0
2008-04-18 18:00:00	AAPL	Stock	5.7704	5.7704	5.7643	5.7675	98280.0
2008-04-18 18:30:00	AAPL	Stock	5.7636	5.7661	5.7571	5.7575	82012.0
2008-04-18 19:00:00	AAPL	Stock	5.7575	5.7643	5.7575	5.7575	122472.0
2008-04-18 19:30:00	AAPL	Stock	5.7629	5.7707	5.7629	5.7707	165592.0
2008-04-18 07:00:00	MSFT	Stock	29.55	29.63	29.55	29.63	1700.0
2008-04-18 07:30:00	MSFT	Stock	29.61	29.69	29.61	29.65	4764.0
2008-04-18 08:00:00	MSFT	Stock	29.65	29.95	29.65	29.85	98314.0
2008-04-18 08:30:00	MSFT	Stock	29.81	29.9	29.78	29.81	126496.0
2008-04-18 09:00:00	MSFT	Stock	29.89	30.0	29.74	30.0	411828.0
2008-04-18 09:30:00	MSFT	Stock	30.01	30.05	29.73	29.75	16303457.0
2008-04-18 10:00:00	MSFT	Stock	29.74	29.89	29.61	29.79	5656363.0
2008-04-18 10:30:00	MSFT	Stock	29.8	29.97	29.79	29.93	3332024.0
2008-04-18 11:00:00	MSFT	Stock	29.92	30.0	29.89	29.93	3419500.0
2008-04-18 11:30:00	MSFT	Stock	29.93	29.96	29.88	29.95	2247012.0
2008-04-18 12:00:00	MSFT	Stock	29.95	30.1	29.93	30.03	5079736.0
2008-04-18 12:30:00	MSFT	Stock	30.04	30.04	29.94	30.0	4092550.0
2008-04-18 13:00:00	MSFT	Stock	30.0	30.04	29.94	30.03	2938342.0
2008-04-18 13:30:00	MSFT	Stock	30.03	30.05	29.97	30.03	2628054.0
2008-04-18 14:00:00	MSFT	Stock	30.04	30.08	29.97	30.008	3430685.0
2008-04-18 14:30:00	MSFT	Stock	30.008	30.05	29.99	30.025	2842461.0
2008-04-18 15:00:00	MSFT	Stock	30.02	30.07	29.98	30.03	4188204.0
2008-04-18 15:30:00	MSFT	Stock	30.02	30.07	29.93	30.0	9702785.0
2008-04-18 16:00:00	MSFT	Stock	30.01	30.05	29.951	30.05	4151424.0
2008-04-18 16:30:00	MSFT	Stock	30.05	30.11	29.97	30.04	515182.0
2008-04-18 17:00:00	MSFT	Stock	30.02	30.08	30.0	30.07	12241.0

> showing 50 of 68,881 rows — these rows as CSV

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