PREVIEW / stock_1hour / 2005-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-30.parquet
  size:    572 KB
  rows:    27,093
  symbols: 2,030

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-06-30 08:00:00	AAPL	Stock	1.2989	1.3125	1.2989	1.3111	577556.0
2005-06-30 09:00:00	AAPL	Stock	1.3107	1.3136	1.2968	1.2996	51480632.0
2005-06-30 10:00:00	AAPL	Stock	1.2996	1.3061	1.2971	1.3032	48021540.0
2005-06-30 11:00:00	AAPL	Stock	1.3032	1.3061	1.3007	1.3043	31967124.0
2005-06-30 12:00:00	AAPL	Stock	1.3043	1.3168	1.3029	1.3164	35283192.0
2005-06-30 13:00:00	AAPL	Stock	1.3167	1.3239	1.3154	1.3211	47101068.0
2005-06-30 14:00:00	AAPL	Stock	1.3211	1.3271	1.31	1.3143	97188084.0
2005-06-30 15:00:00	AAPL	Stock	1.3143	1.3229	1.3121	1.3143	77674604.0
2005-06-30 16:00:00	AAPL	Stock	1.3139	1.3168	1.3104	1.3146	6703088.0
2005-06-30 17:00:00	AAPL	Stock	1.315	1.315	1.315	1.315	44800.0
2005-06-30 18:00:00	AAPL	Stock	1.3136	1.3136	1.3136	1.3136	11200.0
2005-06-30 08:00:00	MSFT	Stock	25.1	25.15	25.1	25.14	18013.0
2005-06-30 09:00:00	MSFT	Stock	25.14	25.15	25.04	25.08	7488979.0
2005-06-30 10:00:00	MSFT	Stock	25.079	25.11	25.04	25.05	9434709.0
2005-06-30 11:00:00	MSFT	Stock	25.05	25.08	25.0	25.02	9018811.0
2005-06-30 12:00:00	MSFT	Stock	25.01	25.05	25.01	25.03	5671536.0
2005-06-30 13:00:00	MSFT	Stock	25.031	25.07	24.99	25.03	6433414.0
2005-06-30 14:00:00	MSFT	Stock	25.02	25.06	24.87	24.96	15284297.0
2005-06-30 15:00:00	MSFT	Stock	24.96	25.0	24.82	24.84	17451175.0
2005-06-30 16:00:00	MSFT	Stock	24.84	24.842	24.8	24.84	1443196.0
2005-06-30 17:00:00	MSFT	Stock	24.82	24.987	24.8	24.81	1117091.0
2005-06-30 18:00:00	MSFT	Stock	24.82	25.48	24.79	24.82	14430.0
2005-06-30 08:00:00	NVDA	Stock	0.225	0.225	0.2234	0.2234	36000.0
2005-06-30 09:00:00	NVDA	Stock	0.2244	0.2262	0.2233	0.2247	86129160.0
2005-06-30 10:00:00	NVDA	Stock	0.2247	0.2268	0.2247	0.2257	50896200.0
2005-06-30 11:00:00	NVDA	Stock	0.2256	0.2256	0.222	0.2226	113681880.0
2005-06-30 12:00:00	NVDA	Stock	0.2226	0.2229	0.2209	0.2225	65088960.0
2005-06-30 13:00:00	NVDA	Stock	0.2226	0.2241	0.2225	0.2237	45732000.0
2005-06-30 14:00:00	NVDA	Stock	0.2238	0.2241	0.2217	0.2229	111569880.0
2005-06-30 15:00:00	NVDA	Stock	0.223	0.2238	0.2219	0.2227	72925560.0
2005-06-30 16:00:00	NVDA	Stock	0.2226	0.2229	0.2217	0.2227	10206480.0
2005-06-30 17:00:00	NVDA	Stock	0.2238	0.2238	0.2238	0.2238	5359200.0
2005-06-30 08:00:00	AMZN	Stock	1.6695	1.6695	1.6695	1.6695	60000.0
2005-06-30 09:00:00	AMZN	Stock	1.67	1.678	1.6575	1.6635	11725460.0
2005-06-30 10:00:00	AMZN	Stock	1.6635	1.671	1.662	1.671	14000180.0
2005-06-30 11:00:00	AMZN	Stock	1.671	1.6715	1.667	1.6685	7814420.0
2005-06-30 12:00:00	AMZN	Stock	1.668	1.6695	1.6635	1.664	9992320.0
2005-06-30 13:00:00	AMZN	Stock	1.6635	1.6648	1.654	1.6615	10079440.0
2005-06-30 14:00:00	AMZN	Stock	1.6615	1.67	1.653	1.656	18406900.0
2005-06-30 15:00:00	AMZN	Stock	1.6565	1.662	1.6465	1.6545	33391100.0
2005-06-30 16:00:00	AMZN	Stock	1.6515	1.655	1.6515	1.654	2180140.0
2005-06-30 17:00:00	AMZN	Stock	1.6515	1.655	1.651	1.6545	51400.0
2005-06-30 18:00:00	AMZN	Stock	1.651	1.658	1.651	1.658	40000.0
2005-06-30 09:00:00	CL	Stock	25.45	25.495	25.38	25.38	400600.0
2005-06-30 10:00:00	CL	Stock	25.375	25.385	25.19	25.33	806800.0
2005-06-30 11:00:00	CL	Stock	25.33	25.34	25.165	25.18	654800.0
2005-06-30 12:00:00	CL	Stock	25.185	25.185	25.115	25.17	544000.0
2005-06-30 13:00:00	CL	Stock	25.17	25.2	25.085	25.125	350200.0
2005-06-30 14:00:00	CL	Stock	25.125	25.17	25.01	25.125	830000.0
2005-06-30 15:00:00	CL	Stock	25.12	25.135	24.945	24.96	1114600.0

> showing 50 of 27,093 rows — these rows as CSV

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