PREVIEW / stock_30min / 2007-04-24

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-24.parquet
  size:    1.0 MB
  rows:    56,090
  symbols: 2,598

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-04-24 07:00:00	AAPL	Stock	3.3482	3.3532	3.3411	3.35	158872.0
2007-04-24 07:30:00	AAPL	Stock	3.3536	3.3607	3.3536	3.3564	433552.0
2007-04-24 08:00:00	AAPL	Stock	3.3539	3.3632	3.3536	3.3557	2485812.0
2007-04-24 08:30:00	AAPL	Stock	3.3554	3.3571	3.3536	3.3554	921060.0
2007-04-24 09:00:00	AAPL	Stock	3.3554	3.3589	3.3536	3.3557	1212848.0
2007-04-24 09:30:00	AAPL	Stock	3.3557	3.3607	3.2607	3.3479	109468184.0
2007-04-24 10:00:00	AAPL	Stock	3.3475	3.3579	3.3129	3.3184	63764820.0
2007-04-24 10:30:00	AAPL	Stock	3.3179	3.3272	3.3121	3.3246	37315208.0
2007-04-24 11:00:00	AAPL	Stock	3.3246	3.3268	3.3143	3.3268	31811108.0
2007-04-24 11:30:00	AAPL	Stock	3.3264	3.3325	3.3229	3.3264	27887104.0
2007-04-24 12:00:00	AAPL	Stock	3.3264	3.3482	3.3225	3.3429	46908764.0
2007-04-24 12:30:00	AAPL	Stock	3.3425	3.3604	3.3421	3.3479	54487216.0
2007-04-24 13:00:00	AAPL	Stock	3.3482	3.3493	3.2714	3.2964	173857264.0
2007-04-24 13:30:00	AAPL	Stock	3.2964	3.4425	3.2879	3.3668	205338084.0
2007-04-24 14:00:00	AAPL	Stock	3.3671	3.3779	3.3561	3.3721	83458648.0
2007-04-24 14:30:00	AAPL	Stock	3.3721	3.3761	3.3554	3.3607	60241524.0
2007-04-24 15:00:00	AAPL	Stock	3.3607	3.3629	3.3314	3.3357	54291860.0
2007-04-24 15:30:00	AAPL	Stock	3.3354	3.3446	3.3218	3.33	81994276.0
2007-04-24 16:00:00	AAPL	Stock	3.3296	3.3393	3.3289	3.3389	11549272.0
2007-04-24 16:30:00	AAPL	Stock	3.3389	3.3393	3.3339	3.3389	859152.0
2007-04-24 17:00:00	AAPL	Stock	3.3382	3.3407	3.335	3.3393	303492.0
2007-04-24 17:30:00	AAPL	Stock	3.3407	3.3464	3.3375	3.3375	315504.0
2007-04-24 18:00:00	AAPL	Stock	3.3375	3.3418	3.3375	3.3393	187208.0
2007-04-24 18:30:00	AAPL	Stock	3.3393	3.3411	3.3375	3.3375	73388.0
2007-04-24 19:00:00	AAPL	Stock	3.3379	3.3404	3.3379	3.3393	98532.0
2007-04-24 19:30:00	AAPL	Stock	3.3396	3.3525	3.3396	3.3518	655032.0
2007-04-24 06:30:00	MSFT	Stock	28.78	28.78	28.78	28.78	200.0
2007-04-24 07:00:00	MSFT	Stock	28.78	28.78	28.78	28.78	800.0
2007-04-24 08:00:00	MSFT	Stock	28.79	28.79	28.75	28.78	12635.0
2007-04-24 08:30:00	MSFT	Stock	28.79	28.79	28.79	28.79	2632.0
2007-04-24 09:00:00	MSFT	Stock	28.79	28.85	28.76	28.78	29093.0
2007-04-24 09:30:00	MSFT	Stock	28.79	28.89	28.73	28.79	4092982.0
2007-04-24 10:00:00	MSFT	Stock	28.79	28.79	28.59	28.66	3251384.0
2007-04-24 10:30:00	MSFT	Stock	28.67	28.75	28.61	28.68	2130139.0
2007-04-24 11:00:00	MSFT	Stock	28.672	28.72	28.63	28.67	1879355.0
2007-04-24 11:30:00	MSFT	Stock	28.67	28.79	28.67	28.76	1606798.0
2007-04-24 12:00:00	MSFT	Stock	28.76	28.96	28.76	28.93	2302740.0
2007-04-24 12:30:00	MSFT	Stock	28.93	28.96	28.87	28.9	1529660.0
2007-04-24 13:00:00	MSFT	Stock	28.9	28.92	28.86	28.86	1656414.0
2007-04-24 13:30:00	MSFT	Stock	28.87	28.91	28.84	28.87	1908573.0
2007-04-24 14:00:00	MSFT	Stock	28.86	28.92	28.84	28.91	1981586.0
2007-04-24 14:30:00	MSFT	Stock	28.9	28.91	28.83	28.84	1962340.0
2007-04-24 15:00:00	MSFT	Stock	28.84	28.9	28.84	28.87	1693037.0
2007-04-24 15:30:00	MSFT	Stock	28.87	28.89	28.77	28.79	3404704.0
2007-04-24 16:00:00	MSFT	Stock	28.79	28.84	28.79	28.8	2831087.0
2007-04-24 16:30:00	MSFT	Stock	28.79	28.81	28.79	28.79	404118.0
2007-04-24 17:00:00	MSFT	Stock	28.76	28.76	28.76	28.76	200.0
2007-04-24 17:30:00	MSFT	Stock	28.81	28.81	28.81	28.81	1981.0
2007-04-24 19:30:00	MSFT	Stock	28.77	28.77	28.77	28.77	800.0
2007-04-24 07:30:00	NVDA	Stock	0.5333	0.5333	0.5333	0.5333	300000.0

> showing 50 of 56,090 rows — these rows as CSV

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