PREVIEW / stock_30min / 2007-11-23

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-23.parquet
  size:    765 KB
  rows:    39,236
  symbols: 3,064

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-11-23 05:30:00	AAPL	Stock	6.0764	6.0764	6.0764	6.0764	2800.0
2007-11-23 06:00:00	AAPL	Stock	6.09	6.1429	6.09	6.1429	110600.0
2007-11-23 06:30:00	AAPL	Stock	6.1375	6.1375	6.1075	6.1375	33432.0
2007-11-23 07:00:00	AAPL	Stock	6.1639	6.1639	6.1007	6.1221	179172.0
2007-11-23 07:30:00	AAPL	Stock	6.1221	6.1221	6.0957	6.1071	426720.0
2007-11-23 08:00:00	AAPL	Stock	6.1136	6.1429	6.1029	6.1407	4579932.0
2007-11-23 08:30:00	AAPL	Stock	6.1386	6.1518	6.0164	6.1218	26623940.0
2007-11-23 09:00:00	AAPL	Stock	6.1225	6.1414	6.1143	6.1414	3155432.0
2007-11-23 09:30:00	AAPL	Stock	6.1404	6.1446	6.0771	6.1118	111352752.0
2007-11-23 10:00:00	AAPL	Stock	6.1118	6.1218	6.0714	6.0932	58286368.0
2007-11-23 10:30:00	AAPL	Stock	6.0932	6.1079	6.0796	6.0886	43599556.0
2007-11-23 11:00:00	AAPL	Stock	6.0889	6.0986	6.0625	6.0679	44838248.0
2007-11-23 11:30:00	AAPL	Stock	6.0675	6.1179	6.0629	6.0935	53183984.0
2007-11-23 12:00:00	AAPL	Stock	6.0925	6.1236	6.0868	6.1205	39117512.0
2007-11-23 12:30:00	AAPL	Stock	6.1207	6.1339	6.1036	6.1243	64958796.0
2007-11-23 13:00:00	AAPL	Stock	6.1268	6.1364	6.0999	6.1275	8367884.0
2007-11-23 13:30:00	AAPL	Stock	6.1275	6.1304	6.101	6.1304	6537468.0
2007-11-23 14:00:00	AAPL	Stock	6.1304	6.1339	6.1264	6.1339	137396.0
2007-11-23 14:30:00	AAPL	Stock	6.1329	6.1332	6.13	6.1307	183400.0
2007-11-23 15:00:00	AAPL	Stock	6.1279	6.1307	6.1275	6.1286	97748.0
2007-11-23 15:30:00	AAPL	Stock	6.13	6.13	6.1286	6.1293	19292.0
2007-11-23 16:00:00	AAPL	Stock	6.1293	6.1339	6.1293	6.1339	240016.0
2007-11-23 16:30:00	AAPL	Stock	6.1354	6.1357	6.1286	6.1286	28756.0
2007-11-23 07:00:00	MSFT	Stock	34.35	34.35	34.35	34.35	1000.0
2007-11-23 08:00:00	MSFT	Stock	34.34	34.42	34.0	34.37	20894.0
2007-11-23 08:30:00	MSFT	Stock	34.37	34.44	34.23	34.42	506618.0
2007-11-23 09:00:00	MSFT	Stock	34.42	34.44	34.23	34.29	429446.0
2007-11-23 09:30:00	MSFT	Stock	34.36	34.44	33.86	33.95	4386019.0
2007-11-23 10:00:00	MSFT	Stock	33.95	34.0	33.86	33.9	3006805.0
2007-11-23 10:30:00	MSFT	Stock	33.9	33.95	33.87	33.882	2640560.0
2007-11-23 11:00:00	MSFT	Stock	33.88	33.94	33.77	33.8	3775620.0
2007-11-23 11:30:00	MSFT	Stock	33.79	33.84	33.71	33.73	4854252.0
2007-11-23 12:00:00	MSFT	Stock	33.72	34.01	33.71	33.84	3866892.0
2007-11-23 12:30:00	MSFT	Stock	33.84	34.11	33.83	34.08	8016931.0
2007-11-23 13:00:00	MSFT	Stock	34.11	34.15	33.863	34.02	1946480.0
2007-11-23 13:30:00	MSFT	Stock	34.02	34.11	34.02	34.11	1330.0
2007-11-23 14:00:00	MSFT	Stock	34.11	34.11	34.11	34.11	11465.0
2007-11-23 14:30:00	MSFT	Stock	34.04	34.04	34.04	34.04	2800.0
2007-11-23 15:30:00	MSFT	Stock	34.04	34.04	34.04	34.04	1000.0
2007-11-23 08:00:00	NVDA	Stock	0.75	0.7625	0.75	0.7625	66120.0
2007-11-23 08:30:00	NVDA	Stock	0.7575	0.7578	0.7575	0.7578	8000.0
2007-11-23 09:00:00	NVDA	Stock	0.7578	0.7578	0.745	0.7495	258280.0
2007-11-23 09:30:00	NVDA	Stock	0.748	0.7525	0.741	0.744	30838240.0
2007-11-23 10:00:00	NVDA	Stock	0.7445	0.7445	0.7385	0.7393	18700960.0
2007-11-23 10:30:00	NVDA	Stock	0.7393	0.7438	0.7388	0.7425	17020880.0
2007-11-23 11:00:00	NVDA	Stock	0.7425	0.747	0.7423	0.745	11415360.0
2007-11-23 11:30:00	NVDA	Stock	0.745	0.7495	0.744	0.7488	13229600.0
2007-11-23 12:00:00	NVDA	Stock	0.7488	0.7582	0.7452	0.757	18067040.0
2007-11-23 12:30:00	NVDA	Stock	0.7572	0.7588	0.7513	0.7543	23033520.0
2007-11-23 13:00:00	NVDA	Stock	0.7543	0.7555	0.7443	0.7555	7864000.0

> showing 50 of 39,236 rows — these rows as CSV

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