PREVIEW / stock_30min / 2007-04-09

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-09.parquet
  size:    1.0 MB
  rows:    55,002
  symbols: 2,582

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-04-09 07:30:00	AAPL	Stock	3.3836	3.3925	3.3836	3.3925	16800.0
2007-04-09 08:00:00	AAPL	Stock	3.3836	3.4007	3.3829	3.3971	1425900.0
2007-04-09 08:30:00	AAPL	Stock	3.3964	3.41	3.3946	3.4071	1785420.0
2007-04-09 09:00:00	AAPL	Stock	3.4071	3.4089	3.3993	3.4007	1920632.0
2007-04-09 09:30:00	AAPL	Stock	3.4004	3.4036	3.3661	3.3721	81560612.0
2007-04-09 10:00:00	AAPL	Stock	3.3721	3.3754	3.3457	3.3621	66679284.0
2007-04-09 10:30:00	AAPL	Stock	3.3618	3.3661	3.3536	3.3614	27977236.0
2007-04-09 11:00:00	AAPL	Stock	3.3618	3.3689	3.3618	3.3675	21913416.0
2007-04-09 11:30:00	AAPL	Stock	3.3675	3.3727	3.3639	3.3664	22780828.0
2007-04-09 12:00:00	AAPL	Stock	3.3664	3.3696	3.3643	3.3682	8244740.0
2007-04-09 12:30:00	AAPL	Stock	3.3686	3.375	3.3671	3.3711	19394872.0
2007-04-09 13:00:00	AAPL	Stock	3.3707	3.3746	3.3668	3.37	15422876.0
2007-04-09 13:30:00	AAPL	Stock	3.37	3.3704	3.3557	3.3561	18876144.0
2007-04-09 14:00:00	AAPL	Stock	3.3561	3.3575	3.35	3.3575	29889580.0
2007-04-09 14:30:00	AAPL	Stock	3.3575	3.3625	3.3536	3.3596	20029268.0
2007-04-09 15:00:00	AAPL	Stock	3.3593	3.3646	3.3229	3.3575	17532200.0
2007-04-09 15:30:00	AAPL	Stock	3.3571	3.3654	3.3429	3.3429	49214900.0
2007-04-09 16:00:00	AAPL	Stock	3.3432	3.3454	3.3414	3.3439	3287900.0
2007-04-09 16:30:00	AAPL	Stock	3.3443	3.3447	3.3425	3.3443	584444.0
2007-04-09 17:00:00	AAPL	Stock	3.3436	3.3446	3.3432	3.3432	58744.0
2007-04-09 17:30:00	AAPL	Stock	3.3446	3.3446	3.3429	3.3446	98644.0
2007-04-09 18:00:00	AAPL	Stock	3.3454	3.3464	3.3454	3.3464	33600.0
2007-04-09 18:30:00	AAPL	Stock	3.345	3.3496	3.345	3.3496	33740.0
2007-04-09 19:00:00	AAPL	Stock	3.3479	3.3482	3.345	3.345	57344.0
2007-04-09 19:30:00	AAPL	Stock	3.3464	3.3489	3.3446	3.3446	154700.0
2007-04-09 07:00:00	MSFT	Stock	28.6	28.6	28.6	28.6	308.0
2007-04-09 08:30:00	MSFT	Stock	28.62	28.62	28.62	28.62	310.0
2007-04-09 09:00:00	MSFT	Stock	28.64	28.67	28.56	28.57	20708.0
2007-04-09 09:30:00	MSFT	Stock	28.57	28.6	28.39	28.482	3583828.0
2007-04-09 10:00:00	MSFT	Stock	28.48	28.49	28.39	28.45	2221769.0
2007-04-09 10:30:00	MSFT	Stock	28.45	28.58	28.44	28.58	2042212.0
2007-04-09 11:00:00	MSFT	Stock	28.57	28.63	28.54	28.57	2490814.0
2007-04-09 11:30:00	MSFT	Stock	28.57	28.59	28.49	28.5	1721607.0
2007-04-09 12:00:00	MSFT	Stock	28.5	28.54	28.5	28.5	1237772.0
2007-04-09 12:30:00	MSFT	Stock	28.5	28.67	28.5	28.63	2445219.0
2007-04-09 13:00:00	MSFT	Stock	28.62	28.65	28.52	28.53	1470158.0
2007-04-09 13:30:00	MSFT	Stock	28.53	28.59	28.5	28.52	1520951.0
2007-04-09 14:00:00	MSFT	Stock	28.52	28.55	28.48	28.481	1782811.0
2007-04-09 14:30:00	MSFT	Stock	28.48	28.6	28.47	28.6	1337141.0
2007-04-09 15:00:00	MSFT	Stock	28.59	28.63	28.58	28.63	2487783.0
2007-04-09 15:30:00	MSFT	Stock	28.63	28.72	28.56	28.57	6471340.0
2007-04-09 16:00:00	MSFT	Stock	28.57	28.57	28.53	28.54	106030.0
2007-04-09 16:30:00	MSFT	Stock	28.53	28.573	28.52	28.55	87260.0
2007-04-09 18:30:00	MSFT	Stock	28.52	28.72	28.52	28.72	700.0
2007-04-09 19:30:00	MSFT	Stock	28.61	28.62	28.6	28.62	3755.0
2007-04-09 08:00:00	NVDA	Stock	0.5163	0.5205	0.5163	0.5187	574680.0
2007-04-09 08:30:00	NVDA	Stock	0.519	0.5203	0.519	0.5192	120000.0
2007-04-09 09:00:00	NVDA	Stock	0.5185	0.519	0.5143	0.5145	2243100.0
2007-04-09 09:30:00	NVDA	Stock	0.515	0.5208	0.5113	0.5155	137907300.0
2007-04-09 10:00:00	NVDA	Stock	0.5157	0.516	0.5058	0.5087	86640660.0

> showing 50 of 55,002 rows — these rows as CSV

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