PREVIEW / stock_30min / 2010-06-22

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-22.parquet
  size:    1.3 MB
  rows:    72,976
  symbols: 3,468

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-22 04:30:00	AAPL	Stock	9.7118	9.7118	9.7118	9.7118	2800.0
2010-06-22 05:00:00	AAPL	Stock	9.6832	9.6832	9.6786	9.6786	28000.0
2010-06-22 05:30:00	AAPL	Stock	9.6793	9.6793	9.6793	9.6793	2800.0
2010-06-22 06:00:00	AAPL	Stock	9.6832	9.6832	9.6832	9.6832	10752.0
2010-06-22 06:30:00	AAPL	Stock	9.6896	9.6896	9.6661	9.6661	41440.0
2010-06-22 07:00:00	AAPL	Stock	9.6689	9.7139	9.6689	9.6946	357112.0
2010-06-22 07:30:00	AAPL	Stock	9.6975	9.6982	9.6679	9.6925	922712.0
2010-06-22 08:00:00	AAPL	Stock	9.6936	9.7225	9.6825	9.7161	2008608.0
2010-06-22 08:30:00	AAPL	Stock	9.7161	9.7314	9.7071	9.7271	2510480.0
2010-06-22 09:00:00	AAPL	Stock	9.7264	9.7536	9.7125	9.7154	3902696.0
2010-06-22 09:30:00	AAPL	Stock	9.7164	9.8161	9.7054	9.7786	102678856.0
2010-06-22 10:00:00	AAPL	Stock	9.7796	9.7839	9.6964	9.7389	76682676.0
2010-06-22 10:30:00	AAPL	Stock	9.7389	9.7804	9.7057	9.7714	42498092.0
2010-06-22 11:00:00	AAPL	Stock	9.77	9.7996	9.7207	9.7879	55050772.0
2010-06-22 11:30:00	AAPL	Stock	9.7886	9.8409	9.7679	9.7918	57287720.0
2010-06-22 12:00:00	AAPL	Stock	9.7943	9.8232	9.7893	9.8032	26342456.0
2010-06-22 12:30:00	AAPL	Stock	9.8018	9.8246	9.8004	9.8168	23127412.0
2010-06-22 13:00:00	AAPL	Stock	9.8168	9.8561	9.8089	9.8321	38513580.0
2010-06-22 13:30:00	AAPL	Stock	9.8314	9.8561	9.8107	9.8343	35831236.0
2010-06-22 14:00:00	AAPL	Stock	9.8346	9.8346	9.7793	9.7886	48232324.0
2010-06-22 14:30:00	AAPL	Stock	9.7896	9.8079	9.7418	9.76	59172596.0
2010-06-22 15:00:00	AAPL	Stock	9.7614	9.7946	9.7479	9.755	45775800.0
2010-06-22 15:30:00	AAPL	Stock	9.7536	9.7804	9.7225	9.7664	71227352.0
2010-06-22 16:00:00	AAPL	Stock	9.7661	9.7804	9.7604	9.7711	11918032.0
2010-06-22 16:30:00	AAPL	Stock	9.7714	9.7868	9.7306	9.7804	1140972.0
2010-06-22 17:00:00	AAPL	Stock	9.7832	9.7929	9.7789	9.7821	640836.0
2010-06-22 17:30:00	AAPL	Stock	9.7832	9.7836	9.7714	9.775	203532.0
2010-06-22 18:00:00	AAPL	Stock	9.7732	9.7836	9.7679	9.7686	405048.0
2010-06-22 18:30:00	AAPL	Stock	9.7693	9.7839	9.7693	9.7836	288624.0
2010-06-22 19:00:00	AAPL	Stock	9.7821	9.7893	9.7786	9.7875	467712.0
2010-06-22 19:30:00	AAPL	Stock	9.7879	9.7925	9.7839	9.7925	350700.0
2010-06-22 07:00:00	MSFT	Stock	25.92	25.92	25.88	25.88	1235.0
2010-06-22 08:00:00	MSFT	Stock	25.95	26.02	25.94	25.98	4380.0
2010-06-22 08:30:00	MSFT	Stock	26.0	26.02	25.98	26.02	23820.0
2010-06-22 09:00:00	MSFT	Stock	26.05	26.2	26.05	26.15	84465.0
2010-06-22 09:30:00	MSFT	Stock	26.16	26.45	26.14	26.2	6922831.0
2010-06-22 10:00:00	MSFT	Stock	26.2	26.25	26.04	26.16	5296226.0
2010-06-22 10:30:00	MSFT	Stock	26.17	26.31	26.14	26.26	3859816.0
2010-06-22 11:00:00	MSFT	Stock	26.26	26.27	26.16	26.24	3317265.0
2010-06-22 11:30:00	MSFT	Stock	26.24	26.34	26.208	26.265	2854474.0
2010-06-22 12:00:00	MSFT	Stock	26.265	26.3	26.2	26.24	1790224.0
2010-06-22 12:30:00	MSFT	Stock	26.24	26.28	26.22	26.24	1709759.0
2010-06-22 13:00:00	MSFT	Stock	26.24	26.3	26.2	26.23	1482330.0
2010-06-22 13:30:00	MSFT	Stock	26.22	26.32	26.17	26.225	2599776.0
2010-06-22 14:00:00	MSFT	Stock	26.225	26.252	26.15	26.19	3708291.0
2010-06-22 14:30:00	MSFT	Stock	26.19	26.26	26.0	26.03	4444784.0
2010-06-22 15:00:00	MSFT	Stock	26.02	26.07	25.88	25.89	4698707.0
2010-06-22 15:30:00	MSFT	Stock	25.891	25.92	25.76	25.78	8557073.0
2010-06-22 16:00:00	MSFT	Stock	25.78	26.268	25.77	25.79	3303759.0
2010-06-22 16:30:00	MSFT	Stock	26.103	26.103	25.8	25.8	223092.0

> showing 50 of 72,976 rows — these rows as CSV

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