PREVIEW / stock_30min / 2008-01-23

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-23.parquet
  size:    1.3 MB
  rows:    73,804
  symbols: 3,269

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
2008-01-23 04:00:00	AAPL	Stock	5.0121	5.0121	5.0104	5.0104	11816.0
2008-01-23 04:30:00	AAPL	Stock	4.9964	4.9964	4.9964	4.9964	8400.0
2008-01-23 05:00:00	AAPL	Stock	5.0	5.0264	5.0	5.0196	93520.0
2008-01-23 05:30:00	AAPL	Stock	5.0143	5.0143	5.0143	5.0143	8400.0
2008-01-23 06:00:00	AAPL	Stock	4.9929	4.9929	4.9643	4.9646	204764.0
2008-01-23 06:30:00	AAPL	Stock	4.9714	4.9818	4.955	4.9818	299600.0
2008-01-23 07:00:00	AAPL	Stock	4.9818	5.0393	4.9643	5.0357	1117452.0
2008-01-23 07:30:00	AAPL	Stock	5.0364	5.0429	4.9786	4.9807	2738484.0
2008-01-23 08:00:00	AAPL	Stock	4.9889	4.9946	4.9286	4.9464	27026608.0
2008-01-23 08:30:00	AAPL	Stock	4.9464	4.9464	4.9107	4.9407	21403900.0
2008-01-23 09:00:00	AAPL	Stock	4.9411	4.9411	4.8571	4.8643	24453996.0
2008-01-23 09:30:00	AAPL	Stock	4.8639	5.0	4.8179	4.9146	450156168.0
2008-01-23 10:00:00	AAPL	Stock	4.9143	4.9464	4.8507	4.8894	248495044.0
2008-01-23 10:30:00	AAPL	Stock	4.8889	4.9071	4.8607	4.882	152840996.0
2008-01-23 11:00:00	AAPL	Stock	4.8818	4.8886	4.7343	4.7507	261409960.0
2008-01-23 11:30:00	AAPL	Stock	4.7511	4.8636	4.6125	4.6179	315184044.0
2008-01-23 12:00:00	AAPL	Stock	4.6171	4.6625	4.5568	4.6182	232409128.0
2008-01-23 12:30:00	AAPL	Stock	4.6182	4.6254	4.505	4.5254	191829288.0
2008-01-23 13:00:00	AAPL	Stock	4.5264	4.6046	4.5211	4.5893	160214824.0
2008-01-23 13:30:00	AAPL	Stock	4.5893	4.6775	4.5657	4.6754	197012396.0
2008-01-23 14:00:00	AAPL	Stock	4.6754	4.8171	4.6429	4.8057	236784856.0
2008-01-23 14:30:00	AAPL	Stock	4.805	4.8111	4.6729	4.7511	215904584.0
2008-01-23 15:00:00	AAPL	Stock	4.7511	4.9286	4.7375	4.9236	280455784.0
2008-01-23 15:30:00	AAPL	Stock	4.9232	4.9775	4.8825	4.9639	318077144.0
2008-01-23 16:00:00	AAPL	Stock	4.9636	4.9704	4.6671	4.9375	25150412.0
2008-01-23 16:30:00	AAPL	Stock	4.9382	4.9669	4.9107	4.95	3210256.0
2008-01-23 17:00:00	AAPL	Stock	4.9464	4.9696	4.9286	4.9679	2660084.0
2008-01-23 17:30:00	AAPL	Stock	4.9625	4.975	4.7313	4.9739	2911104.0
2008-01-23 18:00:00	AAPL	Stock	4.975	4.9875	4.9669	4.9768	915628.0
2008-01-23 18:30:00	AAPL	Stock	4.9796	4.9796	4.9643	4.9679	455532.0
2008-01-23 19:00:00	AAPL	Stock	4.9664	4.9796	4.9661	4.9786	342132.0
2008-01-23 19:30:00	AAPL	Stock	4.9768	4.9811	4.9714	4.9782	507780.0
2008-01-23 06:30:00	MSFT	Stock	31.48	31.48	31.48	31.48	180.0
2008-01-23 07:00:00	MSFT	Stock	31.56	31.56	31.35	31.4	8520.0
2008-01-23 07:30:00	MSFT	Stock	31.5	31.6	31.45	31.6	6580.0
2008-01-23 08:00:00	MSFT	Stock	31.6	31.99	31.4	31.4	257806.0
2008-01-23 08:30:00	MSFT	Stock	31.45	31.45	31.33	31.45	61892.0
2008-01-23 09:00:00	MSFT	Stock	31.49	31.59	31.33	31.42	150957.0
2008-01-23 09:30:00	MSFT	Stock	31.48	31.6	31.3	31.519	12575402.0
2008-01-23 10:00:00	MSFT	Stock	31.51	31.95	31.45	31.807	12062654.0
2008-01-23 10:30:00	MSFT	Stock	31.81	31.87	31.63	31.81	8159034.0
2008-01-23 11:00:00	MSFT	Stock	31.81	31.87	31.53	31.56	7195649.0
2008-01-23 11:30:00	MSFT	Stock	31.56	31.58	31.3	31.357	8491823.0
2008-01-23 12:00:00	MSFT	Stock	31.36	31.55	31.25	31.45	7433083.0
2008-01-23 12:30:00	MSFT	Stock	31.453	31.47	31.04	31.292	6565157.0
2008-01-23 13:00:00	MSFT	Stock	31.3	31.46	31.14	31.3	7172512.0
2008-01-23 13:30:00	MSFT	Stock	31.3	31.42	31.21	31.36	9585126.0
2008-01-23 14:00:00	MSFT	Stock	31.36	31.49	31.28	31.43	8980705.0
2008-01-23 14:30:00	MSFT	Stock	31.43	31.443	31.1	31.22	9293550.0
2008-01-23 15:00:00	MSFT	Stock	31.22	31.63	31.18	31.57	17960569.0

> showing 50 of 73,804 rows — these rows as CSV

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