PREVIEW / stock_30min / 2008-07-01

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-07-01.parquet
  size:    1.3 MB
  rows:    71,515
  symbols: 3,342

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-07-01 04:30:00	AAPL	Stock	5.9286	5.9286	5.9286	5.9286	2800.0
2008-07-01 05:00:00	AAPL	Stock	5.9175	5.9175	5.9175	5.9175	8400.0
2008-07-01 07:00:00	AAPL	Stock	5.9107	5.9436	5.8929	5.9	36400.0
2008-07-01 07:30:00	AAPL	Stock	5.9107	5.9214	5.8929	5.8929	121772.0
2008-07-01 08:00:00	AAPL	Stock	5.98	5.98	5.8929	5.9161	1552908.0
2008-07-01 08:30:00	AAPL	Stock	5.9161	5.9161	5.8836	5.8857	2060828.0
2008-07-01 09:00:00	AAPL	Stock	5.8871	5.8929	5.8629	5.8671	4672360.0
2008-07-01 09:30:00	AAPL	Stock	5.8675	6.1607	5.8571	6.045	157189676.0
2008-07-01 10:00:00	AAPL	Stock	6.045	6.1586	6.0396	6.1139	129752140.0
2008-07-01 10:30:00	AAPL	Stock	6.1126	6.1571	6.1126	6.1568	83610240.0
2008-07-01 11:00:00	AAPL	Stock	6.1571	6.1714	6.1314	6.1612	83957888.0
2008-07-01 11:30:00	AAPL	Stock	6.16	6.225	6.1186	6.1264	69347236.0
2008-07-01 12:00:00	AAPL	Stock	6.1264	6.1354	6.0329	6.0436	90002108.0
2008-07-01 12:30:00	AAPL	Stock	6.0436	6.1157	6.0407	6.1136	57057028.0
2008-07-01 13:00:00	AAPL	Stock	6.1136	6.15	6.0986	6.1357	40179468.0
2008-07-01 13:30:00	AAPL	Stock	6.1354	6.1704	6.0964	6.1546	48793556.0
2008-07-01 14:00:00	AAPL	Stock	6.1554	6.2275	6.1439	6.1907	78666924.0
2008-07-01 14:30:00	AAPL	Stock	6.1889	6.2375	6.1786	6.2069	73186176.0
2008-07-01 15:00:00	AAPL	Stock	6.2071	6.2314	6.1871	6.2014	80628212.0
2008-07-01 15:30:00	AAPL	Stock	6.2014	6.24	6.1879	6.2386	80028732.0
2008-07-01 16:00:00	AAPL	Stock	6.2368	6.2386	6.1201	6.2321	18230828.0
2008-07-01 16:30:00	AAPL	Stock	6.2321	6.2386	6.1201	6.2321	386596.0
2008-07-01 17:00:00	AAPL	Stock	6.2354	6.2386	6.2321	6.2357	277788.0
2008-07-01 17:30:00	AAPL	Stock	5.98	6.2411	5.98	6.2411	538524.0
2008-07-01 18:00:00	AAPL	Stock	6.2407	6.2471	6.2396	6.2411	104132.0
2008-07-01 18:30:00	AAPL	Stock	6.2414	6.2446	6.2396	6.2446	99680.0
2008-07-01 19:00:00	AAPL	Stock	6.2432	6.2436	6.2393	6.2411	81536.0
2008-07-01 19:30:00	AAPL	Stock	6.2411	6.2425	6.2286	6.2304	218540.0
2008-07-01 06:30:00	MSFT	Stock	27.38	27.38	27.38	27.38	100.0
2008-07-01 07:00:00	MSFT	Stock	27.38	27.38	27.33	27.33	1000.0
2008-07-01 07:30:00	MSFT	Stock	27.35	27.35	27.33	27.33	21950.0
2008-07-01 08:00:00	MSFT	Stock	27.33	27.51	27.28	27.31	169903.0
2008-07-01 08:30:00	MSFT	Stock	27.33	27.33	27.3	27.32	19460.0
2008-07-01 09:00:00	MSFT	Stock	27.31	27.51	27.2	27.28	143478.0
2008-07-01 09:30:00	MSFT	Stock	27.27	27.32	27.1	27.15	7051956.0
2008-07-01 10:00:00	MSFT	Stock	27.15	27.38	26.99	27.04	7802274.0
2008-07-01 10:30:00	MSFT	Stock	27.03	27.25	27.03	27.22	6083264.0
2008-07-01 11:00:00	MSFT	Stock	27.22	27.28	27.07	27.08	4920543.0
2008-07-01 11:30:00	MSFT	Stock	27.09	27.11	26.74	26.785	5191770.0
2008-07-01 12:00:00	MSFT	Stock	26.785	26.82	26.44	26.56	9508237.0
2008-07-01 12:30:00	MSFT	Stock	26.55	26.71	26.5	26.62	5586692.0
2008-07-01 13:00:00	MSFT	Stock	26.62	26.7	26.55	26.66	4638948.0
2008-07-01 13:30:00	MSFT	Stock	26.65	26.82	26.52	26.73	4704846.0
2008-07-01 14:00:00	MSFT	Stock	26.72	27.02	26.705	26.908	8299912.0
2008-07-01 14:30:00	MSFT	Stock	26.9	27.14	26.82	26.96	6203312.0
2008-07-01 15:00:00	MSFT	Stock	26.96	27.33	26.8	26.84	6584701.0
2008-07-01 15:30:00	MSFT	Stock	26.83	26.94	26.8	26.91	10548765.0
2008-07-01 16:00:00	MSFT	Stock	26.9	26.92	26.82	26.87	10563050.0
2008-07-01 16:30:00	MSFT	Stock	26.9	26.92	26.87	26.87	101088.0
2008-07-01 17:00:00	MSFT	Stock	26.85	26.92	26.85	26.89	6331.0

> showing 50 of 71,515 rows — these rows as CSV

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