PREVIEW / stock_30min / 2007-03-02

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-02.parquet
  size:    987 KB
  rows:    53,197
  symbols: 2,490

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-03-02 07:00:00	AAPL	Stock	3.0757	3.1089	3.0757	3.1089	204400.0
2007-03-02 07:30:00	AAPL	Stock	3.1061	3.1061	3.0896	3.0982	227080.0
2007-03-02 08:00:00	AAPL	Stock	3.0982	3.1036	3.0839	3.0946	2587648.0
2007-03-02 08:30:00	AAPL	Stock	3.0946	3.0979	3.0932	3.0964	1582588.0
2007-03-02 09:00:00	AAPL	Stock	3.0961	3.0986	3.0925	3.0986	1654856.0
2007-03-02 09:30:00	AAPL	Stock	3.0989	3.1264	3.0918	3.0993	152425896.0
2007-03-02 10:00:00	AAPL	Stock	3.0993	3.1132	3.0929	3.1039	74595948.0
2007-03-02 10:30:00	AAPL	Stock	3.1039	3.1161	3.1007	3.1129	55131048.0
2007-03-02 11:00:00	AAPL	Stock	3.1125	3.1132	3.1011	3.1032	38416168.0
2007-03-02 11:30:00	AAPL	Stock	3.1029	3.1036	3.0843	3.0914	52303636.0
2007-03-02 12:00:00	AAPL	Stock	3.0918	3.0996	3.0675	3.0729	58224684.0
2007-03-02 12:30:00	AAPL	Stock	3.0725	3.0732	3.0543	3.0679	74499740.0
2007-03-02 13:00:00	AAPL	Stock	3.0679	3.0732	3.0432	3.0518	61811540.0
2007-03-02 13:30:00	AAPL	Stock	3.0529	3.0639	3.0471	3.0632	53915232.0
2007-03-02 14:00:00	AAPL	Stock	3.0629	3.065	3.0471	3.0564	48787004.0
2007-03-02 14:30:00	AAPL	Stock	3.0561	3.1	3.0539	3.0671	54034232.0
2007-03-02 15:00:00	AAPL	Stock	3.0675	3.0725	3.055	3.0589	45283280.0
2007-03-02 15:30:00	AAPL	Stock	3.0586	3.0639	3.0507	3.0511	69606684.0
2007-03-02 16:00:00	AAPL	Stock	3.05	3.055	3.05	3.0518	3901716.0
2007-03-02 16:30:00	AAPL	Stock	3.0518	3.055	3.0504	3.0536	188720.0
2007-03-02 17:00:00	AAPL	Stock	3.0536	3.0557	3.0518	3.0539	92400.0
2007-03-02 17:30:00	AAPL	Stock	3.0554	3.0579	3.0536	3.0579	111720.0
2007-03-02 18:00:00	AAPL	Stock	3.0557	3.0557	3.0557	3.0557	25200.0
2007-03-02 18:30:00	AAPL	Stock	3.0557	3.0607	3.0554	3.0582	51800.0
2007-03-02 19:00:00	AAPL	Stock	3.0564	3.0582	3.0557	3.0557	46200.0
2007-03-02 19:30:00	AAPL	Stock	3.0557	3.0557	3.0536	3.0536	133028.0
2007-03-02 07:00:00	MSFT	Stock	27.9	27.9	27.9	27.9	100.0
2007-03-02 07:30:00	MSFT	Stock	27.92	27.92	27.92	27.92	1000.0
2007-03-02 08:00:00	MSFT	Stock	28.0	28.02	27.93	27.99	31900.0
2007-03-02 08:30:00	MSFT	Stock	27.97	28.0	27.97	28.0	6990.0
2007-03-02 09:00:00	MSFT	Stock	28.0	28.04	28.0	28.02	89000.0
2007-03-02 09:30:00	MSFT	Stock	28.02	28.16	28.0	28.0	5906277.0
2007-03-02 10:00:00	MSFT	Stock	28.0	28.06	27.97	28.0	3540072.0
2007-03-02 10:30:00	MSFT	Stock	27.99	28.15	27.99	28.03	3642931.0
2007-03-02 11:00:00	MSFT	Stock	28.03	28.06	28.01	28.01	3134679.0
2007-03-02 11:30:00	MSFT	Stock	28.02	28.02	27.93	27.96	3323114.0
2007-03-02 12:00:00	MSFT	Stock	27.96	28.01	27.88	27.88	5249525.0
2007-03-02 12:30:00	MSFT	Stock	27.88	27.95	27.84	27.93	6863049.0
2007-03-02 13:00:00	MSFT	Stock	27.93	27.95	27.8	27.82	6755042.0
2007-03-02 13:30:00	MSFT	Stock	27.81	27.9	27.79	27.86	3961881.0
2007-03-02 14:00:00	MSFT	Stock	27.86	28.09	27.84	27.89	2559857.0
2007-03-02 14:30:00	MSFT	Stock	27.89	28.0	27.88	27.91	3993040.0
2007-03-02 15:00:00	MSFT	Stock	27.9	27.95	27.89	27.9	3562812.0
2007-03-02 15:30:00	MSFT	Stock	27.9	27.93	27.76	27.76	8077942.0
2007-03-02 16:00:00	MSFT	Stock	27.77	27.77	27.75	27.76	120922.0
2007-03-02 16:30:00	MSFT	Stock	27.76	27.76	27.74	27.75	21090.0
2007-03-02 17:00:00	MSFT	Stock	27.78	27.78	27.76	27.76	307.0
2007-03-02 17:30:00	MSFT	Stock	27.78	27.78	27.77	27.77	900.0
2007-03-02 18:00:00	MSFT	Stock	27.79	27.79	27.78	27.78	1396.0
2007-03-02 18:30:00	MSFT	Stock	27.77	27.77	27.76	27.76	200.0

> showing 50 of 53,197 rows — these rows as CSV

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