PREVIEW / stock_30min / 2007-09-17

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-17.parquet
  size:    1.1 MB
  rows:    64,158
  symbols: 3,102

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-09-17 09:30:00	AAPL	Stock	4.9639	5.0211	4.9586	4.9968	144823924.0
2007-09-17 10:00:00	AAPL	Stock	4.9968	5.0089	4.9661	4.9714	92821092.0
2007-09-17 10:30:00	AAPL	Stock	4.9718	4.9746	4.9459	4.9596	82140912.0
2007-09-17 11:00:00	AAPL	Stock	4.9594	4.9711	4.9375	4.9429	44497936.0
2007-09-17 11:30:00	AAPL	Stock	4.9425	4.9457	4.9143	4.9314	52051356.0
2007-09-17 12:00:00	AAPL	Stock	4.9314	4.9375	4.9193	4.9296	34846896.0
2007-09-17 12:30:00	AAPL	Stock	4.9289	4.9461	4.9254	4.9407	31185028.0
2007-09-17 13:00:00	AAPL	Stock	4.9407	4.9546	4.9375	4.9514	30700488.0
2007-09-17 13:30:00	AAPL	Stock	4.9511	4.9679	4.9393	4.9543	42897568.0
2007-09-17 14:00:00	AAPL	Stock	4.955	4.975	4.9525	4.9743	31039624.0
2007-09-17 14:30:00	AAPL	Stock	4.9749	4.9804	4.9625	4.9629	35210224.0
2007-09-17 15:00:00	AAPL	Stock	4.9629	4.975	4.955	4.9589	35240408.0
2007-09-17 15:30:00	AAPL	Stock	4.9589	4.9643	4.9393	4.9432	50099476.0
2007-09-17 16:00:00	AAPL	Stock	4.9436	4.9436	4.9432	4.9432	7072436.0
2007-09-17 09:30:00	MSFT	Stock	28.79	28.85	28.7	28.78	4456893.0
2007-09-17 10:00:00	MSFT	Stock	28.78	28.88	28.75	28.8	2218587.0
2007-09-17 10:30:00	MSFT	Stock	28.801	28.81	28.65	28.66	3803857.0
2007-09-17 11:00:00	MSFT	Stock	28.651	28.72	28.65	28.7	2744561.0
2007-09-17 11:30:00	MSFT	Stock	28.69	28.71	28.66	28.7	2113048.0
2007-09-17 12:00:00	MSFT	Stock	28.7	28.7	28.65	28.7	1695731.0
2007-09-17 12:30:00	MSFT	Stock	28.69	28.71	28.66	28.69	1188676.0
2007-09-17 13:00:00	MSFT	Stock	28.7	28.71	28.66	28.67	896011.0
2007-09-17 13:30:00	MSFT	Stock	28.66	28.69	28.66	28.66	1567238.0
2007-09-17 14:00:00	MSFT	Stock	28.66	28.67	28.62	28.63	2878748.0
2007-09-17 14:30:00	MSFT	Stock	28.63	28.69	28.63	28.66	2039950.0
2007-09-17 15:00:00	MSFT	Stock	28.66	28.76	28.64	28.67	3059347.0
2007-09-17 15:30:00	MSFT	Stock	28.66	28.73	28.66	28.72	3806270.0
2007-09-17 16:00:00	MSFT	Stock	28.73	28.73	28.72	28.725	1377951.0
2007-09-17 08:00:00	NVDA	Stock	0.8	0.8123	0.8	0.8075	99600.0
2007-09-17 08:30:00	NVDA	Stock	0.8075	0.8142	0.8062	0.81	64560.0
2007-09-17 09:00:00	NVDA	Stock	0.8125	0.8125	0.805	0.8075	376200.0
2007-09-17 09:30:00	NVDA	Stock	0.8075	0.8075	0.7958	0.8065	53571200.0
2007-09-17 10:00:00	NVDA	Stock	0.8068	0.808	0.7998	0.8015	26816680.0
2007-09-17 10:30:00	NVDA	Stock	0.8018	0.804	0.7988	0.802	23468560.0
2007-09-17 11:00:00	NVDA	Stock	0.8023	0.806	0.8015	0.8028	18492800.0
2007-09-17 11:30:00	NVDA	Stock	0.8028	0.8052	0.8015	0.8052	25832440.0
2007-09-17 12:00:00	NVDA	Stock	0.8055	0.8118	0.8048	0.809	29120920.0
2007-09-17 12:30:00	NVDA	Stock	0.809	0.8123	0.8082	0.8108	15926200.0
2007-09-17 13:00:00	NVDA	Stock	0.8108	0.816	0.8091	0.812	26730280.0
2007-09-17 13:30:00	NVDA	Stock	0.812	0.8132	0.809	0.8102	13590480.0
2007-09-17 14:00:00	NVDA	Stock	0.8102	0.811	0.8085	0.8105	13784240.0
2007-09-17 14:30:00	NVDA	Stock	0.8105	0.811	0.807	0.8072	17221440.0
2007-09-17 15:00:00	NVDA	Stock	0.8072	0.8095	0.8055	0.8072	17664200.0
2007-09-17 15:30:00	NVDA	Stock	0.8072	0.8072	0.804	0.8045	21564800.0
2007-09-17 16:00:00	NVDA	Stock	0.805	0.811	0.8045	0.805	32188720.0
2007-09-17 16:30:00	NVDA	Stock	0.805	0.805	0.8045	0.8045	124920.0
2007-09-17 17:30:00	NVDA	Stock	0.8045	0.8045	0.8045	0.8045	124000.0
2007-09-17 19:00:00	NVDA	Stock	0.8072	0.8072	0.8072	0.8072	12000.0
2007-09-17 19:30:00	NVDA	Stock	0.8072	0.8072	0.8072	0.8072	12000.0
2007-09-17 06:30:00	AMZN	Stock	4.35	4.35	4.325	4.325	12400.0

> showing 50 of 64,158 rows — these rows as CSV

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