PREVIEW / stock_30min / 2007-11-02

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-02.parquet
  size:    1.2 MB
  rows:    68,708
  symbols: 3,163

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
2007-11-02 05:30:00	AAPL	Stock	6.6918	6.6918	6.6918	6.6918	35000.0
2007-11-02 06:00:00	AAPL	Stock	6.6982	6.6982	6.6982	6.6982	7000.0
2007-11-02 07:00:00	AAPL	Stock	6.6911	6.6911	6.6836	6.6836	151200.0
2007-11-02 07:30:00	AAPL	Stock	6.6857	6.6911	6.6754	6.6911	147000.0
2007-11-02 08:00:00	AAPL	Stock	6.6943	6.7229	6.6932	6.7089	1375136.0
2007-11-02 08:30:00	AAPL	Stock	6.7089	6.7857	6.7054	6.7536	7441728.0
2007-11-02 09:00:00	AAPL	Stock	6.755	6.7589	6.7354	6.7575	3137540.0
2007-11-02 09:30:00	AAPL	Stock	6.7571	6.7657	6.6089	6.6511	152783904.0
2007-11-02 10:00:00	AAPL	Stock	6.6496	6.6693	6.6107	6.6289	94126872.0
2007-11-02 10:30:00	AAPL	Stock	6.6289	6.6604	6.6246	6.6404	76980176.0
2007-11-02 11:00:00	AAPL	Stock	6.64	6.6475	6.5596	6.5718	97855240.0
2007-11-02 11:30:00	AAPL	Stock	6.5736	6.6493	6.5532	6.6232	90300420.0
2007-11-02 12:00:00	AAPL	Stock	6.6232	6.6421	6.6064	6.6321	46911312.0
2007-11-02 12:30:00	AAPL	Stock	6.6321	6.7139	6.6316	6.7093	84928564.0
2007-11-02 13:00:00	AAPL	Stock	6.7089	6.7321	6.6843	6.7075	65027060.0
2007-11-02 13:30:00	AAPL	Stock	6.7071	6.7132	6.6807	6.6932	38844120.0
2007-11-02 14:00:00	AAPL	Stock	6.6939	6.7029	6.6611	6.6814	52711316.0
2007-11-02 14:30:00	AAPL	Stock	6.6814	6.6914	6.6607	6.6668	50036000.0
2007-11-02 15:00:00	AAPL	Stock	6.6668	6.6914	6.6611	6.6861	51659188.0
2007-11-02 15:30:00	AAPL	Stock	6.6864	6.7127	6.6757	6.7089	74670932.0
2007-11-02 16:00:00	AAPL	Stock	6.7086	6.7139	6.5739	6.7107	11409104.0
2007-11-02 16:30:00	AAPL	Stock	6.7096	6.7114	6.6646	6.7096	427140.0
2007-11-02 17:00:00	AAPL	Stock	6.7107	6.7132	6.662	6.7111	512848.0
2007-11-02 17:30:00	AAPL	Stock	6.6348	6.7111	6.6348	6.7079	108416.0
2007-11-02 18:00:00	AAPL	Stock	6.7079	6.7121	6.7079	6.7104	65436.0
2007-11-02 18:30:00	AAPL	Stock	6.7104	6.7132	6.7071	6.7089	264712.0
2007-11-02 19:00:00	AAPL	Stock	6.7079	6.7125	6.7039	6.7071	117628.0
2007-11-02 19:30:00	AAPL	Stock	6.7071	6.7125	6.7046	6.7071	84252.0
2007-11-02 07:00:00	MSFT	Stock	37.1	37.1	36.9	36.9	2300.0
2007-11-02 07:30:00	MSFT	Stock	36.83	37.0	36.79	36.99	15530.0
2007-11-02 08:00:00	MSFT	Stock	36.99	37.12	36.94	37.09	18445.0
2007-11-02 08:30:00	MSFT	Stock	37.13	37.5	37.13	37.4	179179.0
2007-11-02 09:00:00	MSFT	Stock	37.4	37.4	37.16	37.2	185168.0
2007-11-02 09:30:00	MSFT	Stock	37.21	37.3	36.74	36.81	11924061.0
2007-11-02 10:00:00	MSFT	Stock	36.82	36.89	36.42	36.88	9361230.0
2007-11-02 10:30:00	MSFT	Stock	36.88	37.05	36.74	36.84	5601024.0
2007-11-02 11:00:00	MSFT	Stock	36.84	36.98	36.67	36.69	4745085.0
2007-11-02 11:30:00	MSFT	Stock	36.69	36.98	36.66	36.808	4433891.0
2007-11-02 12:00:00	MSFT	Stock	36.81	36.96	36.75	36.82	4773445.0
2007-11-02 12:30:00	MSFT	Stock	36.83	37.0	36.82	36.99	5868159.0
2007-11-02 13:00:00	MSFT	Stock	36.99	37.05	36.94	37.01	7354097.0
2007-11-02 13:30:00	MSFT	Stock	37.02	37.5	36.99	37.02	4865405.0
2007-11-02 14:00:00	MSFT	Stock	37.03	37.1	36.978	37.01	6231850.0
2007-11-02 14:30:00	MSFT	Stock	37.02	37.09	36.95	37.02	8929800.0
2007-11-02 15:00:00	MSFT	Stock	37.03	37.24	36.94	37.03	9876928.0
2007-11-02 15:30:00	MSFT	Stock	37.04	37.13	36.97	37.03	8965646.0
2007-11-02 16:00:00	MSFT	Stock	37.03	37.14	36.74	37.11	3015306.0
2007-11-02 16:30:00	MSFT	Stock	37.06	37.12	37.05	37.09	32750.0
2007-11-02 17:00:00	MSFT	Stock	37.07	37.15	36.932	37.15	12263.0
2007-11-02 17:30:00	MSFT	Stock	37.11	37.11	37.05	37.05	3536.0

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

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