PREVIEW / stock_1hour / 2007-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-02.parquet
  size:    813 KB
  rows:    40,090
  symbols: 3,163

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
2007-11-02 05:00:00	AAPL	Stock	6.6918	6.6918	6.6918	6.6918	35000.0
2007-11-02 06:00:00	AAPL	Stock	6.6982	6.6982	6.6982	6.6982	7000.0
2007-11-02 07:00:00	AAPL	Stock	6.6911	6.6911	6.6754	6.6911	298200.0
2007-11-02 08:00:00	AAPL	Stock	6.6943	6.7857	6.6932	6.7536	8816864.0
2007-11-02 09:00:00	AAPL	Stock	6.755	6.7657	6.6089	6.6511	155921444.0
2007-11-02 10:00:00	AAPL	Stock	6.6496	6.6693	6.6107	6.6404	171107048.0
2007-11-02 11:00:00	AAPL	Stock	6.64	6.6493	6.5532	6.6232	188155660.0
2007-11-02 12:00:00	AAPL	Stock	6.6232	6.7139	6.6064	6.7093	131839876.0
2007-11-02 13:00:00	AAPL	Stock	6.7089	6.7321	6.6807	6.6932	103871180.0
2007-11-02 14:00:00	AAPL	Stock	6.6939	6.7029	6.6607	6.6668	102747316.0
2007-11-02 15:00:00	AAPL	Stock	6.6668	6.7127	6.6611	6.7089	126330120.0
2007-11-02 16:00:00	AAPL	Stock	6.7086	6.7139	6.5739	6.7096	11836244.0
2007-11-02 17:00:00	AAPL	Stock	6.7107	6.7132	6.6348	6.7079	621264.0
2007-11-02 18:00:00	AAPL	Stock	6.7079	6.7132	6.7071	6.7089	330148.0
2007-11-02 19:00:00	AAPL	Stock	6.7079	6.7125	6.7039	6.7071	201880.0
2007-11-02 07:00:00	MSFT	Stock	37.1	37.1	36.79	36.99	17830.0
2007-11-02 08:00:00	MSFT	Stock	36.99	37.5	36.94	37.4	197624.0
2007-11-02 09:00:00	MSFT	Stock	37.4	37.4	36.74	36.81	12109229.0
2007-11-02 10:00:00	MSFT	Stock	36.82	37.05	36.42	36.84	14962254.0
2007-11-02 11:00:00	MSFT	Stock	36.84	36.98	36.66	36.808	9178976.0
2007-11-02 12:00:00	MSFT	Stock	36.81	37.0	36.75	36.99	10641604.0
2007-11-02 13:00:00	MSFT	Stock	36.99	37.5	36.94	37.02	12219502.0
2007-11-02 14:00:00	MSFT	Stock	37.03	37.1	36.95	37.02	15161650.0
2007-11-02 15:00:00	MSFT	Stock	37.03	37.24	36.94	37.03	18842574.0
2007-11-02 16:00:00	MSFT	Stock	37.03	37.14	36.74	37.09	3048056.0
2007-11-02 17:00:00	MSFT	Stock	37.07	37.15	36.932	37.05	15799.0
2007-11-02 18:00:00	MSFT	Stock	37.05	37.1	37.04	37.05	3760.0
2007-11-02 19:00:00	MSFT	Stock	37.04	37.07	37.04	37.04	1950.0
2007-11-02 08:00:00	NVDA	Stock	0.8975	0.8975	0.895	0.895	24000.0
2007-11-02 09:00:00	NVDA	Stock	0.8938	0.9043	0.8842	0.8935	51261720.0
2007-11-02 10:00:00	NVDA	Stock	0.8935	0.91	0.886	0.9075	95138840.0
2007-11-02 11:00:00	NVDA	Stock	0.9075	0.916	0.8973	0.9073	58798800.0
2007-11-02 12:00:00	NVDA	Stock	0.9078	0.919	0.905	0.916	56805000.0
2007-11-02 13:00:00	NVDA	Stock	0.9165	0.92	0.9115	0.9138	44627920.0
2007-11-02 14:00:00	NVDA	Stock	0.9135	0.9208	0.9123	0.9142	58734080.0
2007-11-02 15:00:00	NVDA	Stock	0.9142	0.925	0.9135	0.9185	112598200.0
2007-11-02 16:00:00	NVDA	Stock	0.9185	0.9213	0.8908	0.9185	8695800.0
2007-11-02 17:00:00	NVDA	Stock	0.915	0.9185	0.915	0.9165	688000.0
2007-11-02 18:00:00	NVDA	Stock	0.9175	0.9175	0.9155	0.9168	92520.0
2007-11-02 19:00:00	NVDA	Stock	0.916	0.9162	0.9155	0.9155	31480.0
2007-11-02 08:00:00	AMZN	Stock	4.3825	4.4175	4.3635	4.401	98000.0
2007-11-02 09:00:00	AMZN	Stock	4.4025	4.413	4.242	4.2465	44953300.0
2007-11-02 10:00:00	AMZN	Stock	4.245	4.292	4.175	4.2915	65182660.0
2007-11-02 11:00:00	AMZN	Stock	4.291	4.309	4.2315	4.2715	28256840.0
2007-11-02 12:00:00	AMZN	Stock	4.2735	4.347	4.266	4.3415	13915380.0
2007-11-02 13:00:00	AMZN	Stock	4.34	4.348	4.2805	4.2825	12615240.0
2007-11-02 14:00:00	AMZN	Stock	4.2825	4.312	4.2575	4.266	13271980.0
2007-11-02 15:00:00	AMZN	Stock	4.266	4.31	4.2645	4.2995	22704260.0
2007-11-02 16:00:00	AMZN	Stock	4.299	4.3825	4.2762	4.295	3586300.0
2007-11-02 17:00:00	AMZN	Stock	4.294	4.2945	4.2825	4.2825	17900.0

> showing 50 of 40,090 rows — these rows as CSV

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