PREVIEW / stock_30min / 2008-02-21

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-21.parquet
  size:    1.2 MB
  rows:    67,864
  symbols: 3,245

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-02-21 05:30:00	AAPL	Stock	4.4464	4.4464	4.4457	4.4457	47600.0
2008-02-21 06:00:00	AAPL	Stock	4.4643	4.4643	4.4643	4.4643	47600.0
2008-02-21 06:30:00	AAPL	Stock	4.4857	4.5	4.4857	4.5	61600.0
2008-02-21 07:00:00	AAPL	Stock	4.5	4.525	4.4911	4.525	575036.0
2008-02-21 07:30:00	AAPL	Stock	4.5271	4.5318	4.5111	4.5121	598080.0
2008-02-21 08:00:00	AAPL	Stock	4.5179	4.525	4.4832	4.4971	3063368.0
2008-02-21 08:30:00	AAPL	Stock	4.4943	4.5054	4.4911	4.5036	2920344.0
2008-02-21 09:00:00	AAPL	Stock	4.5043	4.5086	4.4914	4.5018	1997884.0
2008-02-21 09:30:00	AAPL	Stock	4.5021	4.5168	4.4564	4.4721	126098028.0
2008-02-21 10:00:00	AAPL	Stock	4.4732	4.4736	4.43	4.4532	86656920.0
2008-02-21 10:30:00	AAPL	Stock	4.4539	4.4568	4.3725	4.3729	96606636.0
2008-02-21 11:00:00	AAPL	Stock	4.3718	4.3886	4.3579	4.3675	90278300.0
2008-02-21 11:30:00	AAPL	Stock	4.3675	4.4082	4.3664	4.4	55493116.0
2008-02-21 12:00:00	AAPL	Stock	4.4004	4.4004	4.3679	4.3793	38549028.0
2008-02-21 12:30:00	AAPL	Stock	4.38	4.3836	4.3636	4.3829	31492384.0
2008-02-21 13:00:00	AAPL	Stock	4.3825	4.3896	4.3682	4.3889	33804512.0
2008-02-21 13:30:00	AAPL	Stock	4.39	4.3907	4.3607	4.3707	40892908.0
2008-02-21 14:00:00	AAPL	Stock	4.3707	4.3925	4.3661	4.3907	46384968.0
2008-02-21 14:30:00	AAPL	Stock	4.3914	4.3993	4.3621	4.3682	50685964.0
2008-02-21 15:00:00	AAPL	Stock	4.3682	4.3693	4.3239	4.3325	97686624.0
2008-02-21 15:30:00	AAPL	Stock	4.3325	4.3482	4.3164	4.3439	110346096.0
2008-02-21 16:00:00	AAPL	Stock	4.3439	4.3953	4.3321	4.3563	22815184.0
2008-02-21 16:30:00	AAPL	Stock	4.3421	4.3429	4.3393	4.3393	1835148.0
2008-02-21 17:00:00	AAPL	Stock	4.3418	4.3425	4.3375	4.3393	509208.0
2008-02-21 17:30:00	AAPL	Stock	4.4221	4.4221	4.3386	4.3386	3639244.0
2008-02-21 18:00:00	AAPL	Stock	4.3411	4.3414	4.3393	4.34	78904.0
2008-02-21 18:30:00	AAPL	Stock	4.3418	4.3457	4.3393	4.3457	249508.0
2008-02-21 19:00:00	AAPL	Stock	4.3457	4.3461	4.3446	4.3446	98504.0
2008-02-21 19:30:00	AAPL	Stock	4.3464	4.3493	4.3432	4.3493	224840.0
2008-02-21 07:30:00	MSFT	Stock	28.5	28.5	28.5	28.5	100.0
2008-02-21 08:00:00	MSFT	Stock	28.4	28.44	28.34	28.35	48045.0
2008-02-21 08:30:00	MSFT	Stock	28.35	28.75	28.35	28.62	1405975.0
2008-02-21 09:00:00	MSFT	Stock	28.61	28.69	28.6	28.62	390695.0
2008-02-21 09:30:00	MSFT	Stock	28.63	28.8	28.57	28.79	11502311.0
2008-02-21 10:00:00	MSFT	Stock	28.79	28.96	28.72	28.86	14102843.0
2008-02-21 10:30:00	MSFT	Stock	28.85	28.9	28.35	28.37	12917451.0
2008-02-21 11:00:00	MSFT	Stock	28.38	28.48	28.26	28.35	6889378.0
2008-02-21 11:30:00	MSFT	Stock	28.36	28.4	28.25	28.31	4316688.0
2008-02-21 12:00:00	MSFT	Stock	28.31	28.32	28.19	28.24	3270021.0
2008-02-21 12:30:00	MSFT	Stock	28.242	28.29	28.14	28.28	4767258.0
2008-02-21 13:00:00	MSFT	Stock	28.28	28.29	28.16	28.28	3713042.0
2008-02-21 13:30:00	MSFT	Stock	28.29	28.34	28.16	28.26	3703110.0
2008-02-21 14:00:00	MSFT	Stock	28.26	28.33	28.2	28.3	2973050.0
2008-02-21 14:30:00	MSFT	Stock	28.3	28.34	28.182	28.218	3574061.0
2008-02-21 15:00:00	MSFT	Stock	28.215	28.22	28.07	28.14	5833453.0
2008-02-21 15:30:00	MSFT	Stock	28.149	28.2	27.96	28.12	11870728.0
2008-02-21 16:00:00	MSFT	Stock	28.113	28.426	28.09	28.148	6860620.0
2008-02-21 16:30:00	MSFT	Stock	28.1	28.15	28.1	28.1	262077.0
2008-02-21 17:00:00	MSFT	Stock	28.12	28.13	28.1	28.13	15560.0
2008-02-21 17:30:00	MSFT	Stock	28.22	28.22	28.12	28.16	427941.0

> showing 50 of 67,864 rows — these rows as CSV

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