PREVIEW / stock_30min / 2007-06-04

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-04.parquet
  size:    1.1 MB
  rows:    63,809
  symbols: 3,040

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-06-04 09:30:00	AAPL	Stock	4.2368	4.3089	4.2107	4.2989	162155168.0
2007-06-04 10:00:00	AAPL	Stock	4.2993	4.3279	4.2804	4.3161	126954352.0
2007-06-04 10:30:00	AAPL	Stock	4.3161	4.3282	4.3	4.3079	70954380.0
2007-06-04 11:00:00	AAPL	Stock	4.3079	4.3164	4.2936	4.3011	51784992.0
2007-06-04 11:30:00	AAPL	Stock	4.3011	4.3018	4.2839	4.2964	49540736.0
2007-06-04 12:00:00	AAPL	Stock	4.2964	4.3014	4.2286	4.2889	40627468.0
2007-06-04 12:30:00	AAPL	Stock	4.2889	4.2921	4.2757	4.2771	43541708.0
2007-06-04 13:00:00	AAPL	Stock	4.2771	4.2829	4.2696	4.2761	29468292.0
2007-06-04 13:30:00	AAPL	Stock	4.2764	4.2846	4.2721	4.2764	27496252.0
2007-06-04 14:00:00	AAPL	Stock	4.2757	4.3	4.2729	4.2914	52849972.0
2007-06-04 14:30:00	AAPL	Stock	4.2915	4.2957	4.2818	4.2929	33857320.0
2007-06-04 15:00:00	AAPL	Stock	4.2925	4.3175	4.2918	4.3171	64870736.0
2007-06-04 15:30:00	AAPL	Stock	4.3168	4.3446	4.3157	4.3332	115440360.0
2007-06-04 16:00:00	AAPL	Stock	4.3325	4.3332	4.3321	4.3332	3367756.0
2007-06-04 09:30:00	MSFT	Stock	30.42	30.53	30.4	30.43	4185373.0
2007-06-04 10:00:00	MSFT	Stock	30.43	30.66	30.42	30.65	3857805.0
2007-06-04 10:30:00	MSFT	Stock	30.65	30.651	30.42	30.5	2860002.0
2007-06-04 11:00:00	MSFT	Stock	30.5	30.51	30.45	30.51	2634353.0
2007-06-04 11:30:00	MSFT	Stock	30.51	30.66	30.49	30.648	2226848.0
2007-06-04 12:00:00	MSFT	Stock	30.64	30.65	30.57	30.642	1494868.0
2007-06-04 12:30:00	MSFT	Stock	30.64	30.73	30.63	30.73	1642552.0
2007-06-04 13:00:00	MSFT	Stock	30.72	30.73	30.64	30.73	2290184.0
2007-06-04 13:30:00	MSFT	Stock	30.73	30.76	30.67	30.7	1719374.0
2007-06-04 14:00:00	MSFT	Stock	30.7	30.73	30.69	30.73	1929385.0
2007-06-04 14:30:00	MSFT	Stock	30.73	30.75	30.69	30.74	2775489.0
2007-06-04 15:00:00	MSFT	Stock	30.74	30.76	30.7	30.718	2897571.0
2007-06-04 15:30:00	MSFT	Stock	30.718	30.74	30.668	30.69	4075890.0
2007-06-04 16:00:00	MSFT	Stock	30.69	30.715	30.69	30.715	703906.0
2007-06-04 09:00:00	NVDA	Stock	0.575	0.5813	0.5735	0.5758	296460.0
2007-06-04 09:30:00	NVDA	Stock	0.576	0.5847	0.5737	0.583	38164500.0
2007-06-04 10:00:00	NVDA	Stock	0.5827	0.5878	0.5827	0.5867	37985520.0
2007-06-04 10:30:00	NVDA	Stock	0.587	0.587	0.5798	0.5837	28507980.0
2007-06-04 11:00:00	NVDA	Stock	0.5838	0.5873	0.5833	0.5868	17612220.0
2007-06-04 11:30:00	NVDA	Stock	0.5868	0.5872	0.584	0.5847	14238420.0
2007-06-04 12:00:00	NVDA	Stock	0.5847	0.5852	0.583	0.5832	17411400.0
2007-06-04 12:30:00	NVDA	Stock	0.5832	0.5845	0.5827	0.5842	13459980.0
2007-06-04 13:00:00	NVDA	Stock	0.584	0.5842	0.5805	0.5817	13548660.0
2007-06-04 13:30:00	NVDA	Stock	0.5817	0.5832	0.5817	0.5817	10513560.0
2007-06-04 14:00:00	NVDA	Stock	0.5818	0.5838	0.5813	0.5837	19032900.0
2007-06-04 14:30:00	NVDA	Stock	0.5838	0.5845	0.5818	0.582	20884680.0
2007-06-04 15:00:00	NVDA	Stock	0.5818	0.5855	0.5818	0.5852	20746260.0
2007-06-04 15:30:00	NVDA	Stock	0.5852	0.5865	0.5842	0.5842	38027280.0
2007-06-04 16:00:00	NVDA	Stock	0.5842	0.5845	0.5842	0.5843	4434180.0
2007-06-04 16:30:00	NVDA	Stock	0.5842	0.5842	0.5842	0.5842	120000.0
2007-06-04 06:00:00	AMZN	Stock	3.421	3.421	3.421	3.421	6000.0
2007-06-04 07:00:00	AMZN	Stock	3.4175	3.4175	3.4	3.4	22000.0
2007-06-04 08:00:00	AMZN	Stock	3.4125	3.4125	3.412	3.412	12000.0
2007-06-04 08:30:00	AMZN	Stock	3.412	3.412	3.4	3.4	64460.0
2007-06-04 09:00:00	AMZN	Stock	3.4045	3.415	3.4025	3.412	215000.0
2007-06-04 09:30:00	AMZN	Stock	3.4125	3.434	3.386	3.3905	26141520.0

> showing 50 of 63,809 rows — these rows as CSV

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