PREVIEW / stock_1hour / 2006-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-13.parquet
  size:    617 KB
  rows:    29,484
  symbols: 2,313

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
2006-07-13 07:00:00	AAPL	Stock	1.8821	1.8821	1.8696	1.8696	58800.0
2006-07-13 08:00:00	AAPL	Stock	1.8696	1.8786	1.8671	1.8729	3625776.0
2006-07-13 09:00:00	AAPL	Stock	1.8732	1.8743	1.8421	1.8525	181749596.0
2006-07-13 10:00:00	AAPL	Stock	1.8525	1.8993	1.8361	1.8829	311439604.0
2006-07-13 11:00:00	AAPL	Stock	1.8825	1.9064	1.87	1.9046	175975240.0
2006-07-13 12:00:00	AAPL	Stock	1.9046	1.9329	1.9046	1.9154	186017944.0
2006-07-13 13:00:00	AAPL	Stock	1.9161	1.9232	1.8843	1.8843	126762468.0
2006-07-13 14:00:00	AAPL	Stock	1.8843	1.8982	1.8754	1.8807	100846340.0
2006-07-13 15:00:00	AAPL	Stock	1.8811	1.8854	1.8643	1.8657	148654996.0
2006-07-13 16:00:00	AAPL	Stock	1.8661	1.8804	1.8625	1.8668	2695000.0
2006-07-13 17:00:00	AAPL	Stock	1.8671	1.9071	1.8625	1.8625	2209536.0
2006-07-13 18:00:00	AAPL	Stock	1.8643	1.8655	1.8629	1.8655	91952.0
2006-07-13 07:00:00	MSFT	Stock	22.61	22.61	22.54	22.54	2800.0
2006-07-13 08:00:00	MSFT	Stock	22.57	22.57	22.41	22.41	538395.0
2006-07-13 09:00:00	MSFT	Stock	22.4	22.61	22.31	22.41	15700610.0
2006-07-13 10:00:00	MSFT	Stock	22.408	22.55	22.37	22.485	13746655.0
2006-07-13 11:00:00	MSFT	Stock	22.48	22.55	22.44	22.49	8377657.0
2006-07-13 12:00:00	MSFT	Stock	22.49	22.58	22.49	22.525	4081025.0
2006-07-13 13:00:00	MSFT	Stock	22.523	22.54	22.4	22.41	5853555.0
2006-07-13 14:00:00	MSFT	Stock	22.41	22.48	22.38	22.39	7549807.0
2006-07-13 15:00:00	MSFT	Stock	22.39	22.47	22.25	22.25	14243914.0
2006-07-13 16:00:00	MSFT	Stock	22.25	22.26	22.04	22.23	293606.0
2006-07-13 17:00:00	MSFT	Stock	22.23	22.24	22.21	22.21	10601.0
2006-07-13 18:00:00	MSFT	Stock	22.21	22.26	22.21	22.26	3615.0
2006-07-13 08:00:00	NVDA	Stock	0.3058	0.3058	0.2983	0.2985	530160.0
2006-07-13 09:00:00	NVDA	Stock	0.2992	0.3005	0.2945	0.2983	59208960.0
2006-07-13 10:00:00	NVDA	Stock	0.2982	0.3028	0.2957	0.3015	148062180.0
2006-07-13 11:00:00	NVDA	Stock	0.3017	0.305	0.3003	0.3048	82650420.0
2006-07-13 12:00:00	NVDA	Stock	0.305	0.3067	0.3032	0.3033	40458780.0
2006-07-13 13:00:00	NVDA	Stock	0.3033	0.3035	0.2982	0.2982	44733900.0
2006-07-13 14:00:00	NVDA	Stock	0.2983	0.3002	0.2967	0.2973	55727340.0
2006-07-13 15:00:00	NVDA	Stock	0.2973	0.2983	0.2955	0.2957	98340060.0
2006-07-13 16:00:00	NVDA	Stock	0.2955	0.2958	0.2945	0.2945	371460.0
2006-07-13 17:00:00	NVDA	Stock	0.2958	0.2958	0.2958	0.2958	42000.0
2006-07-13 18:00:00	NVDA	Stock	0.2959	0.2967	0.2959	0.2967	87480.0
2006-07-13 08:00:00	AMZN	Stock	1.7075	1.7075	1.7075	1.7075	59200.0
2006-07-13 09:00:00	AMZN	Stock	1.714	1.7225	1.695	1.6975	13689800.0
2006-07-13 10:00:00	AMZN	Stock	1.6975	1.7315	1.6925	1.7105	22946280.0
2006-07-13 11:00:00	AMZN	Stock	1.7105	1.7185	1.7025	1.712	12444300.0
2006-07-13 12:00:00	AMZN	Stock	1.7125	1.729	1.711	1.7185	8809940.0
2006-07-13 13:00:00	AMZN	Stock	1.7185	1.72	1.703	1.7045	11587960.0
2006-07-13 14:00:00	AMZN	Stock	1.7045	1.7135	1.6945	1.696	13951840.0
2006-07-13 15:00:00	AMZN	Stock	1.6965	1.6974	1.6855	1.687	35382960.0
2006-07-13 16:00:00	AMZN	Stock	1.6865	1.688	1.6685	1.6685	180920.0
2006-07-13 17:00:00	AMZN	Stock	1.675	1.675	1.6565	1.66	452000.0
2006-07-13 18:00:00	AMZN	Stock	1.665	1.6864	1.665	1.6864	10140.0
2006-07-13 09:00:00	CL	Stock	30.47	30.65	30.445	30.632	369400.0
2006-07-13 10:00:00	CL	Stock	30.635	30.74	30.635	30.69	398200.0
2006-07-13 11:00:00	CL	Stock	30.7	30.84	30.68	30.82	324400.0
2006-07-13 12:00:00	CL	Stock	30.825	30.98	30.825	30.965	476600.0

> showing 50 of 29,484 rows — these rows as CSV

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