PREVIEW / stock_1hour / 2005-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-14.parquet
  size:    554 KB
  rows:    25,999
  symbols: 1,960

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-14 05:00:00	AAPL	Stock	1.4518	1.4518	1.4518	1.4518	179200.0
2005-04-14 06:00:00	AAPL	Stock	1.4482	1.4482	1.4482	1.4482	56000.0
2005-04-14 07:00:00	AAPL	Stock	1.4286	1.4429	1.4261	1.4286	545580.0
2005-04-14 08:00:00	AAPL	Stock	1.4286	1.4429	1.3839	1.3868	79211916.0
2005-04-14 09:00:00	AAPL	Stock	1.3868	1.4129	1.3596	1.4036	652931776.0
2005-04-14 10:00:00	AAPL	Stock	1.4032	1.4279	1.3729	1.3939	399426076.0
2005-04-14 11:00:00	AAPL	Stock	1.394	1.3968	1.3782	1.3786	186804996.0
2005-04-14 12:00:00	AAPL	Stock	1.3786	1.3857	1.3518	1.3539	298838792.0
2005-04-14 13:00:00	AAPL	Stock	1.3539	1.3589	1.3157	1.3182	414185324.0
2005-04-14 14:00:00	AAPL	Stock	1.3189	1.3454	1.3168	1.3425	328714176.0
2005-04-14 15:00:00	AAPL	Stock	1.3425	1.3489	1.3196	1.3314	354859400.0
2005-04-14 16:00:00	AAPL	Stock	1.3307	1.4087	1.3089	1.3118	17895108.0
2005-04-14 17:00:00	AAPL	Stock	1.3136	1.3314	1.3086	1.3164	2348304.0
2005-04-14 18:00:00	AAPL	Stock	1.3125	1.3161	1.3036	1.3071	1118460.0
2005-04-14 08:00:00	MSFT	Stock	25.01	25.03	25.01	25.03	16067.0
2005-04-14 09:00:00	MSFT	Stock	25.03	25.11	25.0	25.07	6592028.0
2005-04-14 10:00:00	MSFT	Stock	25.07	25.08	24.83	24.94	12332643.0
2005-04-14 11:00:00	MSFT	Stock	24.94	25.08	24.91	24.96	9243140.0
2005-04-14 12:00:00	MSFT	Stock	24.96	25.09	24.93	25.05	6124645.0
2005-04-14 13:00:00	MSFT	Stock	25.05	25.08	24.93	25.02	7459531.0
2005-04-14 14:00:00	MSFT	Stock	25.01	25.05	24.95	24.98	9953876.0
2005-04-14 15:00:00	MSFT	Stock	24.98	25.14	24.83	24.85	12330828.0
2005-04-14 16:00:00	MSFT	Stock	24.86	24.87	24.55	24.55	723221.0
2005-04-14 17:00:00	MSFT	Stock	24.55	24.858	24.54	24.6	529099.0
2005-04-14 18:00:00	MSFT	Stock	24.6	24.6	24.57	24.6	6292.0
2005-04-14 08:00:00	NVDA	Stock	0.1872	0.1873	0.1872	0.1873	42000.0
2005-04-14 09:00:00	NVDA	Stock	0.1869	0.1872	0.1847	0.1862	40273680.0
2005-04-14 10:00:00	NVDA	Stock	0.186	0.1867	0.184	0.1863	77168760.0
2005-04-14 11:00:00	NVDA	Stock	0.1862	0.1872	0.1857	0.1869	39362280.0
2005-04-14 12:00:00	NVDA	Stock	0.1869	0.188	0.1867	0.1871	59470680.0
2005-04-14 13:00:00	NVDA	Stock	0.1871	0.1873	0.185	0.1857	38701680.0
2005-04-14 14:00:00	NVDA	Stock	0.1857	0.1872	0.1852	0.1852	32703480.0
2005-04-14 15:00:00	NVDA	Stock	0.1852	0.1853	0.1837	0.1842	59865240.0
2005-04-14 16:00:00	NVDA	Stock	0.1839	0.1842	0.1825	0.1825	1443240.0
2005-04-14 17:00:00	NVDA	Stock	0.1829	0.1843	0.1829	0.1829	1476000.0
2005-04-14 08:00:00	AMZN	Stock	1.7075	1.7365	1.7075	1.7225	20000.0
2005-04-14 09:00:00	AMZN	Stock	1.7105	1.725	1.71	1.7215	7194500.0
2005-04-14 10:00:00	AMZN	Stock	1.7215	1.7235	1.701	1.708	20516860.0
2005-04-14 11:00:00	AMZN	Stock	1.7075	1.715	1.701	1.701	9934980.0
2005-04-14 12:00:00	AMZN	Stock	1.7005	1.7045	1.694	1.6965	8216020.0
2005-04-14 13:00:00	AMZN	Stock	1.697	1.702	1.696	1.7015	12793560.0
2005-04-14 14:00:00	AMZN	Stock	1.7015	1.71	1.7005	1.7055	9594200.0
2005-04-14 15:00:00	AMZN	Stock	1.7055	1.7075	1.6975	1.6995	14180180.0
2005-04-14 16:00:00	AMZN	Stock	1.6995	1.7005	1.6935	1.6935	368140.0
2005-04-14 17:00:00	AMZN	Stock	1.698	1.6985	1.6855	1.6984	162700.0
2005-04-14 18:00:00	AMZN	Stock	1.6885	1.6935	1.685	1.6935	63600.0
2005-04-14 09:00:00	CL	Stock	26.965	27.03	26.875	26.9	341000.0
2005-04-14 10:00:00	CL	Stock	26.89	27.04	26.815	26.93	795400.0
2005-04-14 11:00:00	CL	Stock	26.935	26.975	26.8	26.81	575000.0
2005-04-14 12:00:00	CL	Stock	26.81	26.91	26.8	26.855	342000.0

> showing 50 of 25,999 rows — these rows as CSV

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