PREVIEW / stock_30min / 2007-06-29

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-29.parquet
  size:    1.1 MB
  rows:    64,080
  symbols: 3,066

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-06-29 09:30:00	AAPL	Stock	4.3561	4.3907	4.3321	4.37	151233544.0
2007-06-29 10:00:00	AAPL	Stock	4.3696	4.3729	4.3479	4.3696	87130456.0
2007-06-29 10:30:00	AAPL	Stock	4.3696	4.3771	4.36	4.3736	49787528.0
2007-06-29 11:00:00	AAPL	Stock	4.3739	4.3946	4.3639	4.3946	82216176.0
2007-06-29 11:30:00	AAPL	Stock	4.3943	4.4286	4.3629	4.4057	127220044.0
2007-06-29 12:00:00	AAPL	Stock	4.4061	4.4189	4.3793	4.3829	76966316.0
2007-06-29 12:30:00	AAPL	Stock	4.3829	4.3979	4.3671	4.392	58656248.0
2007-06-29 13:00:00	AAPL	Stock	4.3921	4.4071	4.3696	4.4022	43973636.0
2007-06-29 13:30:00	AAPL	Stock	4.4021	4.4196	4.3964	4.4121	51497292.0
2007-06-29 14:00:00	AAPL	Stock	4.4121	4.4121	4.3818	4.3857	74512956.0
2007-06-29 14:30:00	AAPL	Stock	4.3857	4.3904	4.3789	4.3807	51006032.0
2007-06-29 15:00:00	AAPL	Stock	4.3807	4.3857	4.3246	4.3411	120825936.0
2007-06-29 15:30:00	AAPL	Stock	4.3411	4.3732	4.3368	4.3596	106900724.0
2007-06-29 16:00:00	AAPL	Stock	4.36	4.36	4.3586	4.3586	14222320.0
2007-06-29 09:30:00	MSFT	Stock	29.87	29.93	29.85	29.87	3899222.0
2007-06-29 10:00:00	MSFT	Stock	29.86	29.912	29.8	29.84	3544963.0
2007-06-29 10:30:00	MSFT	Stock	29.84	29.86	29.77	29.81	2500095.0
2007-06-29 11:00:00	MSFT	Stock	29.81	29.82	29.59	29.68	3787395.0
2007-06-29 11:30:00	MSFT	Stock	29.685	29.69	29.55	29.56	2862360.0
2007-06-29 12:00:00	MSFT	Stock	29.57	29.58	29.51	29.53	2240138.0
2007-06-29 12:30:00	MSFT	Stock	29.53	29.56	29.49	29.51	2353838.0
2007-06-29 13:00:00	MSFT	Stock	29.51	29.55	29.46	29.52	3091514.0
2007-06-29 13:30:00	MSFT	Stock	29.52	29.59	29.5	29.51	3176276.0
2007-06-29 14:00:00	MSFT	Stock	29.5	29.51	29.37	29.41	4098425.0
2007-06-29 14:30:00	MSFT	Stock	29.403	29.42	29.29	29.32	5194734.0
2007-06-29 15:00:00	MSFT	Stock	29.315	29.34	29.04	29.14	9853930.0
2007-06-29 15:30:00	MSFT	Stock	29.14	29.48	29.12	29.47	12174771.0
2007-06-29 16:00:00	MSFT	Stock	29.47	29.47	29.47	29.47	3967666.0
2007-06-29 09:00:00	NVDA	Stock	0.7053	0.7053	0.6997	0.7042	452400.0
2007-06-29 09:30:00	NVDA	Stock	0.7045	0.7047	0.6938	0.6972	44418060.0
2007-06-29 10:00:00	NVDA	Stock	0.697	0.6983	0.6945	0.6955	32650800.0
2007-06-29 10:30:00	NVDA	Stock	0.6953	0.6975	0.691	0.6975	31129860.0
2007-06-29 11:00:00	NVDA	Stock	0.6973	0.6983	0.6935	0.6975	48955380.0
2007-06-29 11:30:00	NVDA	Stock	0.6975	0.6988	0.6942	0.6943	21089760.0
2007-06-29 12:00:00	NVDA	Stock	0.6943	0.6947	0.6917	0.6938	37657260.0
2007-06-29 12:30:00	NVDA	Stock	0.6938	0.6973	0.692	0.6967	29601960.0
2007-06-29 13:00:00	NVDA	Stock	0.6968	0.6983	0.6948	0.697	19385400.0
2007-06-29 13:30:00	NVDA	Stock	0.697	0.6982	0.6958	0.6975	16057200.0
2007-06-29 14:00:00	NVDA	Stock	0.6975	0.6978	0.6938	0.6952	22634220.0
2007-06-29 14:30:00	NVDA	Stock	0.695	0.6968	0.6947	0.6957	14417880.0
2007-06-29 15:00:00	NVDA	Stock	0.6957	0.6965	0.6903	0.6912	52740420.0
2007-06-29 15:30:00	NVDA	Stock	0.6912	0.6923	0.6882	0.6883	107909880.0
2007-06-29 16:00:00	NVDA	Stock	0.6887	0.6888	0.6883	0.6888	23392200.0
2007-06-29 16:30:00	NVDA	Stock	0.6888	0.689	0.6877	0.6888	211800.0
2007-06-29 17:30:00	NVDA	Stock	0.69	0.69	0.69	0.69	15000.0
2007-06-29 18:00:00	NVDA	Stock	0.69	0.69	0.69	0.69	6000.0
2007-06-29 18:30:00	NVDA	Stock	0.6892	0.6892	0.6892	0.6892	234000.0
2007-06-29 19:00:00	NVDA	Stock	0.6892	0.6892	0.6873	0.6873	77100.0
2007-06-29 19:30:00	NVDA	Stock	0.6892	0.6892	0.6892	0.6892	70440.0
2007-06-29 08:00:00	AMZN	Stock	3.4495	3.4495	3.4355	3.436	18040.0

> showing 50 of 64,080 rows — these rows as CSV

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