PREVIEW / stock_30min / 2005-09-20

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-09-20.parquet
  size:    862 KB
  rows:    46,509
  symbols: 2,068

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
2005-09-20 07:30:00	AAPL	Stock	1.8929	1.8929	1.8929	1.8929	142800.0
2005-09-20 08:00:00	AAPL	Stock	1.8929	1.9068	1.8875	1.9036	3775968.0
2005-09-20 08:30:00	AAPL	Stock	1.9029	1.9036	1.8982	1.8996	1404592.0
2005-09-20 09:00:00	AAPL	Stock	1.8993	1.9025	1.88	1.8925	2650592.0
2005-09-20 09:30:00	AAPL	Stock	1.8925	1.9068	1.8914	1.9	96760524.0
2005-09-20 10:00:00	AAPL	Stock	1.9	1.9164	1.8964	1.9139	94823512.0
2005-09-20 10:30:00	AAPL	Stock	1.9136	1.9218	1.9125	1.9146	59349192.0
2005-09-20 11:00:00	AAPL	Stock	1.9146	1.9204	1.9093	1.9182	33089000.0
2005-09-20 11:30:00	AAPL	Stock	1.9182	1.9207	1.9161	1.9161	20409648.0
2005-09-20 12:00:00	AAPL	Stock	1.9161	1.9164	1.9104	1.9132	21855008.0
2005-09-20 12:30:00	AAPL	Stock	1.9132	1.9154	1.9111	1.9111	12132988.0
2005-09-20 13:00:00	AAPL	Stock	1.9118	1.9121	1.9014	1.9061	24194156.0
2005-09-20 13:30:00	AAPL	Stock	1.9061	1.9118	1.9018	1.9096	26006876.0
2005-09-20 14:00:00	AAPL	Stock	1.9096	1.9164	1.905	1.9121	59746092.0
2005-09-20 14:30:00	AAPL	Stock	1.9121	1.9175	1.8946	1.8996	86490880.0
2005-09-20 15:00:00	AAPL	Stock	1.8996	1.9127	1.89	1.9046	82546828.0
2005-09-20 15:30:00	AAPL	Stock	1.905	1.9075	1.8993	1.9011	61415340.0
2005-09-20 16:00:00	AAPL	Stock	1.8996	1.9036	1.8996	1.9021	48643448.0
2005-09-20 16:30:00	AAPL	Stock	1.9021	1.9054	1.8996	1.9021	793128.0
2005-09-20 17:00:00	AAPL	Stock	1.9036	1.9054	1.8996	1.905	398888.0
2005-09-20 17:30:00	AAPL	Stock	1.9025	1.9054	1.9025	1.9046	126000.0
2005-09-20 18:00:00	AAPL	Stock	1.9018	1.9018	1.9	1.9018	92876.0
2005-09-20 08:00:00	MSFT	Stock	26.05	26.06	26.05	26.06	4585.0
2005-09-20 08:30:00	MSFT	Stock	26.08	26.09	26.07	26.07	1400.0
2005-09-20 09:00:00	MSFT	Stock	26.07	26.08	26.01	26.08	65250.0
2005-09-20 09:30:00	MSFT	Stock	26.07	26.18	26.03	26.12	5286172.0
2005-09-20 10:00:00	MSFT	Stock	26.11	26.2	26.11	26.19	4664275.0
2005-09-20 10:30:00	MSFT	Stock	26.18	26.22	26.1	26.16	3800368.0
2005-09-20 11:00:00	MSFT	Stock	26.17	26.181	26.07	26.1	2615367.0
2005-09-20 11:30:00	MSFT	Stock	26.09	26.12	26.09	26.11	1168448.0
2005-09-20 12:00:00	MSFT	Stock	26.12	26.15	26.07	26.08	1545609.0
2005-09-20 12:30:00	MSFT	Stock	26.08	26.11	26.08	26.109	1006997.0
2005-09-20 13:00:00	MSFT	Stock	26.11	26.11	25.98	26.0	3510455.0
2005-09-20 13:30:00	MSFT	Stock	26.0	26.05	25.96	25.97	2769815.0
2005-09-20 14:00:00	MSFT	Stock	25.96	26.08	25.91	25.95	4911419.0
2005-09-20 14:30:00	MSFT	Stock	25.95	26.12	25.79	25.81	7572694.0
2005-09-20 15:00:00	MSFT	Stock	25.81	26.112	25.69	25.86	9838820.0
2005-09-20 15:30:00	MSFT	Stock	25.87	25.998	25.77	25.84	8106223.0
2005-09-20 16:00:00	MSFT	Stock	25.85	25.85	25.78	25.81	245286.0
2005-09-20 16:30:00	MSFT	Stock	25.78	25.84	25.741	25.81	117591.0
2005-09-20 17:00:00	MSFT	Stock	25.83	25.83	25.81	25.81	6880.0
2005-09-20 17:30:00	MSFT	Stock	25.81	25.81	25.81	25.81	2400.0
2005-09-20 18:00:00	MSFT	Stock	25.81	26.03	25.81	26.03	50862.0
2005-09-20 08:30:00	NVDA	Stock	0.2749	0.2749	0.2747	0.2747	216000.0
2005-09-20 09:00:00	NVDA	Stock	0.2747	0.2757	0.2732	0.2753	4295280.0
2005-09-20 09:30:00	NVDA	Stock	0.2752	0.2776	0.2749	0.2774	63143280.0
2005-09-20 10:00:00	NVDA	Stock	0.2774	0.2809	0.2774	0.2792	62620080.0
2005-09-20 10:30:00	NVDA	Stock	0.2792	0.2803	0.2792	0.2795	30980280.0
2005-09-20 11:00:00	NVDA	Stock	0.2795	0.2797	0.2784	0.2797	29505480.0
2005-09-20 11:30:00	NVDA	Stock	0.2797	0.2807	0.2793	0.2804	17475960.0

> showing 50 of 46,509 rows — these rows as CSV

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