PREVIEW / stock_1hour / 2008-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-02.parquet
  size:    859 KB
  rows:    41,185
  symbols: 3,325

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
2008-06-02 05:00:00	AAPL	Stock	6.7143	6.7143	6.7143	6.7143	14000.0
2008-06-02 06:00:00	AAPL	Stock	6.7143	6.7143	6.7143	6.7143	10640.0
2008-06-02 07:00:00	AAPL	Stock	6.7025	6.7186	6.7025	6.7143	253120.0
2008-06-02 08:00:00	AAPL	Stock	6.7143	6.7411	6.6961	6.725	2406264.0
2008-06-02 09:00:00	AAPL	Stock	6.7271	6.7732	6.6982	6.7207	82387312.0
2008-06-02 10:00:00	AAPL	Stock	6.7192	6.7304	6.6614	6.6821	114865044.0
2008-06-02 11:00:00	AAPL	Stock	6.6825	6.6871	6.6482	6.6786	72584596.0
2008-06-02 12:00:00	AAPL	Stock	6.6786	6.6854	6.615	6.6164	75052348.0
2008-06-02 13:00:00	AAPL	Stock	6.6161	6.6221	6.5904	6.6121	83384392.0
2008-06-02 14:00:00	AAPL	Stock	6.6129	6.6379	6.5932	6.6136	86791040.0
2008-06-02 15:00:00	AAPL	Stock	6.6129	6.6479	6.5929	6.6471	134708420.0
2008-06-02 16:00:00	AAPL	Stock	6.6471	6.7411	6.6014	6.6471	18817288.0
2008-06-02 17:00:00	AAPL	Stock	6.6479	6.7411	6.6432	6.6486	1359232.0
2008-06-02 18:00:00	AAPL	Stock	6.6496	6.6543	6.6496	6.6543	286776.0
2008-06-02 19:00:00	AAPL	Stock	6.6518	6.6554	6.6493	6.6525	279440.0
2008-06-02 07:00:00	MSFT	Stock	28.23	28.32	28.2	28.2	1200.0
2008-06-02 08:00:00	MSFT	Stock	28.22	28.32	28.2	28.25	23145.0
2008-06-02 09:00:00	MSFT	Stock	28.27	28.36	28.08	28.1	4023190.0
2008-06-02 10:00:00	MSFT	Stock	28.1	28.11	27.95	27.95	12165940.0
2008-06-02 11:00:00	MSFT	Stock	27.95	27.99	27.81	27.89	10989073.0
2008-06-02 12:00:00	MSFT	Stock	27.88	27.9	27.63	27.63	10033456.0
2008-06-02 13:00:00	MSFT	Stock	27.62	27.71	27.55	27.66	11517285.0
2008-06-02 14:00:00	MSFT	Stock	27.67	27.73	27.57	27.65	10669353.0
2008-06-02 15:00:00	MSFT	Stock	27.66	27.81	27.6	27.802	13730204.0
2008-06-02 16:00:00	MSFT	Stock	27.8	28.32	27.689	27.81	1796840.0
2008-06-02 17:00:00	MSFT	Stock	27.81	28.335	27.61	27.81	79495.0
2008-06-02 18:00:00	MSFT	Stock	27.81	27.82	27.8	27.81	4309.0
2008-06-02 19:00:00	MSFT	Stock	27.81	27.85	27.81	27.85	5166.0
2008-06-02 08:00:00	NVDA	Stock	0.62	0.6238	0.6113	0.615	459560.0
2008-06-02 09:00:00	NVDA	Stock	0.6138	0.6248	0.6122	0.6175	84982680.0
2008-06-02 10:00:00	NVDA	Stock	0.6175	0.6238	0.6122	0.6153	134877720.0
2008-06-02 11:00:00	NVDA	Stock	0.6153	0.6155	0.612	0.6135	82908760.0
2008-06-02 12:00:00	NVDA	Stock	0.6133	0.6175	0.6113	0.6122	88038840.0
2008-06-02 13:00:00	NVDA	Stock	0.6122	0.6155	0.6108	0.6155	61210200.0
2008-06-02 14:00:00	NVDA	Stock	0.6153	0.6178	0.6148	0.615	90251800.0
2008-06-02 15:00:00	NVDA	Stock	0.615	0.6215	0.6125	0.6205	162114760.0
2008-06-02 16:00:00	NVDA	Stock	0.62	0.6208	0.613	0.62	23409000.0
2008-06-02 17:00:00	NVDA	Stock	0.62	0.621	0.62	0.62	266920.0
2008-06-02 18:00:00	NVDA	Stock	0.62	0.62	0.616	0.62	156000.0
2008-06-02 08:00:00	AMZN	Stock	4.0745	4.0745	4.0745	4.0745	2000.0
2008-06-02 09:00:00	AMZN	Stock	4.0675	4.081	4.0465	4.0495	14807200.0
2008-06-02 10:00:00	AMZN	Stock	4.05	4.071	4.0255	4.0355	24899140.0
2008-06-02 11:00:00	AMZN	Stock	4.0355	4.051	4.0125	4.0205	17445580.0
2008-06-02 12:00:00	AMZN	Stock	4.021	4.022	4.008	4.0105	13335580.0
2008-06-02 13:00:00	AMZN	Stock	4.011	4.016	4.0025	4.015	11520140.0
2008-06-02 14:00:00	AMZN	Stock	4.0135	4.0245	4.003	4.012	11915920.0
2008-06-02 15:00:00	AMZN	Stock	4.0115	4.04	4.0075	4.0155	25301700.0
2008-06-02 16:00:00	AMZN	Stock	4.016	4.0288	4.0055	4.0115	3605820.0
2008-06-02 17:00:00	AMZN	Stock	4.0115	4.0115	4.0115	4.0115	25240.0
2008-06-02 08:00:00	TLT	Stock	90.72	92.88	85.0	90.15	162700.0

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

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