PREVIEW / stock_1hour / 2009-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-15.parquet
  size:    858 KB
  rows:    41,543
  symbols: 3,364

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-07-15 06:00:00	AAPL	Stock	5.1607	5.1607	5.1607	5.1607	2800.0
2009-07-15 07:00:00	AAPL	Stock	5.1686	5.1686	5.1361	5.1368	244860.0
2009-07-15 08:00:00	AAPL	Stock	5.1496	5.1689	5.1429	5.1679	1371552.0
2009-07-15 09:00:00	AAPL	Stock	5.1661	5.1982	5.1543	5.175	92618624.0
2009-07-15 10:00:00	AAPL	Stock	5.175	5.1914	5.1704	5.1843	63274456.0
2009-07-15 11:00:00	AAPL	Stock	5.1839	5.2214	5.1829	5.2182	65179632.0
2009-07-15 12:00:00	AAPL	Stock	5.2182	5.2396	5.2129	5.2306	43144696.0
2009-07-15 13:00:00	AAPL	Stock	5.2311	5.2454	5.2211	5.235	42424340.0
2009-07-15 14:00:00	AAPL	Stock	5.235	5.2482	5.2225	5.2443	57766912.0
2009-07-15 15:00:00	AAPL	Stock	5.2446	5.25	5.2264	5.2436	96206040.0
2009-07-15 16:00:00	AAPL	Stock	5.2454	5.25	5.2129	5.2321	16592884.0
2009-07-15 17:00:00	AAPL	Stock	5.2321	5.2457	5.2286	5.2429	295988.0
2009-07-15 18:00:00	AAPL	Stock	5.2429	5.2457	5.2321	5.2357	1564136.0
2009-07-15 19:00:00	AAPL	Stock	5.2343	5.2446	5.2307	5.2446	292236.0
2009-07-15 06:00:00	MSFT	Stock	23.7	23.7	23.7	23.7	700.0
2009-07-15 07:00:00	MSFT	Stock	23.75	23.75	23.65	23.65	16900.0
2009-07-15 08:00:00	MSFT	Stock	23.69	23.85	23.69	23.74	87118.0
2009-07-15 09:00:00	MSFT	Stock	23.73	23.81	23.56	23.77	9412896.0
2009-07-15 10:00:00	MSFT	Stock	23.773	23.86	23.73	23.77	8017556.0
2009-07-15 11:00:00	MSFT	Stock	23.77	23.97	23.76	23.823	7286786.0
2009-07-15 12:00:00	MSFT	Stock	23.83	23.86	23.77	23.8	3819680.0
2009-07-15 13:00:00	MSFT	Stock	23.81	23.86	23.77	23.829	4624490.0
2009-07-15 14:00:00	MSFT	Stock	23.83	23.99	23.8	23.98	8753000.0
2009-07-15 15:00:00	MSFT	Stock	23.97	24.12	23.93	24.12	18395753.0
2009-07-15 16:00:00	MSFT	Stock	24.12	24.29	23.877	24.0	4830547.0
2009-07-15 17:00:00	MSFT	Stock	24.02	24.05	24.02	24.03	9072.0
2009-07-15 18:00:00	MSFT	Stock	24.12	24.12	24.0	24.0	45687.0
2009-07-15 19:00:00	MSFT	Stock	24.02	24.05	24.0	24.01	2073.0
2009-07-15 08:00:00	NVDA	Stock	0.275	0.2788	0.275	0.2785	582600.0
2009-07-15 09:00:00	NVDA	Stock	0.2783	0.2842	0.275	0.2775	205363480.0
2009-07-15 10:00:00	NVDA	Stock	0.2772	0.282	0.2768	0.279	226783280.0
2009-07-15 11:00:00	NVDA	Stock	0.2792	0.28	0.2783	0.2792	73594520.0
2009-07-15 12:00:00	NVDA	Stock	0.2792	0.2792	0.277	0.2772	67214000.0
2009-07-15 13:00:00	NVDA	Stock	0.2775	0.2783	0.2763	0.2783	111749080.0
2009-07-15 14:00:00	NVDA	Stock	0.2783	0.2785	0.2755	0.278	106429840.0
2009-07-15 15:00:00	NVDA	Stock	0.2778	0.2797	0.2763	0.2788	200614960.0
2009-07-15 16:00:00	NVDA	Stock	0.2788	0.2795	0.2772	0.2788	23246720.0
2009-07-15 17:00:00	NVDA	Stock	0.2778	0.2778	0.2778	0.2778	7600.0
2009-07-15 18:00:00	NVDA	Stock	0.275	0.2792	0.275	0.2792	95120.0
2009-07-15 19:00:00	NVDA	Stock	0.2788	0.2788	0.2788	0.2788	8000.0
2009-07-15 08:00:00	AMZN	Stock	4.134	4.1675	4.134	4.155	215300.0
2009-07-15 09:00:00	AMZN	Stock	4.1545	4.195	4.139	4.163	17266940.0
2009-07-15 10:00:00	AMZN	Stock	4.16	4.1875	4.1515	4.1725	17001200.0
2009-07-15 11:00:00	AMZN	Stock	4.172	4.196	4.1708	4.1925	9592920.0
2009-07-15 12:00:00	AMZN	Stock	4.1925	4.209	4.188	4.1945	9427960.0
2009-07-15 13:00:00	AMZN	Stock	4.195	4.214	4.1875	4.2075	12561740.0
2009-07-15 14:00:00	AMZN	Stock	4.209	4.22	4.191	4.216	16954520.0
2009-07-15 15:00:00	AMZN	Stock	4.2165	4.232	4.2	4.2275	35380760.0
2009-07-15 16:00:00	AMZN	Stock	4.228	4.232	4.1955	4.2275	964980.0
2009-07-15 17:00:00	AMZN	Stock	4.224	4.224	4.217	4.217	33860.0

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

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