PREVIEW / stock_1hour / 2005-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-01.parquet
  size:    555 KB
  rows:    26,624
  symbols: 2,012

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-07-01 08:00:00	AAPL	Stock	1.3179	1.3214	1.3146	1.3196	310940.0
2005-07-01 09:00:00	AAPL	Stock	1.3196	1.3221	1.31	1.3125	44919140.0
2005-07-01 10:00:00	AAPL	Stock	1.3125	1.3179	1.3089	1.3114	50615264.0
2005-07-01 11:00:00	AAPL	Stock	1.3111	1.3118	1.3014	1.3021	35429268.0
2005-07-01 12:00:00	AAPL	Stock	1.3025	1.3054	1.2961	1.3043	30601116.0
2005-07-01 13:00:00	AAPL	Stock	1.3039	1.3096	1.3011	1.3075	17800384.0
2005-07-01 14:00:00	AAPL	Stock	1.3071	1.3114	1.305	1.3086	20058612.0
2005-07-01 15:00:00	AAPL	Stock	1.3089	1.3089	1.3014	1.3039	34711712.0
2005-07-01 16:00:00	AAPL	Stock	1.3036	1.3065	1.3029	1.3036	1942584.0
2005-07-01 17:00:00	AAPL	Stock	1.3061	1.3071	1.3036	1.3064	526400.0
2005-07-01 18:00:00	AAPL	Stock	1.3057	1.3057	1.3036	1.3036	33208.0
2005-07-01 08:00:00	MSFT	Stock	24.9	24.92	24.84	24.89	140147.0
2005-07-01 09:00:00	MSFT	Stock	24.87	24.99	24.84	24.93	7892476.0
2005-07-01 10:00:00	MSFT	Stock	24.92	24.99	24.86	24.96	10274310.0
2005-07-01 11:00:00	MSFT	Stock	24.96	24.96	24.84	24.86	6889093.0
2005-07-01 12:00:00	MSFT	Stock	24.86	24.92	24.83	24.86	6034546.0
2005-07-01 13:00:00	MSFT	Stock	24.86	24.87	24.75	24.75	5985564.0
2005-07-01 14:00:00	MSFT	Stock	24.76	24.83	24.74	24.75	7801166.0
2005-07-01 15:00:00	MSFT	Stock	24.76	24.846	24.67	24.7	13071017.0
2005-07-01 16:00:00	MSFT	Stock	24.72	24.77	24.7	24.74	8803150.0
2005-07-01 17:00:00	MSFT	Stock	24.74	24.74	24.73	24.74	8348.0
2005-07-01 18:00:00	MSFT	Stock	24.74	24.75	24.74	24.75	3800.0
2005-07-01 08:00:00	NVDA	Stock	0.2232	0.2252	0.2232	0.2252	972000.0
2005-07-01 09:00:00	NVDA	Stock	0.2242	0.2242	0.2193	0.2206	55819920.0
2005-07-01 10:00:00	NVDA	Stock	0.2206	0.2217	0.2192	0.2208	67011840.0
2005-07-01 11:00:00	NVDA	Stock	0.2208	0.2218	0.2204	0.2213	29093760.0
2005-07-01 12:00:00	NVDA	Stock	0.2213	0.2216	0.2208	0.2212	20091240.0
2005-07-01 13:00:00	NVDA	Stock	0.2212	0.2227	0.221	0.2219	23805120.0
2005-07-01 14:00:00	NVDA	Stock	0.2219	0.224	0.2218	0.2228	47386800.0
2005-07-01 15:00:00	NVDA	Stock	0.2228	0.2237	0.2222	0.2236	52052760.0
2005-07-01 16:00:00	NVDA	Stock	0.2235	0.2238	0.2213	0.2227	3053760.0
2005-07-01 08:00:00	AMZN	Stock	1.6545	1.664	1.654	1.664	339200.0
2005-07-01 09:00:00	AMZN	Stock	1.658	1.6635	1.646	1.65	9573260.0
2005-07-01 10:00:00	AMZN	Stock	1.6505	1.6615	1.649	1.65	11455480.0
2005-07-01 11:00:00	AMZN	Stock	1.65	1.6555	1.645	1.6505	8413300.0
2005-07-01 12:00:00	AMZN	Stock	1.6505	1.6555	1.645	1.649	5198560.0
2005-07-01 13:00:00	AMZN	Stock	1.649	1.655	1.6475	1.6525	4424600.0
2005-07-01 14:00:00	AMZN	Stock	1.6525	1.6557	1.65	1.6515	5297240.0
2005-07-01 15:00:00	AMZN	Stock	1.651	1.6515	1.6395	1.646	10335180.0
2005-07-01 16:00:00	AMZN	Stock	1.6465	1.6478	1.6365	1.6415	709960.0
2005-07-01 17:00:00	AMZN	Stock	1.6455	1.6455	1.6455	1.6455	2000.0
2005-07-01 09:00:00	CL	Stock	25.07	25.325	25.05	25.17	684000.0
2005-07-01 10:00:00	CL	Stock	25.175	25.22	25.085	25.18	584800.0
2005-07-01 11:00:00	CL	Stock	25.175	25.2	25.03	25.065	529200.0
2005-07-01 12:00:00	CL	Stock	25.07	25.095	24.965	25.0	452400.0
2005-07-01 13:00:00	CL	Stock	25.005	25.07	24.99	25.025	202600.0
2005-07-01 14:00:00	CL	Stock	25.025	25.065	24.99	25.025	236200.0
2005-07-01 15:00:00	CL	Stock	25.025	25.065	24.995	25.05	475200.0
2005-07-01 16:00:00	CL	Stock	25.026	25.026	25.025	25.025	31000.0
2005-07-01 17:00:00	CL	Stock	25.025	25.025	25.025	25.025	156000.0

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

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