PREVIEW / stock_30min / 2008-05-14

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-05-14.parquet
  size:    1.3 MB
  rows:    69,300
  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
2008-05-14 04:30:00	AAPL	Stock	6.7975	6.7975	6.7975	6.7975	11200.0
2008-05-14 07:30:00	AAPL	Stock	6.7879	6.7943	6.7875	6.7943	15400.0
2008-05-14 08:00:00	AAPL	Stock	6.7843	6.8161	6.7836	6.8111	1416996.0
2008-05-14 08:30:00	AAPL	Stock	6.8139	6.8464	6.8136	6.8339	3680460.0
2008-05-14 09:00:00	AAPL	Stock	6.8339	6.8393	6.825	6.8293	2018016.0
2008-05-14 09:30:00	AAPL	Stock	6.8296	6.8657	6.8214	6.8343	114153536.0
2008-05-14 10:00:00	AAPL	Stock	6.835	6.8475	6.8043	6.8161	79512664.0
2008-05-14 10:30:00	AAPL	Stock	6.8168	6.8446	6.7768	6.7879	77412020.0
2008-05-14 11:00:00	AAPL	Stock	6.7879	6.8036	6.7739	6.7868	54083904.0
2008-05-14 11:30:00	AAPL	Stock	6.7871	6.8061	6.7689	6.7907	47537028.0
2008-05-14 12:00:00	AAPL	Stock	6.7907	6.8161	6.7879	6.7986	29665916.0
2008-05-14 12:30:00	AAPL	Stock	6.7993	6.8079	6.7896	6.8	20974128.0
2008-05-14 13:00:00	AAPL	Stock	6.8004	6.8286	6.8	6.8161	36058680.0
2008-05-14 13:30:00	AAPL	Stock	6.8164	6.83	6.8054	6.8054	34967884.0
2008-05-14 14:00:00	AAPL	Stock	6.805	6.8168	6.7925	6.7993	32720604.0
2008-05-14 14:30:00	AAPL	Stock	6.7986	6.8057	6.725	6.7271	87645908.0
2008-05-14 15:00:00	AAPL	Stock	6.7279	6.7296	6.6754	6.6968	130023488.0
2008-05-14 15:30:00	AAPL	Stock	6.6968	6.7032	6.6275	6.6479	142486652.0
2008-05-14 16:00:00	AAPL	Stock	6.6482	6.7843	6.6429	6.6607	12381796.0
2008-05-14 16:30:00	AAPL	Stock	6.6625	6.7843	6.6521	6.6557	416780.0
2008-05-14 17:00:00	AAPL	Stock	6.6554	6.6639	6.6482	6.6614	513716.0
2008-05-14 17:30:00	AAPL	Stock	6.6575	6.6614	6.6557	6.6582	177744.0
2008-05-14 18:00:00	AAPL	Stock	6.6614	6.6614	6.6575	6.6614	219548.0
2008-05-14 18:30:00	AAPL	Stock	6.6618	6.6643	6.6607	6.6643	171248.0
2008-05-14 19:00:00	AAPL	Stock	6.6643	6.6643	6.6593	6.6636	218764.0
2008-05-14 19:30:00	AAPL	Stock	6.6607	6.6643	6.6607	6.6625	140112.0
2008-05-14 08:00:00	MSFT	Stock	29.6	29.7	29.6	29.66	1758.0
2008-05-14 08:30:00	MSFT	Stock	29.75	29.78	29.75	29.77	2370.0
2008-05-14 09:00:00	MSFT	Stock	29.85	29.95	29.82	29.95	16398.0
2008-05-14 09:30:00	MSFT	Stock	29.89	30.18	29.73	30.1	7246028.0
2008-05-14 10:00:00	MSFT	Stock	30.1	30.18	30.02	30.031	7162856.0
2008-05-14 10:30:00	MSFT	Stock	30.04	30.13	30.0	30.06	5747039.0
2008-05-14 11:00:00	MSFT	Stock	30.058	30.11	30.01	30.05	2574857.0
2008-05-14 11:30:00	MSFT	Stock	30.05	30.14	30.0	30.08	3197768.0
2008-05-14 12:00:00	MSFT	Stock	30.08	30.09	30.03	30.05	1865071.0
2008-05-14 12:30:00	MSFT	Stock	30.05	30.06	29.97	30.01	3073899.0
2008-05-14 13:00:00	MSFT	Stock	30.01	30.09	29.98	30.08	3315644.0
2008-05-14 13:30:00	MSFT	Stock	30.079	30.19	30.07	30.15	5153293.0
2008-05-14 14:00:00	MSFT	Stock	30.152	30.25	30.15	30.191	3658508.0
2008-05-14 14:30:00	MSFT	Stock	30.2	30.26	30.11	30.18	3816075.0
2008-05-14 15:00:00	MSFT	Stock	30.18	30.19	30.01	30.042	5952314.0
2008-05-14 15:30:00	MSFT	Stock	30.04	30.05	29.86	29.89	9744190.0
2008-05-14 16:00:00	MSFT	Stock	29.93	30.155	29.78	29.87	1599261.0
2008-05-14 16:30:00	MSFT	Stock	29.87	29.93	29.78	29.88	31038.0
2008-05-14 17:00:00	MSFT	Stock	29.92	29.93	29.83	29.88	40999.0
2008-05-14 17:30:00	MSFT	Stock	29.84	29.87	29.83	29.85	700.0
2008-05-14 18:00:00	MSFT	Stock	29.84	29.85	29.84	29.85	2190.0
2008-05-14 18:30:00	MSFT	Stock	29.84	29.88	29.84	29.88	4300.0
2008-05-14 19:00:00	MSFT	Stock	29.84	29.84	29.83	29.83	1000.0
2008-05-14 19:30:00	MSFT	Stock	29.86	29.88	29.86	29.88	500.0

> showing 50 of 69,300 rows — these rows as CSV

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