PREVIEW / stock_30min / 2009-12-02

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-02.parquet
  size:    1.4 MB
  rows:    74,209
  symbols: 3,428

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-12-02 04:00:00	AAPL	Stock	7.0875	7.0875	7.0875	7.0875	2800.0
2009-12-02 04:30:00	AAPL	Stock	7.0732	7.0732	7.0732	7.0732	4760.0
2009-12-02 05:30:00	AAPL	Stock	7.0775	7.0836	7.0607	7.0714	37744.0
2009-12-02 06:00:00	AAPL	Stock	7.0714	7.0714	7.0714	7.0714	22400.0
2009-12-02 06:30:00	AAPL	Stock	7.0804	7.0821	7.0779	7.0779	8400.0
2009-12-02 07:30:00	AAPL	Stock	7.0857	7.1175	7.0793	7.0946	63840.0
2009-12-02 08:00:00	AAPL	Stock	7.0982	7.12	7.0954	7.1071	1397256.0
2009-12-02 08:30:00	AAPL	Stock	7.1071	7.1071	7.0346	7.0941	961968.0
2009-12-02 09:00:00	AAPL	Stock	7.0964	7.1071	7.0939	7.1018	1325632.0
2009-12-02 09:30:00	AAPL	Stock	7.1014	7.1343	7.0718	7.1179	81896808.0
2009-12-02 10:00:00	AAPL	Stock	7.1179	7.1607	7.1154	7.1582	63487088.0
2009-12-02 10:30:00	AAPL	Stock	7.1568	7.1936	7.1471	7.1493	52383660.0
2009-12-02 11:00:00	AAPL	Stock	7.1493	7.1536	7.0918	7.1018	60113508.0
2009-12-02 11:30:00	AAPL	Stock	7.1004	7.1089	7.0879	7.0921	28413056.0
2009-12-02 12:00:00	AAPL	Stock	7.0921	7.1	7.0393	7.0675	40977496.0
2009-12-02 12:30:00	AAPL	Stock	7.0664	7.0775	7.0543	7.0689	24777984.0
2009-12-02 13:00:00	AAPL	Stock	7.0689	7.0704	7.0143	7.015	46451048.0
2009-12-02 13:30:00	AAPL	Stock	7.0157	7.0418	7.0	7.0382	54229084.0
2009-12-02 14:00:00	AAPL	Stock	7.0382	7.0546	7.0061	7.0207	49276248.0
2009-12-02 14:30:00	AAPL	Stock	7.0205	7.0446	7.015	7.0275	36273580.0
2009-12-02 15:00:00	AAPL	Stock	7.0268	7.035	7.0054	7.0166	38964240.0
2009-12-02 15:30:00	AAPL	Stock	7.0172	7.0246	6.9911	7.0043	84081172.0
2009-12-02 16:00:00	AAPL	Stock	7.0043	7.0733	7.0017	7.0107	25127816.0
2009-12-02 16:30:00	AAPL	Stock	7.0143	7.0154	7.0107	7.0107	187824.0
2009-12-02 17:00:00	AAPL	Stock	7.0111	7.0693	7.0111	7.0175	330652.0
2009-12-02 17:30:00	AAPL	Stock	7.0179	7.0204	7.0121	7.0204	361172.0
2009-12-02 18:00:00	AAPL	Stock	7.0196	7.0229	7.0082	7.0143	497336.0
2009-12-02 18:30:00	AAPL	Stock	7.0179	7.0321	7.0179	7.025	553252.0
2009-12-02 19:00:00	AAPL	Stock	7.025	7.0286	7.0207	7.0282	150752.0
2009-12-02 19:30:00	AAPL	Stock	7.0282	7.0357	7.0264	7.0343	474684.0
2009-12-02 04:00:00	MSFT	Stock	30.06	30.16	30.06	30.16	2000.0
2009-12-02 04:30:00	MSFT	Stock	30.08	30.08	30.08	30.08	500.0
2009-12-02 07:00:00	MSFT	Stock	30.05	30.05	30.05	30.05	1100.0
2009-12-02 08:00:00	MSFT	Stock	30.01	30.02	29.91	29.91	2310.0
2009-12-02 08:30:00	MSFT	Stock	30.01	30.01	29.92	29.92	2853.0
2009-12-02 09:00:00	MSFT	Stock	29.92	30.01	29.86	29.88	36633.0
2009-12-02 09:30:00	MSFT	Stock	29.88	29.98	29.67	29.87	4383049.0
2009-12-02 10:00:00	MSFT	Stock	29.87	29.99	29.83	29.97	3513317.0
2009-12-02 10:30:00	MSFT	Stock	29.97	29.98	29.91	29.92	1251374.0
2009-12-02 11:00:00	MSFT	Stock	29.92	29.94	29.8	29.89	3527650.0
2009-12-02 11:30:00	MSFT	Stock	29.89	29.95	29.87	29.888	1604654.0
2009-12-02 12:00:00	MSFT	Stock	29.885	29.91	29.81	29.82	2591625.0
2009-12-02 12:30:00	MSFT	Stock	29.82	29.84	29.8	29.81	1691152.0
2009-12-02 13:00:00	MSFT	Stock	29.815	29.82	29.76	29.78	1453217.0
2009-12-02 13:30:00	MSFT	Stock	29.78	29.84	29.76	29.76	1685548.0
2009-12-02 14:00:00	MSFT	Stock	29.77	29.81	29.65	29.7	2958206.0
2009-12-02 14:30:00	MSFT	Stock	29.7	29.75	29.68	29.74	1369742.0
2009-12-02 15:00:00	MSFT	Stock	29.735	29.76	29.72	29.723	2123313.0
2009-12-02 15:30:00	MSFT	Stock	29.725	29.82	29.68	29.78	4848055.0
2009-12-02 16:00:00	MSFT	Stock	29.77	30.01	29.73	30.01	2358982.0

> showing 50 of 74,209 rows — these rows as CSV

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