PREVIEW / stock_30min / 2008-02-06

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-06.parquet
  size:    1.2 MB
  rows:    69,901
  symbols: 3,253

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-02-06 05:30:00	AAPL	Stock	4.6357	4.6357	4.6357	4.6357	11200.0
2008-02-06 06:00:00	AAPL	Stock	4.6396	4.6396	4.6396	4.6396	19600.0
2008-02-06 06:30:00	AAPL	Stock	4.6429	4.6429	4.6429	4.6429	8400.0
2008-02-06 07:00:00	AAPL	Stock	4.6518	4.6771	4.6518	4.6643	212100.0
2008-02-06 07:30:00	AAPL	Stock	4.6696	4.6786	4.6614	4.6743	141092.0
2008-02-06 08:00:00	AAPL	Stock	4.665	4.6729	4.6339	4.6425	1675828.0
2008-02-06 08:30:00	AAPL	Stock	4.6482	4.665	4.645	4.6536	1485232.0
2008-02-06 09:00:00	AAPL	Stock	4.655	4.6757	4.6539	4.6757	1973300.0
2008-02-06 09:30:00	AAPL	Stock	4.6757	4.6896	4.6368	4.6768	126701176.0
2008-02-06 10:00:00	AAPL	Stock	4.6765	4.7114	4.6264	4.6357	129848152.0
2008-02-06 10:30:00	AAPL	Stock	4.6354	4.6571	4.5918	4.6111	112678860.0
2008-02-06 11:00:00	AAPL	Stock	4.6111	4.6382	4.6	4.6125	85087184.0
2008-02-06 11:30:00	AAPL	Stock	4.6114	4.615	4.5793	4.5879	70073920.0
2008-02-06 12:00:00	AAPL	Stock	4.5882	4.6007	4.5618	4.5718	59434116.0
2008-02-06 12:30:00	AAPL	Stock	4.5721	4.5779	4.5375	4.545	84234332.0
2008-02-06 13:00:00	AAPL	Stock	4.545	4.5454	4.4832	4.5268	128373112.0
2008-02-06 13:30:00	AAPL	Stock	4.5268	4.5321	4.4425	4.4539	136863580.0
2008-02-06 14:00:00	AAPL	Stock	4.455	4.4789	4.4154	4.4475	133333228.0
2008-02-06 14:30:00	AAPL	Stock	4.4479	4.4925	4.4204	4.4707	134559012.0
2008-02-06 15:00:00	AAPL	Stock	4.4696	4.4889	4.4182	4.4557	114997540.0
2008-02-06 15:30:00	AAPL	Stock	4.4557	4.4586	4.3489	4.3568	198658460.0
2008-02-06 16:00:00	AAPL	Stock	4.3536	4.5598	4.3396	4.3786	32585896.0
2008-02-06 16:30:00	AAPL	Stock	4.3786	4.43	4.2825	4.2857	7196252.0
2008-02-06 17:00:00	AAPL	Stock	4.2811	4.5481	4.2143	4.2643	8148112.0
2008-02-06 17:30:00	AAPL	Stock	4.2639	4.4732	4.25	4.2671	2067436.0
2008-02-06 18:00:00	AAPL	Stock	4.2679	4.4445	4.2679	4.2857	1251880.0
2008-02-06 18:30:00	AAPL	Stock	4.6524	4.6524	4.2768	4.2768	842408.0
2008-02-06 19:00:00	AAPL	Stock	4.2786	4.2904	4.2721	4.2904	383236.0
2008-02-06 19:30:00	AAPL	Stock	4.2857	4.2939	4.2768	4.2857	425096.0
2008-02-06 07:00:00	MSFT	Stock	29.35	29.35	29.35	29.35	100.0
2008-02-06 07:30:00	MSFT	Stock	29.29	29.36	29.25	29.25	10950.0
2008-02-06 08:00:00	MSFT	Stock	29.25	29.33	29.17	29.21	52030.0
2008-02-06 08:30:00	MSFT	Stock	29.23	29.31	29.23	29.29	49027.0
2008-02-06 09:00:00	MSFT	Stock	29.3	29.35	29.17	29.33	374791.0
2008-02-06 09:30:00	MSFT	Stock	29.33	29.35	28.82	29.0	11720629.0
2008-02-06 10:00:00	MSFT	Stock	29.0	29.08	28.86	28.9	13580142.0
2008-02-06 10:30:00	MSFT	Stock	28.9	29.17	28.81	29.03	11631829.0
2008-02-06 11:00:00	MSFT	Stock	29.03	29.35	29.01	29.24	11475549.0
2008-02-06 11:30:00	MSFT	Stock	29.24	29.26	29.12	29.13	4941097.0
2008-02-06 12:00:00	MSFT	Stock	29.14	29.15	28.95	28.992	4919380.0
2008-02-06 12:30:00	MSFT	Stock	29.0	29.0	28.9	28.93	3887849.0
2008-02-06 13:00:00	MSFT	Stock	28.94	29.05	28.93	28.99	5185738.0
2008-02-06 13:30:00	MSFT	Stock	28.99	29.0	28.79	28.805	5070463.0
2008-02-06 14:00:00	MSFT	Stock	28.81	28.89	28.67	28.77	7153597.0
2008-02-06 14:30:00	MSFT	Stock	28.77	28.95	28.73	28.85	9066681.0
2008-02-06 15:00:00	MSFT	Stock	28.84	28.9	28.61	28.648	11378149.0
2008-02-06 15:30:00	MSFT	Stock	28.65	28.65	28.32	28.52	27051690.0
2008-02-06 16:00:00	MSFT	Stock	28.52	28.948	28.079	28.5	9026692.0
2008-02-06 16:30:00	MSFT	Stock	28.862	28.862	28.25	28.3	511624.0
2008-02-06 17:00:00	MSFT	Stock	28.3	28.909	28.1	28.19	747032.0

> showing 50 of 69,901 rows — these rows as CSV

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