PREVIEW / stock_30min / 2009-02-18

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-18.parquet
  size:    1.2 MB
  rows:    69,534
  symbols: 3,323

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-02-18 06:30:00	AAPL	Stock	3.3918	3.3918	3.3918	3.3918	2800.0
2009-02-18 07:30:00	AAPL	Stock	3.3893	3.3893	3.3893	3.3893	56000.0
2009-02-18 08:00:00	AAPL	Stock	3.3839	3.3875	3.375	3.3875	108640.0
2009-02-18 08:30:00	AAPL	Stock	3.3875	3.4046	3.3818	3.3982	441616.0
2009-02-18 09:00:00	AAPL	Stock	3.4029	3.4114	3.3925	3.4011	966112.0
2009-02-18 09:30:00	AAPL	Stock	3.3946	3.4154	3.3786	3.3954	71007748.0
2009-02-18 10:00:00	AAPL	Stock	3.3954	3.3989	3.3114	3.3754	105959028.0
2009-02-18 10:30:00	AAPL	Stock	3.3754	3.3946	3.3721	3.3804	53319784.0
2009-02-18 11:00:00	AAPL	Stock	3.3804	3.4143	3.3739	3.4061	47784268.0
2009-02-18 11:30:00	AAPL	Stock	3.4057	3.4139	3.3982	3.4057	31952060.0
2009-02-18 12:00:00	AAPL	Stock	3.4054	3.4232	3.3946	3.4004	35055580.0
2009-02-18 12:30:00	AAPL	Stock	3.4	3.4111	3.3964	3.4086	28299684.0
2009-02-18 13:00:00	AAPL	Stock	3.4082	3.4139	3.3804	3.3846	33574044.0
2009-02-18 13:30:00	AAPL	Stock	3.3846	3.3896	3.3607	3.3729	38288684.0
2009-02-18 14:00:00	AAPL	Stock	3.3725	3.3904	3.3579	3.3789	39268628.0
2009-02-18 14:30:00	AAPL	Stock	3.3789	3.3925	3.3661	3.3921	38566024.0
2009-02-18 15:00:00	AAPL	Stock	3.3904	3.3971	3.3771	3.3807	53394292.0
2009-02-18 15:30:00	AAPL	Stock	3.38	3.3893	3.3675	3.3707	68927040.0
2009-02-18 16:00:00	AAPL	Stock	3.3693	3.3848	3.3214	3.3471	28360080.0
2009-02-18 16:30:00	AAPL	Stock	3.3496	3.3873	3.3375	3.3446	169904.0
2009-02-18 17:00:00	AAPL	Stock	3.3429	3.3842	3.3429	3.3429	81200.0
2009-02-18 17:30:00	AAPL	Stock	3.3446	3.3525	3.3429	3.3429	46200.0
2009-02-18 18:00:00	AAPL	Stock	3.3704	3.3704	3.3321	3.3386	1985256.0
2009-02-18 18:30:00	AAPL	Stock	3.3425	3.3782	3.3325	3.3418	108668.0
2009-02-18 19:00:00	AAPL	Stock	3.3411	3.3411	3.3029	3.3214	607516.0
2009-02-18 19:30:00	AAPL	Stock	3.3261	3.3314	3.3221	3.3221	97440.0
2009-02-18 06:30:00	MSFT	Stock	18.35	18.95	18.35	18.95	1000.0
2009-02-18 08:00:00	MSFT	Stock	18.18	18.35	18.18	18.28	4425.0
2009-02-18 08:30:00	MSFT	Stock	18.31	18.35	18.3	18.34	9334.0
2009-02-18 09:00:00	MSFT	Stock	18.3	18.34	18.2	18.21	33284.0
2009-02-18 09:30:00	MSFT	Stock	18.22	18.34	18.14	18.21	5273789.0
2009-02-18 10:00:00	MSFT	Stock	18.21	18.24	18.0	18.19	5080175.0
2009-02-18 10:30:00	MSFT	Stock	18.19	18.2	18.05	18.07	5893914.0
2009-02-18 11:00:00	MSFT	Stock	18.07	18.3	18.05	18.28	3573510.0
2009-02-18 11:30:00	MSFT	Stock	18.28	18.38	18.26	18.32	2696320.0
2009-02-18 12:00:00	MSFT	Stock	18.33	18.45	18.24	18.3	3217741.0
2009-02-18 12:30:00	MSFT	Stock	18.31	18.34	18.23	18.273	2235380.0
2009-02-18 13:00:00	MSFT	Stock	18.28	18.32	18.15	18.17	2310410.0
2009-02-18 13:30:00	MSFT	Stock	18.18	18.22	18.05	18.1	2289926.0
2009-02-18 14:00:00	MSFT	Stock	18.11	18.19	18.04	18.11	3638961.0
2009-02-18 14:30:00	MSFT	Stock	18.12	18.18	18.02	18.18	3522197.0
2009-02-18 15:00:00	MSFT	Stock	18.17	18.2	18.07	18.1	5250885.0
2009-02-18 15:30:00	MSFT	Stock	18.09	18.16	18.05	18.12	6702038.0
2009-02-18 16:00:00	MSFT	Stock	18.11	18.176	17.98	18.04	1560550.0
2009-02-18 16:30:00	MSFT	Stock	18.04	18.2	17.91	17.96	43045.0
2009-02-18 17:00:00	MSFT	Stock	18.0	18.06	17.96	18.05	4975.0
2009-02-18 17:30:00	MSFT	Stock	18.02	18.02	18.02	18.02	100.0
2009-02-18 18:00:00	MSFT	Stock	18.02	18.04	18.0	18.04	7709.0
2009-02-18 18:30:00	MSFT	Stock	18.0	18.0	17.96	17.96	3605.0
2009-02-18 19:00:00	MSFT	Stock	18.0	18.03	18.0	18.03	2800.0

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

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