PREVIEW / stock_1hour / 2005-04-19

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-19.parquet
  size:    555 KB
  rows:    26,225
  symbols: 1,959

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-19 07:00:00	AAPL	Stock	1.2764	1.2821	1.2764	1.2821	72800.0
2005-04-19 08:00:00	AAPL	Stock	1.2839	1.2968	1.2786	1.2957	7411152.0
2005-04-19 09:00:00	AAPL	Stock	1.2957	1.3121	1.2811	1.295	186122076.0
2005-04-19 10:00:00	AAPL	Stock	1.295	1.3014	1.2875	1.2975	153536824.0
2005-04-19 11:00:00	AAPL	Stock	1.2982	1.3143	1.2954	1.3107	122018400.0
2005-04-19 12:00:00	AAPL	Stock	1.3107	1.3282	1.3093	1.3221	154551824.0
2005-04-19 13:00:00	AAPL	Stock	1.3221	1.3371	1.3193	1.3364	167918100.0
2005-04-19 14:00:00	AAPL	Stock	1.3364	1.3364	1.3214	1.3279	127348564.0
2005-04-19 15:00:00	AAPL	Stock	1.3275	1.3296	1.3221	1.3239	143505208.0
2005-04-19 16:00:00	AAPL	Stock	1.3246	1.3432	1.3221	1.3432	7288624.0
2005-04-19 17:00:00	AAPL	Stock	1.3429	1.3589	1.3246	1.3464	4341036.0
2005-04-19 18:00:00	AAPL	Stock	1.3461	1.3475	1.3446	1.345	285320.0
2005-04-19 08:00:00	MSFT	Stock	24.75	24.82	24.75	24.78	43276.0
2005-04-19 09:00:00	MSFT	Stock	24.78	24.8	24.61	24.66	9060411.0
2005-04-19 10:00:00	MSFT	Stock	24.66	24.75	24.45	24.53	10807162.0
2005-04-19 11:00:00	MSFT	Stock	24.53	24.59	24.48	24.55	6717895.0
2005-04-19 12:00:00	MSFT	Stock	24.54	24.6	24.52	24.57	5303488.0
2005-04-19 13:00:00	MSFT	Stock	24.57	24.64	24.52	24.61	5953073.0
2005-04-19 14:00:00	MSFT	Stock	24.6	24.63	24.53	24.57	6172976.0
2005-04-19 15:00:00	MSFT	Stock	24.57	24.63	24.53	24.62	12149712.0
2005-04-19 16:00:00	MSFT	Stock	24.62	25.04	24.56	24.8	7472643.0
2005-04-19 17:00:00	MSFT	Stock	24.79	24.83	24.62	24.81	175619.0
2005-04-19 18:00:00	MSFT	Stock	24.83	24.83	24.8	24.8	4280.0
2005-04-19 08:00:00	NVDA	Stock	0.1783	0.1802	0.1783	0.1802	192000.0
2005-04-19 09:00:00	NVDA	Stock	0.1802	0.1808	0.1787	0.1803	39088320.0
2005-04-19 10:00:00	NVDA	Stock	0.1802	0.1832	0.1802	0.1815	87203520.0
2005-04-19 11:00:00	NVDA	Stock	0.1815	0.1825	0.1812	0.1821	46718760.0
2005-04-19 12:00:00	NVDA	Stock	0.1821	0.1822	0.1808	0.1817	26884560.0
2005-04-19 13:00:00	NVDA	Stock	0.1817	0.1837	0.1817	0.1834	41318640.0
2005-04-19 14:00:00	NVDA	Stock	0.1834	0.1842	0.1828	0.1829	32445600.0
2005-04-19 15:00:00	NVDA	Stock	0.1829	0.184	0.1817	0.1828	80298000.0
2005-04-19 16:00:00	NVDA	Stock	0.1828	0.1867	0.1827	0.1867	3108960.0
2005-04-19 17:00:00	NVDA	Stock	0.1867	0.1871	0.1867	0.187	498000.0
2005-04-19 08:00:00	AMZN	Stock	1.6565	1.661	1.6565	1.661	32000.0
2005-04-19 09:00:00	AMZN	Stock	1.663	1.6685	1.6465	1.652	10494480.0
2005-04-19 10:00:00	AMZN	Stock	1.6513	1.6515	1.6055	1.607	36244120.0
2005-04-19 11:00:00	AMZN	Stock	1.607	1.63	1.601	1.622	20264940.0
2005-04-19 12:00:00	AMZN	Stock	1.622	1.624	1.6005	1.617	12701280.0
2005-04-19 13:00:00	AMZN	Stock	1.617	1.6415	1.6165	1.6415	11162080.0
2005-04-19 14:00:00	AMZN	Stock	1.6415	1.642	1.6275	1.6331	11745800.0
2005-04-19 15:00:00	AMZN	Stock	1.6335	1.645	1.6325	1.6425	20882940.0
2005-04-19 16:00:00	AMZN	Stock	1.64	1.6975	1.6255	1.6725	2535540.0
2005-04-19 17:00:00	AMZN	Stock	1.67	1.671	1.65	1.6665	56000.0
2005-04-19 18:00:00	AMZN	Stock	1.6665	1.6665	1.6665	1.6665	24000.0
2005-04-19 09:00:00	CL	Stock	26.165	26.18	26.125	26.155	290200.0
2005-04-19 10:00:00	CL	Stock	26.155	26.235	26.015	26.085	466400.0
2005-04-19 11:00:00	CL	Stock	26.08	26.095	26.005	26.055	489800.0
2005-04-19 12:00:00	CL	Stock	26.055	26.125	26.05	26.105	582000.0
2005-04-19 13:00:00	CL	Stock	26.105	26.135	26.005	26.08	334800.0
2005-04-19 14:00:00	CL	Stock	26.075	26.08	25.94	26.045	470800.0

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

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