PREVIEW / stock_30min / 2007-09-14

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-14.parquet
  size:    1.1 MB
  rows:    63,147
  symbols: 3,090

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-14 09:30:00	AAPL	Stock	4.8775	4.9268	4.8643	4.9118	90510364.0
2007-09-14 10:00:00	AAPL	Stock	4.9118	4.9321	4.9064	4.9229	65148972.0
2007-09-14 10:30:00	AAPL	Stock	4.9218	4.9636	4.9179	4.9471	75457872.0
2007-09-14 11:00:00	AAPL	Stock	4.9471	4.9546	4.9254	4.9318	42419860.0
2007-09-14 11:30:00	AAPL	Stock	4.9318	4.9543	4.9225	4.9418	32757200.0
2007-09-14 12:00:00	AAPL	Stock	4.9421	4.9536	4.9257	4.9339	23016504.0
2007-09-14 12:30:00	AAPL	Stock	4.935	4.9389	4.92	4.9257	19444656.0
2007-09-14 13:00:00	AAPL	Stock	4.9257	4.9386	4.9196	4.9375	23939468.0
2007-09-14 13:30:00	AAPL	Stock	4.9371	4.9375	4.9239	4.9361	20955312.0
2007-09-14 14:00:00	AAPL	Stock	4.9364	4.9443	4.9308	4.9368	26702620.0
2007-09-14 14:30:00	AAPL	Stock	4.9368	4.9411	4.9254	4.9317	24509716.0
2007-09-14 15:00:00	AAPL	Stock	4.9314	4.9411	4.9261	4.9396	24793776.0
2007-09-14 15:30:00	AAPL	Stock	4.9396	4.9589	4.9343	4.9532	68912620.0
2007-09-14 16:00:00	AAPL	Stock	4.9557	4.9575	4.9525	4.9575	15229788.0
2007-09-14 09:30:00	MSFT	Stock	28.98	28.99	28.88	28.95	2208464.0
2007-09-14 10:00:00	MSFT	Stock	28.953	29.06	28.95	29.01	2430625.0
2007-09-14 10:30:00	MSFT	Stock	29.0	29.04	28.96	28.97	2409354.0
2007-09-14 11:00:00	MSFT	Stock	28.97	29.02	28.92	28.94	1720910.0
2007-09-14 11:30:00	MSFT	Stock	28.94	29.03	28.92	28.97	1629604.0
2007-09-14 12:00:00	MSFT	Stock	28.97	29.02	28.96	29.01	1443035.0
2007-09-14 12:30:00	MSFT	Stock	29.02	29.02	28.95	28.96	1307198.0
2007-09-14 13:00:00	MSFT	Stock	28.96	29.03	28.95	29.003	1306077.0
2007-09-14 13:30:00	MSFT	Stock	29.0	29.0	28.97	28.99	1091348.0
2007-09-14 14:00:00	MSFT	Stock	29.0	29.01	28.97	28.99	1173797.0
2007-09-14 14:30:00	MSFT	Stock	28.99	29.006	28.95	28.971	2233114.0
2007-09-14 15:00:00	MSFT	Stock	28.98	29.0	28.97	28.99	1583785.0
2007-09-14 15:30:00	MSFT	Stock	28.99	29.11	28.97	29.04	5624237.0
2007-09-14 16:00:00	MSFT	Stock	29.04	29.04	29.04	29.04	3076643.0
2007-09-14 07:00:00	NVDA	Stock	0.8273	0.8273	0.8273	0.8273	4000.0
2007-09-14 08:00:00	NVDA	Stock	0.8238	0.8248	0.8188	0.8188	100000.0
2007-09-14 08:30:00	NVDA	Stock	0.82	0.8232	0.8175	0.8175	240920.0
2007-09-14 09:00:00	NVDA	Stock	0.818	0.824	0.8175	0.8225	1584720.0
2007-09-14 09:30:00	NVDA	Stock	0.8215	0.8235	0.8095	0.8168	81319320.0
2007-09-14 10:00:00	NVDA	Stock	0.8168	0.8175	0.8118	0.8138	47119920.0
2007-09-14 10:30:00	NVDA	Stock	0.814	0.815	0.8102	0.8118	49556240.0
2007-09-14 11:00:00	NVDA	Stock	0.8115	0.8123	0.8038	0.8072	40364880.0
2007-09-14 11:30:00	NVDA	Stock	0.807	0.8125	0.8065	0.811	28929920.0
2007-09-14 12:00:00	NVDA	Stock	0.8113	0.814	0.8108	0.8108	22993000.0
2007-09-14 12:30:00	NVDA	Stock	0.811	0.8118	0.8058	0.8078	17026600.0
2007-09-14 13:00:00	NVDA	Stock	0.8078	0.8132	0.8072	0.8128	17195840.0
2007-09-14 13:30:00	NVDA	Stock	0.813	0.813	0.8088	0.8098	21763360.0
2007-09-14 14:00:00	NVDA	Stock	0.8098	0.8102	0.8072	0.8075	21290360.0
2007-09-14 14:30:00	NVDA	Stock	0.8072	0.8075	0.8052	0.8058	24381320.0
2007-09-14 15:00:00	NVDA	Stock	0.8058	0.8062	0.8052	0.806	19877040.0
2007-09-14 15:30:00	NVDA	Stock	0.806	0.8068	0.8052	0.8062	53978080.0
2007-09-14 16:00:00	NVDA	Stock	0.8062	0.8062	0.8025	0.8025	23735280.0
2007-09-14 16:30:00	NVDA	Stock	0.8025	0.8058	0.8025	0.8058	76000.0
2007-09-14 17:00:00	NVDA	Stock	0.8058	0.808	0.8058	0.8058	82800.0
2007-09-14 17:30:00	NVDA	Stock	0.8058	0.8058	0.8058	0.8058	44000.0
2007-09-14 18:00:00	NVDA	Stock	0.803	0.803	0.803	0.803	40000.0

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

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