PREVIEW / stock_1hour / 2009-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-05.parquet
  size:    847 KB
  rows:    41,351
  symbols: 3,351

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
2009-06-05 04:00:00	AAPL	Stock	5.2207	5.2679	5.2207	5.2679	9464.0
2009-06-05 05:00:00	AAPL	Stock	5.2768	5.2857	5.2768	5.2857	7000.0
2009-06-05 06:00:00	AAPL	Stock	5.2507	5.2507	5.2411	5.25	77000.0
2009-06-05 07:00:00	AAPL	Stock	5.2871	5.2911	5.2114	5.2464	2900156.0
2009-06-05 08:00:00	AAPL	Stock	5.2418	5.2536	5.2071	5.2161	9444120.0
2009-06-05 09:00:00	AAPL	Stock	5.2157	5.2311	5.1464	5.1796	162993376.0
2009-06-05 10:00:00	AAPL	Stock	5.1793	5.1907	5.1268	5.1368	152398260.0
2009-06-05 11:00:00	AAPL	Stock	5.1371	5.1779	5.1307	5.1524	72184644.0
2009-06-05 12:00:00	AAPL	Stock	5.1532	5.1743	5.1454	5.1711	32696384.0
2009-06-05 13:00:00	AAPL	Stock	5.1704	5.1729	5.1479	5.162	30031204.0
2009-06-05 14:00:00	AAPL	Stock	5.1586	5.1607	5.1146	5.1436	66589600.0
2009-06-05 15:00:00	AAPL	Stock	5.1432	5.1768	5.1389	5.1675	88424084.0
2009-06-05 16:00:00	AAPL	Stock	5.1675	5.1704	5.1429	5.1654	7850584.0
2009-06-05 17:00:00	AAPL	Stock	5.1654	5.1671	5.1357	5.1536	789348.0
2009-06-05 18:00:00	AAPL	Stock	5.1536	5.1668	5.1529	5.1571	505848.0
2009-06-05 19:00:00	AAPL	Stock	5.1596	5.1643	5.1518	5.1571	177044.0
2009-06-05 08:00:00	MSFT	Stock	21.9	22.02	21.82	22.0	94369.0
2009-06-05 09:00:00	MSFT	Stock	21.97	22.23	21.86	22.11	10092292.0
2009-06-05 10:00:00	MSFT	Stock	22.11	22.12	21.81	22.06	10183101.0
2009-06-05 11:00:00	MSFT	Stock	22.06	22.12	21.95	22.05	4829783.0
2009-06-05 12:00:00	MSFT	Stock	22.065	22.1	21.97	21.99	5135025.0
2009-06-05 13:00:00	MSFT	Stock	22.0	22.05	21.95	22.04	3819723.0
2009-06-05 14:00:00	MSFT	Stock	22.04	22.08	21.93	22.07	6135038.0
2009-06-05 15:00:00	MSFT	Stock	22.075	22.31	22.06	22.16	14584085.0
2009-06-05 16:00:00	MSFT	Stock	22.14	22.16	22.064	22.13	2635036.0
2009-06-05 17:00:00	MSFT	Stock	22.12	22.14	22.12	22.14	639308.0
2009-06-05 18:00:00	MSFT	Stock	22.15	22.23	22.15	22.23	12289.0
2009-06-05 19:00:00	MSFT	Stock	22.21	22.23	22.16	22.22	4173.0
2009-06-05 08:00:00	NVDA	Stock	0.275	0.2783	0.273	0.2775	676400.0
2009-06-05 09:00:00	NVDA	Stock	0.2775	0.2775	0.2675	0.2688	109199960.0
2009-06-05 10:00:00	NVDA	Stock	0.2688	0.2732	0.2675	0.273	148551320.0
2009-06-05 11:00:00	NVDA	Stock	0.273	0.2732	0.2706	0.2718	64889280.0
2009-06-05 12:00:00	NVDA	Stock	0.2718	0.2732	0.2714	0.2723	46452520.0
2009-06-05 13:00:00	NVDA	Stock	0.2723	0.2732	0.2712	0.2723	49426240.0
2009-06-05 14:00:00	NVDA	Stock	0.272	0.2723	0.2683	0.269	55172000.0
2009-06-05 15:00:00	NVDA	Stock	0.2692	0.272	0.2688	0.271	76897920.0
2009-06-05 16:00:00	NVDA	Stock	0.2708	0.2715	0.27	0.27	6043480.0
2009-06-05 17:00:00	NVDA	Stock	0.2712	0.2712	0.27	0.27	14000.0
2009-06-05 18:00:00	NVDA	Stock	0.27	0.27	0.27	0.27	80000.0
2009-06-05 08:00:00	AMZN	Stock	4.275	4.326	4.275	4.3125	445200.0
2009-06-05 09:00:00	AMZN	Stock	4.313	4.3975	4.3	4.3225	30696480.0
2009-06-05 10:00:00	AMZN	Stock	4.3195	4.374	4.265	4.3385	31497600.0
2009-06-05 11:00:00	AMZN	Stock	4.338	4.3895	4.336	4.374	18624940.0
2009-06-05 12:00:00	AMZN	Stock	4.374	4.393	4.349	4.379	12015560.0
2009-06-05 13:00:00	AMZN	Stock	4.379	4.3815	4.35	4.363	13785860.0
2009-06-05 14:00:00	AMZN	Stock	4.3625	4.391	4.3385	4.367	23566120.0
2009-06-05 15:00:00	AMZN	Stock	4.3675	4.3945	4.3595	4.3785	26774720.0
2009-06-05 16:00:00	AMZN	Stock	4.3785	4.398	4.3566	4.385	5226660.0
2009-06-05 17:00:00	AMZN	Stock	4.3815	4.3815	4.38	4.38	10000.0
2009-06-05 18:00:00	AMZN	Stock	4.387	4.387	4.387	4.387	4260.0

> showing 50 of 41,351 rows — these rows as CSV

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