PREVIEW / stock_30min / 2007-09-12

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-12.parquet
  size:    1.1 MB
  rows:    63,685
  symbols: 3,114

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-09-12 09:30:00	AAPL	Stock	4.8571	4.9071	4.8482	4.8986	126175812.0
2007-09-12 10:00:00	AAPL	Stock	4.8986	4.9357	4.8971	4.9257	111166328.0
2007-09-12 10:30:00	AAPL	Stock	4.9254	4.9568	4.9207	4.9414	94483984.0
2007-09-12 11:00:00	AAPL	Stock	4.9411	4.9786	4.9321	4.9668	77248864.0
2007-09-12 11:30:00	AAPL	Stock	4.9671	4.9725	4.9429	4.9446	50073128.0
2007-09-12 12:00:00	AAPL	Stock	4.9446	4.9525	4.9132	4.9218	60654356.0
2007-09-12 12:30:00	AAPL	Stock	4.9221	4.9382	4.9111	4.9318	45282664.0
2007-09-12 13:00:00	AAPL	Stock	4.9315	4.9375	4.9075	4.9232	40680136.0
2007-09-12 13:30:00	AAPL	Stock	4.9229	4.9414	4.9121	4.935	46912684.0
2007-09-12 14:00:00	AAPL	Stock	4.935	4.9464	4.92	4.9221	46130840.0
2007-09-12 14:30:00	AAPL	Stock	4.9221	4.9311	4.9007	4.9196	59474520.0
2007-09-12 15:00:00	AAPL	Stock	4.9193	4.92	4.8896	4.8904	64007300.0
2007-09-12 15:30:00	AAPL	Stock	4.8904	4.9018	4.875	4.8868	89217688.0
2007-09-12 16:00:00	AAPL	Stock	4.8857	4.8889	4.8857	4.8875	8705200.0
2007-09-12 09:30:00	MSFT	Stock	28.81	28.99	28.8	28.99	2401950.0
2007-09-12 10:00:00	MSFT	Stock	28.98	28.98	28.92	28.93	1724039.0
2007-09-12 10:30:00	MSFT	Stock	28.93	28.99	28.9	28.98	2318376.0
2007-09-12 11:00:00	MSFT	Stock	28.99	29.17	28.96	29.12	2716542.0
2007-09-12 11:30:00	MSFT	Stock	29.12	29.15	29.021	29.04	2132572.0
2007-09-12 12:00:00	MSFT	Stock	29.049	29.11	28.99	29.02	2049497.0
2007-09-12 12:30:00	MSFT	Stock	29.02	29.07	29.0	29.05	1557684.0
2007-09-12 13:00:00	MSFT	Stock	29.05	29.06	28.94	29.04	1925591.0
2007-09-12 13:30:00	MSFT	Stock	29.03	29.14	29.01	29.11	2118905.0
2007-09-12 14:00:00	MSFT	Stock	29.1	29.13	29.05	29.07	1520659.0
2007-09-12 14:30:00	MSFT	Stock	29.07	29.08	29.019	29.06	1769137.0
2007-09-12 15:00:00	MSFT	Stock	29.07	29.08	28.92	28.92	2965684.0
2007-09-12 15:30:00	MSFT	Stock	28.92	28.98	28.88	28.91	4986719.0
2007-09-12 16:00:00	MSFT	Stock	28.9	28.93	28.9	28.93	1764537.0
2007-09-12 08:00:00	NVDA	Stock	0.8625	0.8645	0.8625	0.8645	40000.0
2007-09-12 08:30:00	NVDA	Stock	0.8645	0.8658	0.8645	0.8658	34160.0
2007-09-12 09:00:00	NVDA	Stock	0.8658	0.8728	0.8658	0.8728	563040.0
2007-09-12 09:30:00	NVDA	Stock	0.8738	0.8742	0.8625	0.8688	42728080.0
2007-09-12 10:00:00	NVDA	Stock	0.8688	0.87	0.8612	0.8688	29608640.0
2007-09-12 10:30:00	NVDA	Stock	0.8688	0.8735	0.8678	0.871	34151920.0
2007-09-12 11:00:00	NVDA	Stock	0.8712	0.8762	0.8708	0.875	24852720.0
2007-09-12 11:30:00	NVDA	Stock	0.875	0.878	0.8742	0.8765	22010080.0
2007-09-12 12:00:00	NVDA	Stock	0.8765	0.8768	0.871	0.8715	21944920.0
2007-09-12 12:30:00	NVDA	Stock	0.8715	0.872	0.8672	0.8695	25146640.0
2007-09-12 13:00:00	NVDA	Stock	0.8692	0.87	0.865	0.8652	28714480.0
2007-09-12 13:30:00	NVDA	Stock	0.865	0.8662	0.8608	0.8615	23911040.0
2007-09-12 14:00:00	NVDA	Stock	0.8612	0.8628	0.8548	0.8555	26506880.0
2007-09-12 14:30:00	NVDA	Stock	0.8557	0.8658	0.8302	0.832	68039840.0
2007-09-12 15:00:00	NVDA	Stock	0.8315	0.8375	0.8228	0.827	81514040.0
2007-09-12 15:30:00	NVDA	Stock	0.8265	0.8322	0.822	0.831	82552600.0
2007-09-12 16:00:00	NVDA	Stock	0.831	0.8325	0.8305	0.8312	14663880.0
2007-09-12 16:30:00	NVDA	Stock	0.8302	0.831	0.8302	0.831	102680.0
2007-09-12 17:00:00	NVDA	Stock	0.8312	0.835	0.83	0.83	116960.0
2007-09-12 17:30:00	NVDA	Stock	0.835	0.8398	0.835	0.8352	111400.0
2007-09-12 18:00:00	NVDA	Stock	0.8352	0.8358	0.8352	0.8352	62800.0
2007-09-12 18:30:00	NVDA	Stock	0.8375	0.8375	0.831	0.831	74800.0

> showing 50 of 63,685 rows — these rows as CSV

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