PREVIEW / stock_30min / 2007-08-20

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-20.parquet
  size:    1.1 MB
  rows:    65,786
  symbols: 3,123

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-20 09:00:00	AAPL	Stock	4.4271	4.4271	4.4271	4.4271	2800.0
2007-08-20 09:30:00	AAPL	Stock	4.4282	4.4464	4.3836	4.3978	127400812.0
2007-08-20 10:00:00	AAPL	Stock	4.3979	4.4161	4.3971	4.4011	51543520.0
2007-08-20 10:30:00	AAPL	Stock	4.3775	4.3875	4.3439	4.3593	71950368.0
2007-08-20 11:00:00	AAPL	Stock	4.3593	4.3811	4.3311	4.3764	55835416.0
2007-08-20 11:30:00	AAPL	Stock	4.3764	4.3889	4.3364	4.3386	48415416.0
2007-08-20 12:00:00	AAPL	Stock	4.3382	4.345	4.3214	4.34	52886876.0
2007-08-20 12:30:00	AAPL	Stock	4.3404	4.3507	4.3225	4.3268	27869016.0
2007-08-20 13:00:00	AAPL	Stock	4.3264	4.3293	4.3036	4.32	42943348.0
2007-08-20 13:30:00	AAPL	Stock	4.3196	4.3422	4.3171	4.3196	39354952.0
2007-08-20 14:00:00	AAPL	Stock	4.3196	4.3475	4.3089	4.3461	39151112.0
2007-08-20 14:30:00	AAPL	Stock	4.3454	4.3779	4.3414	4.3779	53545996.0
2007-08-20 15:00:00	AAPL	Stock	4.3779	4.3893	4.3607	4.3768	58773288.0
2007-08-20 15:30:00	AAPL	Stock	4.3768	4.3771	4.3518	4.3643	63119420.0
2007-08-20 16:00:00	AAPL	Stock	4.365	4.365	4.3643	4.365	16000208.0
2007-08-20 09:30:00	MSFT	Stock	28.18	28.39	28.13	28.35	4995762.0
2007-08-20 10:00:00	MSFT	Stock	28.35	28.49	28.32	28.44	3568247.0
2007-08-20 10:30:00	MSFT	Stock	28.38	28.39	28.3	28.37	4912246.0
2007-08-20 11:00:00	MSFT	Stock	28.38	28.39	28.3	28.34	2610766.0
2007-08-20 11:30:00	MSFT	Stock	28.34	28.42	28.3	28.33	2838139.0
2007-08-20 12:00:00	MSFT	Stock	28.33	28.39	28.24	28.27	2369517.0
2007-08-20 12:30:00	MSFT	Stock	28.27	28.283	28.2	28.22	2163516.0
2007-08-20 13:00:00	MSFT	Stock	28.23	28.23	28.08	28.12	2055993.0
2007-08-20 13:30:00	MSFT	Stock	28.11	28.27	28.08	28.14	1780235.0
2007-08-20 14:00:00	MSFT	Stock	28.15	28.16	28.08	28.14	1633565.0
2007-08-20 14:30:00	MSFT	Stock	28.14	28.23	28.11	28.23	2211017.0
2007-08-20 15:00:00	MSFT	Stock	28.23	28.46	28.22	28.39	4115928.0
2007-08-20 15:30:00	MSFT	Stock	28.4	28.4	28.17	28.26	4256656.0
2007-08-20 16:00:00	MSFT	Stock	28.26	28.26	28.26	28.26	1916069.0
2007-08-20 08:00:00	NVDA	Stock	0.752	0.7575	0.7502	0.7517	517200.0
2007-08-20 08:30:00	NVDA	Stock	0.7517	0.7525	0.751	0.7523	258300.0
2007-08-20 09:00:00	NVDA	Stock	0.7525	0.7552	0.7518	0.755	987840.0
2007-08-20 09:30:00	NVDA	Stock	0.7528	0.7567	0.7392	0.7478	67052460.0
2007-08-20 10:00:00	NVDA	Stock	0.7478	0.76	0.7475	0.7548	48539100.0
2007-08-20 10:30:00	NVDA	Stock	0.7547	0.7567	0.7485	0.7507	30746580.0
2007-08-20 11:00:00	NVDA	Stock	0.7507	0.7528	0.7453	0.751	33136860.0
2007-08-20 11:30:00	NVDA	Stock	0.751	0.7555	0.75	0.7528	21632760.0
2007-08-20 12:00:00	NVDA	Stock	0.7528	0.7535	0.7482	0.7513	20047740.0
2007-08-20 12:30:00	NVDA	Stock	0.7513	0.7537	0.7495	0.75	18286260.0
2007-08-20 13:00:00	NVDA	Stock	0.75	0.7535	0.7497	0.7515	19699200.0
2007-08-20 13:30:00	NVDA	Stock	0.7512	0.7515	0.7465	0.747	40378680.0
2007-08-20 14:00:00	NVDA	Stock	0.7473	0.7487	0.7418	0.7428	33457260.0
2007-08-20 14:30:00	NVDA	Stock	0.7428	0.7466	0.7397	0.7447	34927200.0
2007-08-20 15:00:00	NVDA	Stock	0.7447	0.7533	0.7442	0.752	45183720.0
2007-08-20 15:30:00	NVDA	Stock	0.752	0.7542	0.7467	0.7485	74845320.0
2007-08-20 16:00:00	NVDA	Stock	0.7485	0.7485	0.7483	0.7483	4584000.0
2007-08-20 16:30:00	NVDA	Stock	0.7475	0.7475	0.7475	0.7475	120000.0
2007-08-20 19:00:00	NVDA	Stock	0.7482	0.7482	0.7482	0.7482	6000.0
2007-08-20 06:30:00	AMZN	Stock	3.775	3.775	3.775	3.775	2000.0
2007-08-20 07:00:00	AMZN	Stock	3.7755	3.7825	3.7755	3.7825	22000.0

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

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