PREVIEW / stock_30min / 2007-08-31

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-31.parquet
  size:    1.1 MB
  rows:    64,180
  symbols: 3,117

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-08-31 09:30:00	AAPL	Stock	4.9821	4.9875	4.9432	4.9579	157027276.0
2007-08-31 10:00:00	AAPL	Stock	4.9582	4.9696	4.9161	4.9343	130520040.0
2007-08-31 10:30:00	AAPL	Stock	4.9341	4.9518	4.9264	4.93	65194500.0
2007-08-31 11:00:00	AAPL	Stock	4.9289	4.9375	4.9075	4.9214	71144864.0
2007-08-31 11:30:00	AAPL	Stock	4.9212	4.9461	4.9196	4.9407	55633984.0
2007-08-31 12:00:00	AAPL	Stock	4.9407	4.9429	4.9161	4.93	42944692.0
2007-08-31 12:30:00	AAPL	Stock	4.93	4.9429	4.9232	4.9304	32806676.0
2007-08-31 13:00:00	AAPL	Stock	4.9304	4.9343	4.9232	4.9304	22514604.0
2007-08-31 13:30:00	AAPL	Stock	4.9307	4.9318	4.9182	4.9275	26656336.0
2007-08-31 14:00:00	AAPL	Stock	4.9275	4.9321	4.9204	4.9257	21734692.0
2007-08-31 14:30:00	AAPL	Stock	4.9257	4.9343	4.9239	4.9275	22579144.0
2007-08-31 15:00:00	AAPL	Stock	4.9275	4.9554	4.9271	4.9382	51569532.0
2007-08-31 15:30:00	AAPL	Stock	4.9382	4.9536	4.9311	4.9443	75195988.0
2007-08-31 16:00:00	AAPL	Stock	4.945	4.9457	4.9404	4.9457	19468008.0
2007-08-31 09:30:00	MSFT	Stock	28.7	28.73	28.36	28.53	4301876.0
2007-08-31 10:00:00	MSFT	Stock	28.53	28.59	28.38	28.531	3210896.0
2007-08-31 10:30:00	MSFT	Stock	28.54	28.63	28.51	28.52	1959378.0
2007-08-31 11:00:00	MSFT	Stock	28.53	28.57	28.47	28.501	1760881.0
2007-08-31 11:30:00	MSFT	Stock	28.502	28.7	28.5	28.66	1508849.0
2007-08-31 12:00:00	MSFT	Stock	28.66	28.79	28.66	28.77	1822013.0
2007-08-31 12:30:00	MSFT	Stock	28.77	28.88	28.77	28.857	2516527.0
2007-08-31 13:00:00	MSFT	Stock	28.858	28.89	28.822	28.89	1578698.0
2007-08-31 13:30:00	MSFT	Stock	28.89	28.89	28.8	28.82	1335576.0
2007-08-31 14:00:00	MSFT	Stock	28.82	28.85	28.73	28.76	1334035.0
2007-08-31 14:30:00	MSFT	Stock	28.76	28.84	28.75	28.752	1439989.0
2007-08-31 15:00:00	MSFT	Stock	28.75	28.85	28.75	28.84	1584784.0
2007-08-31 15:30:00	MSFT	Stock	28.84	28.92	28.67	28.69	5815033.0
2007-08-31 16:00:00	MSFT	Stock	28.69	28.73	28.69	28.73	4742008.0
2007-08-31 07:30:00	NVDA	Stock	0.817	0.8255	0.817	0.8255	30000.0
2007-08-31 08:00:00	NVDA	Stock	0.819	0.8267	0.819	0.8267	570000.0
2007-08-31 08:30:00	NVDA	Stock	0.828	0.8292	0.8242	0.8253	1446000.0
2007-08-31 09:00:00	NVDA	Stock	0.8253	0.83	0.8242	0.83	960000.0
2007-08-31 09:30:00	NVDA	Stock	0.8283	0.8333	0.8238	0.8327	69910740.0
2007-08-31 10:00:00	NVDA	Stock	0.8328	0.8397	0.8293	0.8395	96304980.0
2007-08-31 10:30:00	NVDA	Stock	0.8393	0.8428	0.838	0.8415	54284100.0
2007-08-31 11:00:00	NVDA	Stock	0.8413	0.8438	0.8393	0.8417	51657060.0
2007-08-31 11:30:00	NVDA	Stock	0.8417	0.8487	0.8417	0.8463	50194200.0
2007-08-31 12:00:00	NVDA	Stock	0.8465	0.8558	0.8463	0.8548	55000200.0
2007-08-31 12:30:00	NVDA	Stock	0.855	0.855	0.8465	0.8498	53432940.0
2007-08-31 13:00:00	NVDA	Stock	0.8498	0.851	0.8472	0.8482	29470620.0
2007-08-31 13:30:00	NVDA	Stock	0.8482	0.8492	0.8438	0.8485	29760660.0
2007-08-31 14:00:00	NVDA	Stock	0.8485	0.85	0.8475	0.85	27171660.0
2007-08-31 14:30:00	NVDA	Stock	0.85	0.8538	0.849	0.8505	30585120.0
2007-08-31 15:00:00	NVDA	Stock	0.8505	0.8557	0.8502	0.8538	42278160.0
2007-08-31 15:30:00	NVDA	Stock	0.8537	0.8545	0.8503	0.8522	72317520.0
2007-08-31 16:00:00	NVDA	Stock	0.8527	0.8558	0.8527	0.853	26223300.0
2007-08-31 16:30:00	NVDA	Stock	0.8525	0.8542	0.8525	0.8542	627840.0
2007-08-31 18:00:00	NVDA	Stock	0.852	0.852	0.852	0.852	36000.0
2007-08-31 18:30:00	NVDA	Stock	0.8545	0.8545	0.8545	0.8545	22200.0
2007-08-31 19:00:00	NVDA	Stock	0.8547	0.8558	0.8542	0.8542	129000.0

> showing 50 of 64,180 rows — these rows as CSV

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