PREVIEW / stock_30min / 2008-01-16

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-16.parquet
  size:    1.2 MB
  rows:    70,121
  symbols: 3,260

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-01-16 04:00:00	AAPL	Stock	5.7893	5.7893	5.7893	5.7893	7000.0
2008-01-16 04:30:00	AAPL	Stock	5.8032	5.8032	5.7936	5.7936	5600.0
2008-01-16 05:00:00	AAPL	Stock	5.8036	5.8036	5.7914	5.7914	22400.0
2008-01-16 05:30:00	AAPL	Stock	5.8161	5.8161	5.8161	5.8161	2800.0
2008-01-16 06:30:00	AAPL	Stock	5.815	5.815	5.8018	5.8071	191128.0
2008-01-16 07:00:00	AAPL	Stock	5.8125	5.8782	5.8	5.8782	690284.0
2008-01-16 07:30:00	AAPL	Stock	5.8711	5.9071	5.8575	5.8889	1455804.0
2008-01-16 08:00:00	AAPL	Stock	5.8793	5.8925	5.8468	5.8768	4504864.0
2008-01-16 08:30:00	AAPL	Stock	5.8771	5.8929	5.8593	5.8786	4208036.0
2008-01-16 09:00:00	AAPL	Stock	5.8757	5.9286	5.8682	5.8982	12891844.0
2008-01-16 09:30:00	AAPL	Stock	5.8964	6.0361	5.8732	5.8843	263105780.0
2008-01-16 10:00:00	AAPL	Stock	5.8836	5.9129	5.7386	5.7436	216121416.0
2008-01-16 10:30:00	AAPL	Stock	5.7432	5.8036	5.5964	5.6679	230464500.0
2008-01-16 11:00:00	AAPL	Stock	5.6682	5.7618	5.6657	5.7493	183079540.0
2008-01-16 11:30:00	AAPL	Stock	5.7436	5.8004	5.6775	5.79	155485456.0
2008-01-16 12:00:00	AAPL	Stock	5.7896	5.8207	5.7411	5.7857	118230056.0
2008-01-16 12:30:00	AAPL	Stock	5.7857	5.8821	5.785	5.8086	124523616.0
2008-01-16 13:00:00	AAPL	Stock	5.8082	5.8257	5.7332	5.74	92555008.0
2008-01-16 13:30:00	AAPL	Stock	5.7407	5.7946	5.7218	5.7704	84315896.0
2008-01-16 14:00:00	AAPL	Stock	5.7704	5.875	5.7336	5.8739	145322856.0
2008-01-16 14:30:00	AAPL	Stock	5.8732	6.0357	5.8214	5.8314	194639088.0
2008-01-16 15:00:00	AAPL	Stock	5.8321	5.9029	5.8225	5.8682	133582876.0
2008-01-16 15:30:00	AAPL	Stock	5.8671	5.8832	5.6896	5.7004	222668768.0
2008-01-16 16:00:00	AAPL	Stock	5.7004	5.8088	5.6929	5.715	19601652.0
2008-01-16 16:30:00	AAPL	Stock	5.7161	5.9512	5.6929	5.6964	2472344.0
2008-01-16 17:00:00	AAPL	Stock	5.6964	5.7842	5.6796	5.6861	1962128.0
2008-01-16 17:30:00	AAPL	Stock	5.6861	5.6868	5.6661	5.6661	1042832.0
2008-01-16 18:00:00	AAPL	Stock	5.6654	5.6654	5.6321	5.655	1318828.0
2008-01-16 18:30:00	AAPL	Stock	5.655	5.6771	5.6518	5.6686	478380.0
2008-01-16 19:00:00	AAPL	Stock	5.6679	5.6875	5.6679	5.6786	586544.0
2008-01-16 19:30:00	AAPL	Stock	5.6821	5.7079	5.6821	5.6929	925344.0
2008-01-16 06:30:00	MSFT	Stock	33.15	33.15	33.15	33.15	500.0
2008-01-16 07:00:00	MSFT	Stock	33.03	33.24	33.03	33.12	8800.0
2008-01-16 07:30:00	MSFT	Stock	33.25	33.35	33.06	33.25	19700.0
2008-01-16 08:00:00	MSFT	Stock	33.07	33.25	33.02	33.2	81850.0
2008-01-16 08:30:00	MSFT	Stock	33.24	33.27	33.12	33.26	56899.0
2008-01-16 09:00:00	MSFT	Stock	33.27	33.49	33.25	33.43	375537.0
2008-01-16 09:30:00	MSFT	Stock	33.42	33.65	33.03	33.21	13658154.0
2008-01-16 10:00:00	MSFT	Stock	33.22	33.26	32.89	32.952	10576981.0
2008-01-16 10:30:00	MSFT	Stock	32.95	33.0	32.51	32.85	11358613.0
2008-01-16 11:00:00	MSFT	Stock	32.854	33.16	32.71	33.04	7220634.0
2008-01-16 11:30:00	MSFT	Stock	33.04	33.17	32.88	33.07	5634250.0
2008-01-16 12:00:00	MSFT	Stock	33.08	33.215	33.02	33.13	4619045.0
2008-01-16 12:30:00	MSFT	Stock	33.14	33.19	33.002	33.06	4846765.0
2008-01-16 13:00:00	MSFT	Stock	33.06	33.06	32.87	32.93	4674383.0
2008-01-16 13:30:00	MSFT	Stock	32.93	33.12	32.88	32.99	4364362.0
2008-01-16 14:00:00	MSFT	Stock	32.99	33.17	32.87	33.17	5576810.0
2008-01-16 14:30:00	MSFT	Stock	33.17	33.4	33.02	33.04	8632743.0
2008-01-16 15:00:00	MSFT	Stock	33.04	33.35	33.02	33.34	7159216.0
2008-01-16 15:30:00	MSFT	Stock	33.33	33.46	33.17	33.21	18529154.0

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

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