PREVIEW / stock_30min / 2007-01-24

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-24.parquet
  size:    1002 KB
  rows:    54,269
  symbols: 2,506

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-01-24 06:00:00	AAPL	Stock	3.0736	3.0761	3.0721	3.0721	42000.0
2007-01-24 07:00:00	AAPL	Stock	3.0807	3.0961	3.0807	3.0839	635600.0
2007-01-24 07:30:00	AAPL	Stock	3.0839	3.0875	3.0839	3.0854	50400.0
2007-01-24 08:00:00	AAPL	Stock	3.0821	3.0857	3.0786	3.0821	914060.0
2007-01-24 08:30:00	AAPL	Stock	3.0814	3.0857	3.0793	3.0821	1083236.0
2007-01-24 09:00:00	AAPL	Stock	3.0821	3.0971	3.0811	3.0961	2897804.0
2007-01-24 09:30:00	AAPL	Stock	3.0957	3.1036	3.0743	3.0932	155054508.0
2007-01-24 10:00:00	AAPL	Stock	3.0936	3.1	3.0754	3.0843	93403940.0
2007-01-24 10:30:00	AAPL	Stock	3.0839	3.1004	3.0804	3.0954	94781232.0
2007-01-24 11:00:00	AAPL	Stock	3.0954	3.1093	3.0936	3.1021	90695304.0
2007-01-24 11:30:00	AAPL	Stock	3.1025	3.1125	3.0986	3.1052	52965808.0
2007-01-24 12:00:00	AAPL	Stock	3.1054	3.1079	3.0982	3.1018	37798124.0
2007-01-24 12:30:00	AAPL	Stock	3.1018	3.105	3.0875	3.0957	38951360.0
2007-01-24 13:00:00	AAPL	Stock	3.0957	3.0957	3.0857	3.0875	33115684.0
2007-01-24 13:30:00	AAPL	Stock	3.0871	3.0932	3.0804	3.0907	57165640.0
2007-01-24 14:00:00	AAPL	Stock	3.0909	3.0929	3.0839	3.0918	39686584.0
2007-01-24 14:30:00	AAPL	Stock	3.0921	3.1	3.0857	3.0871	47715024.0
2007-01-24 15:00:00	AAPL	Stock	3.0871	3.0889	3.0807	3.0875	52215800.0
2007-01-24 15:30:00	AAPL	Stock	3.0879	3.1	3.0804	3.0964	92963892.0
2007-01-24 16:00:00	AAPL	Stock	3.0961	3.1036	3.0936	3.1	15529864.0
2007-01-24 16:30:00	AAPL	Stock	3.1018	3.1054	3.0964	3.0964	472332.0
2007-01-24 17:00:00	AAPL	Stock	3.1014	3.1036	3.1	3.1036	406588.0
2007-01-24 17:30:00	AAPL	Stock	3.1029	3.1036	3.1018	3.1018	160832.0
2007-01-24 18:00:00	AAPL	Stock	3.1018	3.1036	3.1004	3.1036	276164.0
2007-01-24 18:30:00	AAPL	Stock	3.1036	3.1061	3.1021	3.1054	405608.0
2007-01-24 19:00:00	AAPL	Stock	3.1061	3.1064	3.1061	3.1061	47600.0
2007-01-24 19:30:00	AAPL	Stock	3.1021	3.1071	3.1021	3.1068	124404.0
2007-01-24 08:00:00	MSFT	Stock	30.87	30.9	30.87	30.9	1630.0
2007-01-24 08:30:00	MSFT	Stock	30.9	30.9	30.87	30.87	14263.0
2007-01-24 09:00:00	MSFT	Stock	30.86	30.92	30.78	30.78	165643.0
2007-01-24 09:30:00	MSFT	Stock	30.78	30.89	30.65	30.7	7155684.0
2007-01-24 10:00:00	MSFT	Stock	30.7	30.9	30.69	30.9	4894664.0
2007-01-24 10:30:00	MSFT	Stock	30.899	31.24	30.89	31.2	7222021.0
2007-01-24 11:00:00	MSFT	Stock	31.2	31.3	31.14	31.21	6574736.0
2007-01-24 11:30:00	MSFT	Stock	31.21	31.21	31.11	31.11	3536868.0
2007-01-24 12:00:00	MSFT	Stock	31.11	31.17	31.08	31.14	3932028.0
2007-01-24 12:30:00	MSFT	Stock	31.13	31.18	31.09	31.11	2189961.0
2007-01-24 13:00:00	MSFT	Stock	31.12	31.13	31.04	31.11	2053192.0
2007-01-24 13:30:00	MSFT	Stock	31.11	31.2	31.08	31.17	2733323.0
2007-01-24 14:00:00	MSFT	Stock	31.17	31.18	31.13	31.15	1765804.0
2007-01-24 14:30:00	MSFT	Stock	31.16	31.17	31.1	31.113	3594795.0
2007-01-24 15:00:00	MSFT	Stock	31.11	31.13	30.97	31.031	5350578.0
2007-01-24 15:30:00	MSFT	Stock	31.04	31.1	31.03	31.09	5132341.0
2007-01-24 16:00:00	MSFT	Stock	31.09	31.25	31.05	31.25	185381.0
2007-01-24 16:30:00	MSFT	Stock	31.25	31.25	31.09	31.09	25959.0
2007-01-24 17:00:00	MSFT	Stock	31.2	31.25	31.09	31.23	313125.0
2007-01-24 17:30:00	MSFT	Stock	31.22	31.22	31.08	31.14	4545.0
2007-01-24 18:00:00	MSFT	Stock	31.15	31.2	31.15	31.2	7599.0
2007-01-24 18:30:00	MSFT	Stock	31.2	31.2	31.2	31.2	2015.0
2007-01-24 19:00:00	MSFT	Stock	31.2	31.23	31.2	31.23	4833.0

> showing 50 of 54,269 rows — these rows as CSV

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