PREVIEW / stock_30min / 2008-04-23

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-23.parquet
  size:    1.2 MB
  rows:    68,138
  symbols: 3,297

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-04-23 06:30:00	AAPL	Stock	5.79	5.79	5.7836	5.7836	49560.0
2008-04-23 07:00:00	AAPL	Stock	5.7739	5.7821	5.7675	5.7821	135996.0
2008-04-23 07:30:00	AAPL	Stock	5.7679	5.8014	5.7643	5.7821	571508.0
2008-04-23 08:00:00	AAPL	Stock	5.7821	5.8207	5.7768	5.8179	4319728.0
2008-04-23 08:30:00	AAPL	Stock	5.8186	5.85	5.8139	5.8471	5776400.0
2008-04-23 09:00:00	AAPL	Stock	5.8482	5.8632	5.8393	5.8579	8799420.0
2008-04-23 09:30:00	AAPL	Stock	5.8571	5.8614	5.8054	5.8454	164582460.0
2008-04-23 10:00:00	AAPL	Stock	5.8454	5.8871	5.8361	5.8741	116604376.0
2008-04-23 10:30:00	AAPL	Stock	5.8736	5.8782	5.8382	5.8532	90570676.0
2008-04-23 11:00:00	AAPL	Stock	5.8529	5.8821	5.8507	5.8675	62437312.0
2008-04-23 11:30:00	AAPL	Stock	5.8675	5.8721	5.8514	5.8539	43414588.0
2008-04-23 12:00:00	AAPL	Stock	5.8536	5.8704	5.7682	5.7886	86301656.0
2008-04-23 12:30:00	AAPL	Stock	5.7879	5.8011	5.7529	5.7929	80425772.0
2008-04-23 13:00:00	AAPL	Stock	5.7925	5.8207	5.7682	5.8179	54477864.0
2008-04-23 13:30:00	AAPL	Stock	5.8196	5.8214	5.7914	5.8132	54904416.0
2008-04-23 14:00:00	AAPL	Stock	5.8132	5.8371	5.8	5.8168	63136192.0
2008-04-23 14:30:00	AAPL	Stock	5.8171	5.8371	5.8032	5.8046	65097844.0
2008-04-23 15:00:00	AAPL	Stock	5.805	5.8329	5.8036	5.8061	72796696.0
2008-04-23 15:30:00	AAPL	Stock	5.8054	5.8243	5.7825	5.81	129216836.0
2008-04-23 16:00:00	AAPL	Stock	5.8107	5.8546	5.8036	5.8243	14324520.0
2008-04-23 16:30:00	AAPL	Stock	5.8239	6.125	5.5314	5.6429	226266544.0
2008-04-23 17:00:00	AAPL	Stock	5.6375	6.0407	5.5475	5.765	70834064.0
2008-04-23 17:30:00	AAPL	Stock	5.7607	5.8568	5.7143	5.8407	44225076.0
2008-04-23 18:00:00	AAPL	Stock	5.8407	5.8411	5.7679	5.7864	11565456.0
2008-04-23 18:30:00	AAPL	Stock	5.7864	5.8336	5.75	5.8111	7058296.0
2008-04-23 19:00:00	AAPL	Stock	5.8107	5.8179	5.7918	5.8	1677172.0
2008-04-23 19:30:00	AAPL	Stock	5.8018	5.8089	5.7964	5.7968	1840636.0
2008-04-23 05:00:00	MSFT	Stock	30.48	30.48	30.48	30.48	300.0
2008-04-23 07:30:00	MSFT	Stock	30.25	30.32	30.25	30.32	9300.0
2008-04-23 08:00:00	MSFT	Stock	30.4	30.51	30.36	30.48	27886.0
2008-04-23 08:30:00	MSFT	Stock	30.48	30.52	30.45	30.5	22918.0
2008-04-23 09:00:00	MSFT	Stock	30.49	30.5	30.42	30.42	42005.0
2008-04-23 09:30:00	MSFT	Stock	30.44	30.73	30.3	30.68	6746661.0
2008-04-23 10:00:00	MSFT	Stock	30.678	31.0	30.6	30.96	8712313.0
2008-04-23 10:30:00	MSFT	Stock	30.95	31.25	30.91	31.13	9701956.0
2008-04-23 11:00:00	MSFT	Stock	31.14	31.2	30.935	31.03	6716922.0
2008-04-23 11:30:00	MSFT	Stock	31.03	31.25	30.97	31.22	6683018.0
2008-04-23 12:00:00	MSFT	Stock	31.22	31.25	31.08	31.11	7482938.0
2008-04-23 12:30:00	MSFT	Stock	31.11	31.16	31.06	31.11	4485025.0
2008-04-23 13:00:00	MSFT	Stock	31.11	31.28	31.11	31.25	4333787.0
2008-04-23 13:30:00	MSFT	Stock	31.24	31.45	31.21	31.37	5658499.0
2008-04-23 14:00:00	MSFT	Stock	31.37	31.41	31.31	31.32	3109491.0
2008-04-23 14:30:00	MSFT	Stock	31.31	31.33	31.2	31.248	4388187.0
2008-04-23 15:00:00	MSFT	Stock	31.24	31.38	31.22	31.292	7330727.0
2008-04-23 15:30:00	MSFT	Stock	31.3	31.46	31.28	31.46	11564531.0
2008-04-23 16:00:00	MSFT	Stock	31.45	31.49	30.79	31.31	4577178.0
2008-04-23 16:30:00	MSFT	Stock	31.41	31.58	30.414	31.15	641862.0
2008-04-23 17:00:00	MSFT	Stock	31.2	31.49	31.123	31.35	349589.0
2008-04-23 17:30:00	MSFT	Stock	31.35	31.5	31.25	31.48	86700.0
2008-04-23 18:00:00	MSFT	Stock	31.48	31.5	31.42	31.47	71514.0

> showing 50 of 68,138 rows — these rows as CSV

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