PREVIEW / stock_30min / 2009-03-25

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-03-25.parquet
  size:    1.2 MB
  rows:    68,945
  symbols: 3,324

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
2009-03-25 04:30:00	AAPL	Stock	3.8121	3.8121	3.8121	3.8121	14000.0
2009-03-25 05:00:00	AAPL	Stock	3.8139	3.8139	3.8129	3.8129	11200.0
2009-03-25 05:30:00	AAPL	Stock	3.8207	3.8207	3.8207	3.8207	2800.0
2009-03-25 06:30:00	AAPL	Stock	3.8121	3.8121	3.8121	3.8121	11200.0
2009-03-25 07:00:00	AAPL	Stock	3.8121	3.8121	3.8036	3.8082	25200.0
2009-03-25 07:30:00	AAPL	Stock	3.8139	3.8146	3.8125	3.8125	16800.0
2009-03-25 08:00:00	AAPL	Stock	3.8125	3.8207	3.8032	3.8032	764820.0
2009-03-25 08:30:00	AAPL	Stock	3.8207	3.8364	3.8143	3.8354	617680.0
2009-03-25 09:00:00	AAPL	Stock	3.8357	3.8393	3.8304	3.8368	1643376.0
2009-03-25 09:30:00	AAPL	Stock	3.84	3.8629	3.8182	3.8454	67692576.0
2009-03-25 10:00:00	AAPL	Stock	3.8471	3.87	3.8357	3.8361	52478860.0
2009-03-25 10:30:00	AAPL	Stock	3.8364	3.8689	3.8354	3.8396	35665000.0
2009-03-25 11:00:00	AAPL	Stock	3.8404	3.8536	3.8171	3.8354	37184056.0
2009-03-25 11:30:00	AAPL	Stock	3.8354	3.8561	3.8239	3.8489	36148728.0
2009-03-25 12:00:00	AAPL	Stock	3.8489	3.8679	3.8218	3.8357	37183356.0
2009-03-25 12:30:00	AAPL	Stock	3.8354	3.8368	3.8011	3.8154	35053592.0
2009-03-25 13:00:00	AAPL	Stock	3.8153	3.8243	3.7607	3.7721	42359492.0
2009-03-25 13:30:00	AAPL	Stock	3.7721	3.7957	3.7607	3.7718	34124272.0
2009-03-25 14:00:00	AAPL	Stock	3.7718	3.7739	3.7368	3.7485	48530160.0
2009-03-25 14:30:00	AAPL	Stock	3.7479	3.7589	3.7218	3.7239	49374612.0
2009-03-25 15:00:00	AAPL	Stock	3.7243	3.7625	3.7093	3.7589	57220100.0
2009-03-25 15:30:00	AAPL	Stock	3.7593	3.8243	3.75	3.8032	73439436.0
2009-03-25 16:00:00	AAPL	Stock	3.8032	3.8292	3.7595	3.8015	18914000.0
2009-03-25 16:30:00	AAPL	Stock	3.8011	3.8032	3.795	3.7996	892388.0
2009-03-25 17:00:00	AAPL	Stock	3.8	3.8125	3.8	3.8121	183260.0
2009-03-25 17:30:00	AAPL	Stock	3.8125	3.8125	3.8082	3.8114	212968.0
2009-03-25 18:00:00	AAPL	Stock	3.8096	3.8096	3.8032	3.8089	203672.0
2009-03-25 18:30:00	AAPL	Stock	3.8089	3.8089	3.8089	3.8089	16800.0
2009-03-25 19:00:00	AAPL	Stock	3.8107	3.8121	3.8089	3.8121	11200.0
2009-03-25 19:30:00	AAPL	Stock	3.8118	3.8118	3.8118	3.8118	5376.0
2009-03-25 07:00:00	MSFT	Stock	18.15	18.15	18.1	18.15	3600.0
2009-03-25 07:30:00	MSFT	Stock	18.01	18.01	18.01	18.01	100.0
2009-03-25 08:00:00	MSFT	Stock	18.05	18.05	17.93	18.0	171898.0
2009-03-25 08:30:00	MSFT	Stock	18.05	18.05	18.0	18.04	12433.0
2009-03-25 09:00:00	MSFT	Stock	18.05	18.06	17.93	17.98	106740.0
2009-03-25 09:30:00	MSFT	Stock	17.98	18.17	17.85	18.15	8118456.0
2009-03-25 10:00:00	MSFT	Stock	18.15	18.26	18.11	18.16	4827908.0
2009-03-25 10:30:00	MSFT	Stock	18.151	18.31	18.08	18.21	3886262.0
2009-03-25 11:00:00	MSFT	Stock	18.21	18.27	18.09	18.11	2787315.0
2009-03-25 11:30:00	MSFT	Stock	18.12	18.17	18.04	18.11	3460505.0
2009-03-25 12:00:00	MSFT	Stock	18.1	18.21	18.07	18.16	3759451.0
2009-03-25 12:30:00	MSFT	Stock	18.15	18.28	18.11	18.265	3942023.0
2009-03-25 13:00:00	MSFT	Stock	18.26	18.3	17.98	18.054	3582168.0
2009-03-25 13:30:00	MSFT	Stock	18.06	18.07	17.87	17.87	3011598.0
2009-03-25 14:00:00	MSFT	Stock	17.87	17.89	17.69	17.7	3394632.0
2009-03-25 14:30:00	MSFT	Stock	17.71	17.72	17.53	17.58	4118120.0
2009-03-25 15:00:00	MSFT	Stock	17.58	17.77	17.52	17.74	5704915.0
2009-03-25 15:30:00	MSFT	Stock	17.74	17.99	17.67	17.86	9562796.0
2009-03-25 16:00:00	MSFT	Stock	17.87	18.17	17.726	17.956	7651964.0
2009-03-25 16:30:00	MSFT	Stock	17.88	17.9	17.85	17.9	322678.0

> showing 50 of 68,945 rows — these rows as CSV

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