PREVIEW / stock_30min / 2008-03-10

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-10.parquet
  size:    1.2 MB
  rows:    70,669
  symbols: 3,290

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-03-10 05:00:00	AAPL	Stock	4.3746	4.3746	4.3746	4.3746	11200.0
2008-03-10 05:30:00	AAPL	Stock	4.3746	4.3746	4.3746	4.3746	2800.0
2008-03-10 06:30:00	AAPL	Stock	4.3921	4.3921	4.3921	4.3921	2800.0
2008-03-10 07:00:00	AAPL	Stock	4.39	4.4104	4.39	4.4104	57400.0
2008-03-10 07:30:00	AAPL	Stock	4.3975	4.4118	4.3929	4.3964	196672.0
2008-03-10 08:00:00	AAPL	Stock	4.3964	4.4025	4.3661	4.3714	1089116.0
2008-03-10 08:30:00	AAPL	Stock	4.3696	4.3743	4.3396	4.3607	995820.0
2008-03-10 09:00:00	AAPL	Stock	4.3607	4.3668	4.3557	4.3607	866684.0
2008-03-10 09:30:00	AAPL	Stock	4.3564	4.4011	4.3261	4.3771	114405368.0
2008-03-10 10:00:00	AAPL	Stock	4.3771	4.3921	4.345	4.3482	88972184.0
2008-03-10 10:30:00	AAPL	Stock	4.3483	4.4093	4.3464	4.3896	92257760.0
2008-03-10 11:00:00	AAPL	Stock	4.3896	4.4021	4.345	4.3461	74899356.0
2008-03-10 11:30:00	AAPL	Stock	4.3461	4.3596	4.3332	4.3496	66800300.0
2008-03-10 12:00:00	AAPL	Stock	4.3504	4.3568	4.2932	4.2996	89190808.0
2008-03-10 12:30:00	AAPL	Stock	4.2999	4.3257	4.2946	4.3243	50508696.0
2008-03-10 13:00:00	AAPL	Stock	4.3246	4.3321	4.3007	4.3079	45204516.0
2008-03-10 13:30:00	AAPL	Stock	4.3079	4.3161	4.2986	4.3	44432724.0
2008-03-10 14:00:00	AAPL	Stock	4.2996	4.3084	4.2632	4.2836	78138312.0
2008-03-10 14:30:00	AAPL	Stock	4.2836	4.3121	4.2818	4.2921	63950432.0
2008-03-10 15:00:00	AAPL	Stock	4.2921	4.3125	4.2804	4.3125	67193196.0
2008-03-10 15:30:00	AAPL	Stock	4.3121	4.315	4.2721	4.2759	97996080.0
2008-03-10 16:00:00	AAPL	Stock	4.2757	4.332	4.2643	4.2686	20119736.0
2008-03-10 16:30:00	AAPL	Stock	4.2661	4.3661	4.25	4.2536	1371300.0
2008-03-10 17:00:00	AAPL	Stock	4.2525	4.305	4.2518	4.2586	385028.0
2008-03-10 17:30:00	AAPL	Stock	4.2571	4.332	4.2571	4.2704	733516.0
2008-03-10 18:00:00	AAPL	Stock	4.2682	4.2746	4.2643	4.2696	166880.0
2008-03-10 18:30:00	AAPL	Stock	4.2746	4.275	4.2625	4.2661	466424.0
2008-03-10 19:00:00	AAPL	Stock	4.2632	4.2654	4.2561	4.2604	127232.0
2008-03-10 19:30:00	AAPL	Stock	4.2571	4.2639	4.2554	4.2639	154336.0
2008-03-10 07:30:00	MSFT	Stock	28.09	28.1	28.09	28.1	800.0
2008-03-10 08:00:00	MSFT	Stock	28.0	28.0	27.9	27.9	1430.0
2008-03-10 08:30:00	MSFT	Stock	27.81	27.88	27.81	27.88	791.0
2008-03-10 09:00:00	MSFT	Stock	27.83	27.88	27.81	27.81	16431.0
2008-03-10 09:30:00	MSFT	Stock	27.81	28.2	27.75	28.16	5772853.0
2008-03-10 10:00:00	MSFT	Stock	28.16	28.26	28.02	28.05	6836188.0
2008-03-10 10:30:00	MSFT	Stock	28.06	28.15	27.99	28.09	4821702.0
2008-03-10 11:00:00	MSFT	Stock	28.08	28.2	27.95	27.97	4363397.0
2008-03-10 11:30:00	MSFT	Stock	27.98	28.1	27.97	28.09	4660204.0
2008-03-10 12:00:00	MSFT	Stock	28.082	28.14	27.98	28.07	5223549.0
2008-03-10 12:30:00	MSFT	Stock	28.06	28.22	28.05	28.182	3910929.0
2008-03-10 13:00:00	MSFT	Stock	28.19	28.19	27.99	28.07	4068286.0
2008-03-10 13:30:00	MSFT	Stock	28.08	28.16	28.07	28.095	3109480.0
2008-03-10 14:00:00	MSFT	Stock	28.09	28.1	27.87	27.928	5875999.0
2008-03-10 14:30:00	MSFT	Stock	27.925	28.05	27.91	28.04	3038010.0
2008-03-10 15:00:00	MSFT	Stock	28.04	28.11	27.98	28.1	4592083.0
2008-03-10 15:30:00	MSFT	Stock	28.08	28.152	27.98	28.06	12041021.0
2008-03-10 16:00:00	MSFT	Stock	28.09	28.09	28.02	28.07	3297436.0
2008-03-10 16:30:00	MSFT	Stock	28.05	28.05	27.87	28.0	86295.0
2008-03-10 17:00:00	MSFT	Stock	28.073	28.073	27.99	28.02	454633.0
2008-03-10 17:30:00	MSFT	Stock	27.99	28.05	27.99	28.0	40509.0

> showing 50 of 70,669 rows — these rows as CSV

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