PREVIEW / stock_30min / 2007-02-28

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-02-28.parquet
  size:    1.0 MB
  rows:    55,253
  symbols: 2,532

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-02-28 04:00:00	AAPL	Stock	2.995	2.995	2.9946	2.9946	30800.0
2007-02-28 04:30:00	AAPL	Stock	3.0007	3.0032	3.0007	3.0032	27664.0
2007-02-28 05:00:00	AAPL	Stock	3.0039	3.0039	3.0039	3.0039	25200.0
2007-02-28 06:30:00	AAPL	Stock	3.0104	3.0282	3.0071	3.0143	164332.0
2007-02-28 07:00:00	AAPL	Stock	3.0143	3.0175	3.0057	3.0175	440076.0
2007-02-28 07:30:00	AAPL	Stock	3.0143	3.025	3.0125	3.0232	308084.0
2007-02-28 08:00:00	AAPL	Stock	3.0232	3.0386	3.0196	3.0314	3296300.0
2007-02-28 08:30:00	AAPL	Stock	3.0332	3.0375	3.0214	3.025	3474940.0
2007-02-28 09:00:00	AAPL	Stock	3.025	3.0311	3.0125	3.0204	2965452.0
2007-02-28 09:30:00	AAPL	Stock	3.0196	3.0325	2.9643	3.0175	162787464.0
2007-02-28 10:00:00	AAPL	Stock	3.0175	3.0329	3.0004	3.03	115008656.0
2007-02-28 10:30:00	AAPL	Stock	3.03	3.0525	3.0268	3.0429	112234528.0
2007-02-28 11:00:00	AAPL	Stock	3.0429	3.0571	3.0375	3.04	67430188.0
2007-02-28 11:30:00	AAPL	Stock	3.04	3.0425	3.0136	3.0186	71090320.0
2007-02-28 12:00:00	AAPL	Stock	3.0179	3.0296	3.0143	3.0211	53248020.0
2007-02-28 12:30:00	AAPL	Stock	3.0211	3.0336	3.0207	3.0275	29984640.0
2007-02-28 13:00:00	AAPL	Stock	3.0275	3.0375	3.0214	3.0304	33622624.0
2007-02-28 13:30:00	AAPL	Stock	3.0311	3.0339	3.0182	3.0254	27971692.0
2007-02-28 14:00:00	AAPL	Stock	3.0257	3.0307	3.0161	3.0289	45953040.0
2007-02-28 14:30:00	AAPL	Stock	3.0289	3.0357	3.0232	3.0257	48081656.0
2007-02-28 15:00:00	AAPL	Stock	3.0261	3.0411	3.0218	3.0379	55503728.0
2007-02-28 15:30:00	AAPL	Stock	3.0371	3.0393	3.0196	3.0214	72712164.0
2007-02-28 16:00:00	AAPL	Stock	3.02	3.0218	3.0161	3.0186	869288.0
2007-02-28 16:30:00	AAPL	Stock	3.0186	3.0193	3.0179	3.0186	237552.0
2007-02-28 17:00:00	AAPL	Stock	3.0196	3.0211	3.0189	3.0211	64400.0
2007-02-28 17:30:00	AAPL	Stock	3.0196	3.0211	3.0189	3.0196	41636.0
2007-02-28 18:00:00	AAPL	Stock	3.0212	3.0289	3.0189	3.0211	419692.0
2007-02-28 18:30:00	AAPL	Stock	3.0193	3.0214	3.0193	3.0214	22400.0
2007-02-28 19:00:00	AAPL	Stock	3.0225	3.0225	3.0207	3.0214	92148.0
2007-02-28 19:30:00	AAPL	Stock	3.0218	3.0225	3.0214	3.0214	111860.0
2007-02-28 04:00:00	MSFT	Stock	27.67	27.69	27.67	27.69	4500.0
2007-02-28 04:30:00	MSFT	Stock	27.73	27.73	27.65	27.65	3600.0
2007-02-28 05:00:00	MSFT	Stock	27.74	27.83	27.74	27.82	7700.0
2007-02-28 05:30:00	MSFT	Stock	27.83	27.83	27.83	27.83	100.0
2007-02-28 06:00:00	MSFT	Stock	27.92	27.92	27.85	27.92	6500.0
2007-02-28 06:30:00	MSFT	Stock	27.92	27.95	27.92	27.94	9000.0
2007-02-28 07:00:00	MSFT	Stock	27.94	27.94	27.88	27.93	39955.0
2007-02-28 07:30:00	MSFT	Stock	27.93	28.0	27.9	28.0	37440.0
2007-02-28 08:00:00	MSFT	Stock	27.97	28.12	27.91	28.05	177761.0
2007-02-28 08:30:00	MSFT	Stock	28.03	28.14	28.03	28.11	226938.0
2007-02-28 09:00:00	MSFT	Stock	28.12	28.15	27.87	27.95	5644379.0
2007-02-28 09:30:00	MSFT	Stock	27.95	28.24	27.92	28.16	13301801.0
2007-02-28 10:00:00	MSFT	Stock	28.16	28.16	28.01	28.07	10637005.0
2007-02-28 10:30:00	MSFT	Stock	28.08	28.25	28.03	28.07	7643512.0
2007-02-28 11:00:00	MSFT	Stock	28.07	28.2	28.01	28.02	4375363.0
2007-02-28 11:30:00	MSFT	Stock	28.02	28.24	28.0	28.02	4905817.0
2007-02-28 12:00:00	MSFT	Stock	28.02	28.13	27.97	28.1	3479182.0
2007-02-28 12:30:00	MSFT	Stock	28.1	28.15	28.088	28.1	2096108.0
2007-02-28 13:00:00	MSFT	Stock	28.1	28.11	28.05	28.1	2083013.0
2007-02-28 13:30:00	MSFT	Stock	28.1	28.11	28.04	28.06	2860331.0

> showing 50 of 55,253 rows — these rows as CSV

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