PREVIEW / stock_30min / 2006-01-17

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-01-17.parquet
  size:    892 KB
  rows:    48,251
  symbols: 2,184

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
2006-01-17 04:00:00	AAPL	Stock	3.0571	3.0571	3.0571	3.0571	2800.0
2006-01-17 04:30:00	AAPL	Stock	3.0518	3.0518	3.0518	3.0518	56000.0
2006-01-17 05:00:00	AAPL	Stock	3.0446	3.0446	3.0446	3.0446	2800.0
2006-01-17 05:30:00	AAPL	Stock	3.0482	3.0482	3.0482	3.0482	5600.0
2006-01-17 06:00:00	AAPL	Stock	3.0411	3.0411	3.0411	3.0411	11200.0
2006-01-17 06:30:00	AAPL	Stock	3.0446	3.0446	3.0446	3.0446	16800.0
2006-01-17 07:00:00	AAPL	Stock	3.0357	3.0464	3.0357	3.0429	181440.0
2006-01-17 07:30:00	AAPL	Stock	3.04	3.0482	3.0357	3.0482	64400.0
2006-01-17 08:00:00	AAPL	Stock	3.0454	3.0604	3.0454	3.0475	2996224.0
2006-01-17 08:30:00	AAPL	Stock	3.0471	3.0536	3.0393	3.0489	2423792.0
2006-01-17 09:00:00	AAPL	Stock	3.0482	3.0639	3.0461	3.0621	4064228.0
2006-01-17 09:30:00	AAPL	Stock	3.0607	3.085	3.0511	3.0607	127135792.0
2006-01-17 10:00:00	AAPL	Stock	3.0604	3.0654	3.0411	3.0529	89064500.0
2006-01-17 10:30:00	AAPL	Stock	3.0532	3.0714	3.025	3.0282	72683212.0
2006-01-17 11:00:00	AAPL	Stock	3.0289	3.0393	3.0093	3.0139	70287616.0
2006-01-17 11:30:00	AAPL	Stock	3.0136	3.0198	3.0018	3.0079	63057512.0
2006-01-17 12:00:00	AAPL	Stock	3.0079	3.0132	2.9954	3.0046	60100040.0
2006-01-17 12:30:00	AAPL	Stock	3.0043	3.0211	3.0036	3.0164	38613848.0
2006-01-17 13:00:00	AAPL	Stock	3.0168	3.0171	3.0	3.0032	41988744.0
2006-01-17 13:30:00	AAPL	Stock	3.0025	3.0196	3.0007	3.0146	29095108.0
2006-01-17 14:00:00	AAPL	Stock	3.0146	3.0236	3.0054	3.0068	37275924.0
2006-01-17 14:30:00	AAPL	Stock	3.0071	3.0582	3.0054	3.035	41805904.0
2006-01-17 15:00:00	AAPL	Stock	3.035	3.0625	3.0239	3.0296	52153444.0
2006-01-17 15:30:00	AAPL	Stock	3.0293	3.03	3.0125	3.0268	68586924.0
2006-01-17 16:00:00	AAPL	Stock	3.0243	3.0314	2.9914	3.0068	5851132.0
2006-01-17 16:30:00	AAPL	Stock	2.9932	2.9946	2.9571	2.9875	3655596.0
2006-01-17 17:00:00	AAPL	Stock	2.9875	3.0254	2.9714	2.9821	15195740.0
2006-01-17 17:30:00	AAPL	Stock	2.9821	2.9821	2.9711	2.9729	761180.0
2006-01-17 18:00:00	AAPL	Stock	2.9729	2.9768	2.9661	2.9714	1156064.0
2006-01-17 04:00:00	MSFT	Stock	27.2	27.2	27.1	27.1	500.0
2006-01-17 04:30:00	MSFT	Stock	27.1	27.1	27.01	27.01	784.0
2006-01-17 08:00:00	MSFT	Stock	27.0	27.07	26.95	26.96	25615.0
2006-01-17 08:30:00	MSFT	Stock	26.98	26.98	26.96	26.96	3144.0
2006-01-17 09:00:00	MSFT	Stock	26.98	27.02	26.9	26.9	174841.0
2006-01-17 09:30:00	MSFT	Stock	26.9	27.04	26.9	26.98	8373327.0
2006-01-17 10:00:00	MSFT	Stock	26.98	27.09	26.97	27.06	4288239.0
2006-01-17 10:30:00	MSFT	Stock	27.07	27.09	26.96	27.06	4595659.0
2006-01-17 11:00:00	MSFT	Stock	27.06	27.12	27.03	27.11	3136032.0
2006-01-17 11:30:00	MSFT	Stock	27.12	27.15	27.08	27.08	3101646.0
2006-01-17 12:00:00	MSFT	Stock	27.08	27.15	27.08	27.102	2836073.0
2006-01-17 12:30:00	MSFT	Stock	27.1	27.19	26.95	27.1	1864892.0
2006-01-17 13:00:00	MSFT	Stock	27.09	27.1	27.029	27.06	3168997.0
2006-01-17 13:30:00	MSFT	Stock	27.06	27.11	27.02	27.08	3529322.0
2006-01-17 14:00:00	MSFT	Stock	27.08	27.14	27.05	27.06	3534469.0
2006-01-17 14:30:00	MSFT	Stock	27.062	27.11	27.02	27.1	3279837.0
2006-01-17 15:00:00	MSFT	Stock	27.1	27.12	27.05	27.06	3344212.0
2006-01-17 15:30:00	MSFT	Stock	27.06	27.1	26.96	27.03	7284470.0
2006-01-17 16:00:00	MSFT	Stock	26.99	27.08	26.75	26.75	631165.0
2006-01-17 16:30:00	MSFT	Stock	26.8	27.04	26.51	26.53	818079.0
2006-01-17 17:00:00	MSFT	Stock	26.54	26.7	26.54	26.7	55476.0

> showing 50 of 48,251 rows — these rows as CSV

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