PREVIEW / stock_30min / 2010-06-18

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-18.parquet
  size:    1.4 MB
  rows:    73,767
  symbols: 3,481

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
2010-06-18 04:30:00	AAPL	Stock	9.68	9.6807	9.6611	9.6682	28112.0
2010-06-18 05:00:00	AAPL	Stock	9.6732	9.6943	9.6682	9.6943	30408.0
2010-06-18 06:30:00	AAPL	Stock	9.7086	9.7086	9.7086	9.7086	8400.0
2010-06-18 07:00:00	AAPL	Stock	9.7146	9.7464	9.7146	9.7414	837676.0
2010-06-18 07:30:00	AAPL	Stock	9.7393	9.7768	9.7379	9.7589	1002680.0
2010-06-18 08:00:00	AAPL	Stock	9.7546	9.7607	9.7175	9.7286	1910608.0
2010-06-18 08:30:00	AAPL	Stock	9.7286	9.7393	9.7179	9.7304	1216292.0
2010-06-18 09:00:00	AAPL	Stock	9.7321	9.7321	9.7179	9.7214	1647436.0
2010-06-18 09:30:00	AAPL	Stock	9.7204	9.7468	9.6936	9.7125	188265924.0
2010-06-18 10:00:00	AAPL	Stock	9.7132	9.7743	9.7114	9.7732	89108824.0
2010-06-18 10:30:00	AAPL	Stock	9.7732	9.8186	9.7679	9.817	83962228.0
2010-06-18 11:00:00	AAPL	Stock	9.817	9.8214	9.7839	9.7862	56187488.0
2010-06-18 11:30:00	AAPL	Stock	9.7873	9.8011	9.7746	9.7843	36267168.0
2010-06-18 12:00:00	AAPL	Stock	9.7836	9.7993	9.7611	9.7682	36774948.0
2010-06-18 12:30:00	AAPL	Stock	9.7682	9.7843	9.7582	9.7739	26648048.0
2010-06-18 13:00:00	AAPL	Stock	9.7732	9.7911	9.7707	9.7757	20972056.0
2010-06-18 13:30:00	AAPL	Stock	9.7754	9.7829	9.7618	9.7704	20872432.0
2010-06-18 14:00:00	AAPL	Stock	9.7696	9.7968	9.7679	9.7921	26450536.0
2010-06-18 14:30:00	AAPL	Stock	9.7925	9.7925	9.7746	9.7854	27179824.0
2010-06-18 15:00:00	AAPL	Stock	9.7861	9.7871	9.7429	9.7707	53069604.0
2010-06-18 15:30:00	AAPL	Stock	9.7707	9.7904	9.7543	9.7882	70134232.0
2010-06-18 16:00:00	AAPL	Stock	9.7882	9.7916	9.7643	9.7861	29854888.0
2010-06-18 16:30:00	AAPL	Stock	9.7912	9.7934	9.7139	9.79	4198068.0
2010-06-18 17:00:00	AAPL	Stock	9.7893	9.7914	9.7889	9.7911	165368.0
2010-06-18 17:30:00	AAPL	Stock	9.7911	9.7925	9.7893	9.7907	167916.0
2010-06-18 18:00:00	AAPL	Stock	9.7925	9.7925	9.7857	9.7857	281400.0
2010-06-18 18:30:00	AAPL	Stock	9.7875	9.7893	9.7864	9.7864	54012.0
2010-06-18 19:00:00	AAPL	Stock	9.7864	9.7889	9.7857	9.7875	85736.0
2010-06-18 19:30:00	AAPL	Stock	9.7868	9.7879	9.7839	9.7843	192612.0
2010-06-18 20:00:00	AAPL	Stock	9.7846	9.7911	9.7846	9.7911	100800.0
2010-06-18 04:30:00	MSFT	Stock	26.4	26.4	26.4	26.4	400.0
2010-06-18 07:00:00	MSFT	Stock	26.3	26.3	26.3	26.3	500.0
2010-06-18 07:30:00	MSFT	Stock	26.4	26.4	26.4	26.4	241.0
2010-06-18 08:00:00	MSFT	Stock	26.31	26.31	26.31	26.31	460.0
2010-06-18 08:30:00	MSFT	Stock	26.33	26.39	26.33	26.34	48600.0
2010-06-18 09:00:00	MSFT	Stock	26.34	26.44	26.31	26.36	23285.0
2010-06-18 09:30:00	MSFT	Stock	26.35	26.39	26.17	26.27	17805977.0
2010-06-18 10:00:00	MSFT	Stock	26.27	26.46	26.26	26.452	3456431.0
2010-06-18 10:30:00	MSFT	Stock	26.45	26.53	26.39	26.44	3143100.0
2010-06-18 11:00:00	MSFT	Stock	26.44	26.5	26.3	26.35	2427531.0
2010-06-18 11:30:00	MSFT	Stock	26.345	26.35	26.25	26.301	1867076.0
2010-06-18 12:00:00	MSFT	Stock	26.31	26.35	26.2	26.23	1651529.0
2010-06-18 12:30:00	MSFT	Stock	26.23	26.34	26.21	26.259	1361994.0
2010-06-18 13:00:00	MSFT	Stock	26.25	26.37	26.24	26.355	1724263.0
2010-06-18 13:30:00	MSFT	Stock	26.355	26.41	26.31	26.38	1856732.0
2010-06-18 14:00:00	MSFT	Stock	26.375	26.42	26.34	26.41	1262358.0
2010-06-18 14:30:00	MSFT	Stock	26.41	26.42	26.35	26.37	1490458.0
2010-06-18 15:00:00	MSFT	Stock	26.37	26.38	26.3	26.36	2832369.0
2010-06-18 15:30:00	MSFT	Stock	26.36	26.45	26.33	26.43	5579306.0
2010-06-18 16:00:00	MSFT	Stock	26.43	26.45	26.29	26.435	3733791.0

> showing 50 of 73,767 rows — these rows as CSV

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