PREVIEW / stock_30min / 2009-04-01

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-01.parquet
  size:    1.3 MB
  rows:    70,746
  symbols: 3,311

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
2009-04-01 07:30:00	AAPL	Stock	3.7411	3.7411	3.7411	3.7411	2800.0
2009-04-01 08:00:00	AAPL	Stock	3.7339	3.7543	3.7143	3.7143	561764.0
2009-04-01 08:30:00	AAPL	Stock	3.7161	3.7254	3.7104	3.7146	461020.0
2009-04-01 09:00:00	AAPL	Stock	3.7146	3.7543	3.7136	3.7196	630756.0
2009-04-01 09:30:00	AAPL	Stock	3.7179	3.7532	3.7104	3.7325	54467672.0
2009-04-01 10:00:00	AAPL	Stock	3.7325	3.7814	3.7318	3.775	49032704.0
2009-04-01 10:30:00	AAPL	Stock	3.7754	3.8371	3.7696	3.8296	56378196.0
2009-04-01 11:00:00	AAPL	Stock	3.83	3.8329	3.8036	3.8261	37536044.0
2009-04-01 11:30:00	AAPL	Stock	3.8264	3.8464	3.8207	3.8454	31001544.0
2009-04-01 12:00:00	AAPL	Stock	3.8457	3.8596	3.8454	3.8532	35936236.0
2009-04-01 12:30:00	AAPL	Stock	3.8529	3.8614	3.835	3.8393	23597616.0
2009-04-01 13:00:00	AAPL	Stock	3.8389	3.8532	3.8329	3.8489	25113760.0
2009-04-01 13:30:00	AAPL	Stock	3.8489	3.8604	3.8382	3.8593	24523716.0
2009-04-01 14:00:00	AAPL	Stock	3.859	3.8814	3.8568	3.8625	42997416.0
2009-04-01 14:30:00	AAPL	Stock	3.8611	3.8832	3.8571	3.8807	43417696.0
2009-04-01 15:00:00	AAPL	Stock	3.8807	3.8821	3.8414	3.8596	59865232.0
2009-04-01 15:30:00	AAPL	Stock	3.8604	3.8929	3.8564	3.8818	81556496.0
2009-04-01 16:00:00	AAPL	Stock	3.8818	3.8857	3.7543	3.8829	9574208.0
2009-04-01 16:30:00	AAPL	Stock	3.8821	3.8868	3.8818	3.8818	262948.0
2009-04-01 17:00:00	AAPL	Stock	3.8829	3.8854	3.8825	3.8854	95032.0
2009-04-01 17:30:00	AAPL	Stock	3.885	3.8864	3.8846	3.8864	33264.0
2009-04-01 18:00:00	AAPL	Stock	3.8896	3.8896	3.8818	3.8839	916076.0
2009-04-01 18:30:00	AAPL	Stock	3.8839	3.8857	3.8839	3.8857	16940.0
2009-04-01 19:00:00	AAPL	Stock	3.8868	3.8868	3.8864	3.8864	33600.0
2009-04-01 19:30:00	AAPL	Stock	3.8864	3.8904	3.8864	3.89	161504.0
2009-04-01 07:00:00	MSFT	Stock	18.35	18.35	18.35	18.35	1000.0
2009-04-01 07:30:00	MSFT	Stock	18.36	18.38	18.36	18.36	7700.0
2009-04-01 08:00:00	MSFT	Stock	18.35	18.4	18.25	18.28	41970.0
2009-04-01 08:30:00	MSFT	Stock	18.25	18.37	18.2	18.33	81286.0
2009-04-01 09:00:00	MSFT	Stock	18.33	18.33	18.17	18.2	48981.0
2009-04-01 09:30:00	MSFT	Stock	18.24	18.58	18.18	18.53	9135520.0
2009-04-01 10:00:00	MSFT	Stock	18.53	18.82	18.52	18.75	7744945.0
2009-04-01 10:30:00	MSFT	Stock	18.75	18.93	18.73	18.88	6301617.0
2009-04-01 11:00:00	MSFT	Stock	18.88	18.97	18.81	18.96	4710702.0
2009-04-01 11:30:00	MSFT	Stock	18.96	19.11	18.9	19.03	7869901.0
2009-04-01 12:00:00	MSFT	Stock	19.04	19.2	19.04	19.152	5600567.0
2009-04-01 12:30:00	MSFT	Stock	19.151	19.25	19.11	19.12	7888621.0
2009-04-01 13:00:00	MSFT	Stock	19.12	19.22	19.08	19.15	4427203.0
2009-04-01 13:30:00	MSFT	Stock	19.15	19.24	19.07	19.22	4413050.0
2009-04-01 14:00:00	MSFT	Stock	19.21	19.32	19.19	19.252	4837459.0
2009-04-01 14:30:00	MSFT	Stock	19.24	19.36	19.16	19.21	5557187.0
2009-04-01 15:00:00	MSFT	Stock	19.21	19.24	19.0	19.08	9244859.0
2009-04-01 15:30:00	MSFT	Stock	19.082	19.3	19.04	19.3	12677751.0
2009-04-01 16:00:00	MSFT	Stock	19.3	19.31	18.37	19.19	3496989.0
2009-04-01 16:30:00	MSFT	Stock	19.17	19.31	19.009	19.31	54837.0
2009-04-01 17:00:00	MSFT	Stock	19.19	19.3	19.19	19.3	506465.0
2009-04-01 17:30:00	MSFT	Stock	19.17	19.29	19.17	19.29	5530.0
2009-04-01 18:00:00	MSFT	Stock	19.2	19.2	19.16	19.16	264601.0
2009-04-01 18:30:00	MSFT	Stock	19.3	19.3	19.2	19.3	5701.0
2009-04-01 19:30:00	MSFT	Stock	19.24	19.3	19.23	19.3	1885.0

> showing 50 of 70,746 rows — these rows as CSV

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