PREVIEW / stock_30min / 2007-02-14

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-02-14.parquet
  size:    1.0 MB
  rows:    54,714
  symbols: 2,538

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-02-14 06:30:00	AAPL	Stock	3.0354	3.04	3.0354	3.0354	32004.0
2007-02-14 07:30:00	AAPL	Stock	3.0271	3.0289	3.0107	3.0107	192220.0
2007-02-14 08:00:00	AAPL	Stock	3.0179	3.0286	3.0118	3.0218	891744.0
2007-02-14 08:30:00	AAPL	Stock	3.0204	3.0214	3.0143	3.0143	580580.0
2007-02-14 09:00:00	AAPL	Stock	3.0175	3.0289	3.0164	3.02	594972.0
2007-02-14 09:30:00	AAPL	Stock	3.0225	3.0364	3.0204	3.0307	61145952.0
2007-02-14 10:00:00	AAPL	Stock	3.0304	3.0525	3.0289	3.0386	88700248.0
2007-02-14 10:30:00	AAPL	Stock	3.0389	3.0485	3.0379	3.0407	32106396.0
2007-02-14 11:00:00	AAPL	Stock	3.0407	3.0586	3.0386	3.0525	52494092.0
2007-02-14 11:30:00	AAPL	Stock	3.0525	3.055	3.0339	3.041	39056276.0
2007-02-14 12:00:00	AAPL	Stock	3.0407	3.0464	3.0382	3.0392	19550132.0
2007-02-14 12:30:00	AAPL	Stock	3.039	3.0443	3.0379	3.0404	19947172.0
2007-02-14 13:00:00	AAPL	Stock	3.04	3.0514	3.04	3.0429	25620028.0
2007-02-14 13:30:00	AAPL	Stock	3.0429	3.0561	3.0421	3.0518	24447052.0
2007-02-14 14:00:00	AAPL	Stock	3.0518	3.0525	3.0471	3.0507	22489628.0
2007-02-14 14:30:00	AAPL	Stock	3.0507	3.0541	3.0425	3.0489	28549080.0
2007-02-14 15:00:00	AAPL	Stock	3.0489	3.0514	3.0446	3.05	25786264.0
2007-02-14 15:30:00	AAPL	Stock	3.0504	3.0504	3.04	3.0457	48388816.0
2007-02-14 16:00:00	AAPL	Stock	3.0457	3.0475	3.0446	3.0464	670488.0
2007-02-14 16:30:00	AAPL	Stock	3.0464	3.0475	3.0457	3.0475	170548.0
2007-02-14 17:00:00	AAPL	Stock	3.0475	3.0514	3.0475	3.0514	614628.0
2007-02-14 17:30:00	AAPL	Stock	3.0514	3.0514	3.0464	3.0464	11592.0
2007-02-14 18:00:00	AAPL	Stock	3.05	3.05	3.05	3.05	5600.0
2007-02-14 18:30:00	AAPL	Stock	3.0507	3.0514	3.0507	3.0514	56000.0
2007-02-14 19:00:00	AAPL	Stock	3.0496	3.0514	3.0496	3.0514	32200.0
2007-02-14 19:30:00	AAPL	Stock	3.0511	3.0514	3.0468	3.0468	142800.0
2007-02-14 06:30:00	MSFT	Stock	29.08	29.09	29.07	29.07	2600.0
2007-02-14 07:00:00	MSFT	Stock	29.07	29.07	29.07	29.07	200.0
2007-02-14 07:30:00	MSFT	Stock	29.07	29.09	29.0	29.09	3972.0
2007-02-14 08:00:00	MSFT	Stock	29.03	29.04	29.03	29.04	3100.0
2007-02-14 08:30:00	MSFT	Stock	29.05	29.09	29.04	29.08	11357.0
2007-02-14 09:00:00	MSFT	Stock	29.08	29.19	29.08	29.19	187172.0
2007-02-14 09:30:00	MSFT	Stock	29.17	29.23	29.15	29.21	6026503.0
2007-02-14 10:00:00	MSFT	Stock	29.21	29.49	29.21	29.46	9964465.0
2007-02-14 10:30:00	MSFT	Stock	29.46	29.48	29.38	29.47	3261030.0
2007-02-14 11:00:00	MSFT	Stock	29.48	29.69	29.46	29.6	6091436.0
2007-02-14 11:30:00	MSFT	Stock	29.6	29.65	29.48	29.51	4346227.0
2007-02-14 12:00:00	MSFT	Stock	29.51	29.54	29.48	29.48	1504617.0
2007-02-14 12:30:00	MSFT	Stock	29.48	29.54	29.41	29.54	2069275.0
2007-02-14 13:00:00	MSFT	Stock	29.54	29.56	29.44	29.46	2164396.0
2007-02-14 13:30:00	MSFT	Stock	29.46	29.52	29.44	29.48	2901062.0
2007-02-14 14:00:00	MSFT	Stock	29.48	29.57	29.46	29.52	2022454.0
2007-02-14 14:30:00	MSFT	Stock	29.52	29.59	29.45	29.49	2770196.0
2007-02-14 15:00:00	MSFT	Stock	29.49	29.53	29.45	29.46	2429661.0
2007-02-14 15:30:00	MSFT	Stock	29.47	29.48	29.4	29.44	5589379.0
2007-02-14 16:00:00	MSFT	Stock	29.43	29.46	29.4	29.43	99562.0
2007-02-14 16:30:00	MSFT	Stock	29.43	29.46	29.41	29.41	2700.0
2007-02-14 17:00:00	MSFT	Stock	29.44	29.44	29.43	29.43	5350.0
2007-02-14 17:30:00	MSFT	Stock	29.44	29.44	29.438	29.438	1117.0
2007-02-14 18:00:00	MSFT	Stock	29.47	29.47	29.47	29.47	165.0

> showing 50 of 54,714 rows — these rows as CSV

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