PREVIEW / stock_1hour / 2007-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-19.parquet
  size:    692 KB
  rows:    33,043
  symbols: 2,565

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-03-19 04:00:00	AAPL	Stock	3.2125	3.2125	3.2125	3.2125	2800.0
2007-03-19 07:00:00	AAPL	Stock	3.2175	3.2493	3.2143	3.2454	1279600.0
2007-03-19 08:00:00	AAPL	Stock	3.2464	3.25	3.2261	3.2286	2945628.0
2007-03-19 09:00:00	AAPL	Stock	3.2286	3.2304	3.1996	3.2211	96541284.0
2007-03-19 10:00:00	AAPL	Stock	3.2207	3.2371	3.2104	3.2339	106965068.0
2007-03-19 11:00:00	AAPL	Stock	3.2339	3.2696	3.2329	3.2654	172813536.0
2007-03-19 12:00:00	AAPL	Stock	3.2657	3.2696	3.25	3.2543	75443760.0
2007-03-19 13:00:00	AAPL	Stock	3.2543	3.268	3.2489	3.2617	82096000.0
2007-03-19 14:00:00	AAPL	Stock	3.2614	3.2632	3.2525	3.2564	58207352.0
2007-03-19 15:00:00	AAPL	Stock	3.2564	3.2579	3.2357	3.255	106446508.0
2007-03-19 16:00:00	AAPL	Stock	3.255	3.2589	3.2536	3.2582	4211088.0
2007-03-19 17:00:00	AAPL	Stock	3.2579	3.2589	3.2564	3.2579	210952.0
2007-03-19 18:00:00	AAPL	Stock	3.2568	3.2589	3.2568	3.2575	44800.0
2007-03-19 19:00:00	AAPL	Stock	3.2579	3.2589	3.2564	3.2589	200676.0
2007-03-19 07:00:00	MSFT	Stock	27.44	27.44	27.33	27.33	300.0
2007-03-19 08:00:00	MSFT	Stock	27.4	27.43	27.32	27.4	27824.0
2007-03-19 09:00:00	MSFT	Stock	27.4	27.55	27.32	27.53	7111330.0
2007-03-19 10:00:00	MSFT	Stock	27.54	27.72	27.44	27.68	6970423.0
2007-03-19 11:00:00	MSFT	Stock	27.67	27.8	27.63	27.78	5003718.0
2007-03-19 12:00:00	MSFT	Stock	27.79	27.79	27.68	27.74	3884175.0
2007-03-19 13:00:00	MSFT	Stock	27.74	27.82	27.67	27.82	3778477.0
2007-03-19 14:00:00	MSFT	Stock	27.82	27.83	27.76	27.78	3791895.0
2007-03-19 15:00:00	MSFT	Stock	27.78	27.83	27.6	27.83	13169018.0
2007-03-19 16:00:00	MSFT	Stock	27.82	27.85	27.709	27.84	1181143.0
2007-03-19 17:00:00	MSFT	Stock	27.83	27.85	27.83	27.84	939400.0
2007-03-19 18:00:00	MSFT	Stock	27.84	27.84	27.83	27.84	3750.0
2007-03-19 08:00:00	NVDA	Stock	0.4745	0.4745	0.4745	0.4745	240000.0
2007-03-19 09:00:00	NVDA	Stock	0.4767	0.48	0.475	0.4767	54200160.0
2007-03-19 10:00:00	NVDA	Stock	0.4767	0.478	0.474	0.4772	82076400.0
2007-03-19 11:00:00	NVDA	Stock	0.477	0.4825	0.477	0.481	84435900.0
2007-03-19 12:00:00	NVDA	Stock	0.481	0.4812	0.4747	0.4757	58504920.0
2007-03-19 13:00:00	NVDA	Stock	0.4755	0.4772	0.4745	0.4755	43184640.0
2007-03-19 14:00:00	NVDA	Stock	0.4755	0.4768	0.4742	0.4747	51754500.0
2007-03-19 15:00:00	NVDA	Stock	0.4747	0.4757	0.4733	0.4748	73297500.0
2007-03-19 16:00:00	NVDA	Stock	0.4745	0.4749	0.4735	0.4742	1218720.0
2007-03-19 17:00:00	NVDA	Stock	0.4752	0.4752	0.4745	0.4745	240000.0
2007-03-19 18:00:00	NVDA	Stock	0.4757	0.4758	0.4745	0.4745	267120.0
2007-03-19 19:00:00	NVDA	Stock	0.4743	0.4743	0.4743	0.4743	72000.0
2007-03-19 08:00:00	AMZN	Stock	1.9075	1.9175	1.9005	1.9005	42000.0
2007-03-19 09:00:00	AMZN	Stock	1.91	1.915	1.9	1.911	9499780.0
2007-03-19 10:00:00	AMZN	Stock	1.9115	1.922	1.902	1.9185	10509620.0
2007-03-19 11:00:00	AMZN	Stock	1.9185	1.927	1.9155	1.9255	9067580.0
2007-03-19 12:00:00	AMZN	Stock	1.9255	1.927	1.9205	1.921	6006640.0
2007-03-19 13:00:00	AMZN	Stock	1.921	1.925	1.9165	1.92	6631600.0
2007-03-19 14:00:00	AMZN	Stock	1.9195	1.924	1.918	1.92	6247940.0
2007-03-19 15:00:00	AMZN	Stock	1.9195	1.9255	1.912	1.922	23371140.0
2007-03-19 16:00:00	AMZN	Stock	1.9235	1.927	1.922	1.925	151960.0
2007-03-19 17:00:00	AMZN	Stock	1.9235	1.9235	1.9235	1.9235	40000.0
2007-03-19 09:00:00	CL	Stock	32.56	32.725	32.55	32.64	284000.0
2007-03-19 10:00:00	CL	Stock	32.65	32.715	32.53	32.685	284200.0

> showing 50 of 33,043 rows — these rows as CSV

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