PREVIEW / stock_1hour / 2005-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-15.parquet
  size:    558 KB
  rows:    26,154
  symbols: 1,962

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-04-15 08:00:00	AAPL	Stock	1.3071	1.33	1.3018	1.3204	11237072.0
2005-04-15 09:00:00	AAPL	Stock	1.3207	1.325	1.2718	1.2975	365688316.0
2005-04-15 10:00:00	AAPL	Stock	1.2975	1.3304	1.2804	1.3221	398384196.0
2005-04-15 11:00:00	AAPL	Stock	1.3225	1.3229	1.2875	1.2975	163679348.0
2005-04-15 12:00:00	AAPL	Stock	1.2979	1.3075	1.2821	1.2829	132874504.0
2005-04-15 13:00:00	AAPL	Stock	1.2826	1.3029	1.2825	1.29	110150964.0
2005-04-15 14:00:00	AAPL	Stock	1.29	1.3071	1.2736	1.2782	160641852.0
2005-04-15 15:00:00	AAPL	Stock	1.2779	1.2839	1.26	1.2614	319058880.0
2005-04-15 16:00:00	AAPL	Stock	1.2614	1.2664	1.2554	1.2571	18288200.0
2005-04-15 17:00:00	AAPL	Stock	1.2564	1.2621	1.2554	1.2607	1808212.0
2005-04-15 18:00:00	AAPL	Stock	1.2621	1.2625	1.2571	1.2593	220584.0
2005-04-15 08:00:00	MSFT	Stock	24.55	24.67	24.55	24.62	53790.0
2005-04-15 09:00:00	MSFT	Stock	24.62	24.84	24.48	24.74	17323267.0
2005-04-15 10:00:00	MSFT	Stock	24.74	24.78	24.61	24.77	13708201.0
2005-04-15 11:00:00	MSFT	Stock	24.77	24.778	24.6	24.65	10518197.0
2005-04-15 12:00:00	MSFT	Stock	24.64	24.72	24.6	24.61	5371955.0
2005-04-15 13:00:00	MSFT	Stock	24.61	24.81	24.57	24.75	6497660.0
2005-04-15 14:00:00	MSFT	Stock	24.76	24.9	24.64	24.71	11542394.0
2005-04-15 15:00:00	MSFT	Stock	24.72	24.73	24.41	24.45	20225876.0
2005-04-15 16:00:00	MSFT	Stock	24.45	24.51	24.436	24.5	8064271.0
2005-04-15 17:00:00	MSFT	Stock	24.48	24.663	24.45	24.48	328180.0
2005-04-15 18:00:00	MSFT	Stock	24.51	24.51	24.48	24.48	520.0
2005-04-15 08:00:00	NVDA	Stock	0.1839	0.1842	0.1839	0.1842	103800.0
2005-04-15 09:00:00	NVDA	Stock	0.1839	0.1839	0.1792	0.1797	78165360.0
2005-04-15 10:00:00	NVDA	Stock	0.1797	0.1801	0.1766	0.1785	125526600.0
2005-04-15 11:00:00	NVDA	Stock	0.1784	0.179	0.1773	0.1776	79362240.0
2005-04-15 12:00:00	NVDA	Stock	0.1776	0.1777	0.1762	0.1763	49102200.0
2005-04-15 13:00:00	NVDA	Stock	0.1763	0.1786	0.1762	0.1779	79785960.0
2005-04-15 14:00:00	NVDA	Stock	0.1779	0.1806	0.1779	0.1792	81470040.0
2005-04-15 15:00:00	NVDA	Stock	0.1791	0.1792	0.177	0.1783	119996520.0
2005-04-15 16:00:00	NVDA	Stock	0.1778	0.1784	0.1778	0.1783	1427760.0
2005-04-15 17:00:00	NVDA	Stock	0.1783	0.1783	0.1783	0.1783	10902600.0
2005-04-15 18:00:00	NVDA	Stock	0.1786	0.1786	0.1786	0.1786	197400.0
2005-04-15 08:00:00	AMZN	Stock	1.6825	1.6985	1.6825	1.6985	42000.0
2005-04-15 09:00:00	AMZN	Stock	1.6985	1.7	1.673	1.6895	17626680.0
2005-04-15 10:00:00	AMZN	Stock	1.6896	1.694	1.6755	1.686	14425020.0
2005-04-15 11:00:00	AMZN	Stock	1.6855	1.689	1.6685	1.675	9421800.0
2005-04-15 12:00:00	AMZN	Stock	1.675	1.68	1.664	1.665	20091740.0
2005-04-15 13:00:00	AMZN	Stock	1.665	1.6675	1.657	1.6616	10279240.0
2005-04-15 14:00:00	AMZN	Stock	1.6615	1.6735	1.6615	1.668	14370080.0
2005-04-15 15:00:00	AMZN	Stock	1.6675	1.6705	1.651	1.6515	28254600.0
2005-04-15 16:00:00	AMZN	Stock	1.654	1.66	1.65	1.653	1605280.0
2005-04-15 17:00:00	AMZN	Stock	1.652	1.655	1.652	1.655	236600.0
2005-04-15 18:00:00	AMZN	Stock	1.6634	1.6634	1.6634	1.6634	139060.0
2005-04-15 09:00:00	CL	Stock	26.655	26.925	26.58	26.925	828600.0
2005-04-15 10:00:00	CL	Stock	26.95	27.04	26.805	26.915	1115400.0
2005-04-15 11:00:00	CL	Stock	26.915	26.935	26.835	26.88	561000.0
2005-04-15 12:00:00	CL	Stock	26.88	26.95	26.785	26.88	485800.0
2005-04-15 13:00:00	CL	Stock	26.8765	26.93	26.76	26.79	531200.0
2005-04-15 14:00:00	CL	Stock	26.78	26.85	26.7	26.755	562000.0

> showing 50 of 26,154 rows — these rows as CSV

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