PREVIEW / stock_30min / 2007-01-25

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-25.parquet
  size:    983 KB
  rows:    52,950
  symbols: 2,499

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-25 05:30:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	11200.0
2007-01-25 06:00:00	AAPL	Stock	3.1004	3.1025	3.1	3.1	33600.0
2007-01-25 06:30:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	28000.0
2007-01-25 07:00:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	93240.0
2007-01-25 07:30:00	AAPL	Stock	3.1071	3.1111	3.1071	3.1107	115864.0
2007-01-25 08:00:00	AAPL	Stock	3.1011	3.1071	3.0964	3.0964	974736.0
2007-01-25 08:30:00	AAPL	Stock	3.0968	3.1043	3.0961	3.1018	674520.0
2007-01-25 09:00:00	AAPL	Stock	3.1014	3.1125	3.1004	3.1125	2032156.0
2007-01-25 09:30:00	AAPL	Stock	3.1111	3.1607	3.1036	3.1464	183681764.0
2007-01-25 10:00:00	AAPL	Stock	3.1464	3.1536	3.1186	3.1254	124483912.0
2007-01-25 10:30:00	AAPL	Stock	3.1256	3.1375	3.1139	3.125	74355792.0
2007-01-25 11:00:00	AAPL	Stock	3.1254	3.1296	3.1143	3.1164	49546280.0
2007-01-25 11:30:00	AAPL	Stock	3.1164	3.1204	3.1096	3.1161	46939648.0
2007-01-25 12:00:00	AAPL	Stock	3.1164	3.1186	3.0921	3.0989	66746792.0
2007-01-25 12:30:00	AAPL	Stock	3.0993	3.1129	3.0989	3.1068	36976604.0
2007-01-25 13:00:00	AAPL	Stock	3.1068	3.1179	3.1025	3.1146	29965712.0
2007-01-25 13:30:00	AAPL	Stock	3.1146	3.1154	3.0911	3.0918	46792088.0
2007-01-25 14:00:00	AAPL	Stock	3.0918	3.1021	3.0893	3.0957	61746636.0
2007-01-25 14:30:00	AAPL	Stock	3.0964	3.1007	3.09	3.0921	36051624.0
2007-01-25 15:00:00	AAPL	Stock	3.0925	3.0925	3.0725	3.0871	77950740.0
2007-01-25 15:30:00	AAPL	Stock	3.0879	3.0893	3.0786	3.0804	59939992.0
2007-01-25 16:00:00	AAPL	Stock	3.0804	3.0904	3.0804	3.0896	1133216.0
2007-01-25 16:30:00	AAPL	Stock	3.0893	3.0904	3.0843	3.0857	651420.0
2007-01-25 17:00:00	AAPL	Stock	3.0857	3.0893	3.0821	3.0821	449904.0
2007-01-25 17:30:00	AAPL	Stock	3.0829	3.0893	3.0829	3.0875	116508.0
2007-01-25 18:00:00	AAPL	Stock	3.0804	3.0875	3.0804	3.0875	101864.0
2007-01-25 18:30:00	AAPL	Stock	3.0875	3.0893	3.0857	3.0879	365652.0
2007-01-25 19:00:00	AAPL	Stock	3.0893	3.1036	3.0886	3.0886	308784.0
2007-01-25 19:30:00	AAPL	Stock	3.0886	3.0929	3.0886	3.0893	64708.0
2007-01-25 04:00:00	MSFT	Stock	31.12	31.2	31.12	31.2	700.0
2007-01-25 06:30:00	MSFT	Stock	31.17	31.18	31.12	31.12	4100.0
2007-01-25 07:00:00	MSFT	Stock	31.16	31.16	31.16	31.16	300.0
2007-01-25 07:30:00	MSFT	Stock	31.15	31.15	31.11	31.11	500.0
2007-01-25 08:00:00	MSFT	Stock	31.15	31.22	31.1	31.18	34844.0
2007-01-25 08:30:00	MSFT	Stock	31.19	31.22	31.16	31.18	166178.0
2007-01-25 09:00:00	MSFT	Stock	31.2	31.23	31.04	31.08	157761.0
2007-01-25 09:30:00	MSFT	Stock	31.08	31.45	31.0	31.37	10966139.0
2007-01-25 10:00:00	MSFT	Stock	31.38	31.48	31.17	31.2	7543389.0
2007-01-25 10:30:00	MSFT	Stock	31.2	31.24	31.03	31.11	4275505.0
2007-01-25 11:00:00	MSFT	Stock	31.12	31.32	31.11	31.28	3639341.0
2007-01-25 11:30:00	MSFT	Stock	31.27	31.3	31.13	31.17	2448198.0
2007-01-25 12:00:00	MSFT	Stock	31.16	31.19	30.99	31.001	4501881.0
2007-01-25 12:30:00	MSFT	Stock	31.0	31.081	30.83	30.878	5042378.0
2007-01-25 13:00:00	MSFT	Stock	30.88	30.96	30.813	30.93	4897626.0
2007-01-25 13:30:00	MSFT	Stock	30.92	30.93	30.7	30.72	5038461.0
2007-01-25 14:00:00	MSFT	Stock	30.71	30.83	30.63	30.661	6852917.0
2007-01-25 14:30:00	MSFT	Stock	30.67	30.75	30.47	30.63	8266743.0
2007-01-25 15:00:00	MSFT	Stock	30.63	30.73	30.47	30.7	8126343.0
2007-01-25 15:30:00	MSFT	Stock	30.7	30.75	30.46	30.46	9830165.0
2007-01-25 16:00:00	MSFT	Stock	30.49	31.6	30.07	31.44	7855627.0

> showing 50 of 52,950 rows — these rows as CSV

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