PREVIEW / stock_30min / 2010-09-17

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-17.parquet
  size:    1.4 MB
  rows:    75,620
  symbols: 3,492

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-09-17 04:00:00	AAPL	Stock	9.9454	9.9454	9.9454	9.9454	2800.0
2010-09-17 04:30:00	AAPL	Stock	9.9454	9.9454	9.9286	9.9286	5600.0
2010-09-17 05:30:00	AAPL	Stock	9.9554	9.9554	9.9096	9.9096	57120.0
2010-09-17 06:00:00	AAPL	Stock	9.9107	9.9107	9.9107	9.9107	16800.0
2010-09-17 06:30:00	AAPL	Stock	9.9	9.9104	9.8893	9.9104	28000.0
2010-09-17 07:00:00	AAPL	Stock	9.9143	9.9464	9.9143	9.9196	189700.0
2010-09-17 07:30:00	AAPL	Stock	9.9246	9.9246	9.8775	9.9004	375200.0
2010-09-17 08:00:00	AAPL	Stock	9.8932	9.9393	9.8768	9.9321	3668476.0
2010-09-17 08:30:00	AAPL	Stock	9.9321	9.9357	9.9143	9.9157	2088464.0
2010-09-17 09:00:00	AAPL	Stock	9.9157	9.925	9.9118	9.9179	2417688.0
2010-09-17 09:30:00	AAPL	Stock	9.9186	9.9271	9.7743	9.7875	140629916.0
2010-09-17 10:00:00	AAPL	Stock	9.7882	9.8364	9.7771	9.8249	63327404.0
2010-09-17 10:30:00	AAPL	Stock	9.8264	9.8564	9.8132	9.8554	35316120.0
2010-09-17 11:00:00	AAPL	Stock	9.8546	9.8889	9.8311	9.8357	43562092.0
2010-09-17 11:30:00	AAPL	Stock	9.835	9.8539	9.8336	9.8493	20192480.0
2010-09-17 12:00:00	AAPL	Stock	9.8482	9.8743	9.8481	9.8743	16393636.0
2010-09-17 12:30:00	AAPL	Stock	9.8739	9.8782	9.8457	9.8535	19987352.0
2010-09-17 13:00:00	AAPL	Stock	9.8537	9.8564	9.8211	9.8327	20973568.0
2010-09-17 13:30:00	AAPL	Stock	9.8325	9.8568	9.8314	9.8493	12757668.0
2010-09-17 14:00:00	AAPL	Stock	9.8479	9.8643	9.8386	9.8482	20233024.0
2010-09-17 14:30:00	AAPL	Stock	9.8482	9.8639	9.8443	9.8543	15990660.0
2010-09-17 15:00:00	AAPL	Stock	9.8546	9.855	9.8132	9.8154	29675016.0
2010-09-17 15:30:00	AAPL	Stock	9.815	9.8493	9.8143	9.8379	65905000.0
2010-09-17 16:00:00	AAPL	Stock	9.8314	9.84	9.8211	9.8246	46684120.0
2010-09-17 16:30:00	AAPL	Stock	9.8304	9.9092	9.8304	9.8396	1948324.0
2010-09-17 17:00:00	AAPL	Stock	9.8379	9.8411	9.8268	9.8286	197960.0
2010-09-17 17:30:00	AAPL	Stock	9.8236	9.8286	9.8221	9.8261	98700.0
2010-09-17 18:00:00	AAPL	Stock	9.8225	9.8346	9.8143	9.8207	222460.0
2010-09-17 18:30:00	AAPL	Stock	9.8196	9.8232	9.8193	9.8232	50904.0
2010-09-17 19:00:00	AAPL	Stock	9.8261	9.8264	9.8154	9.8179	128688.0
2010-09-17 19:30:00	AAPL	Stock	9.8196	9.8214	9.8157	9.8179	121660.0
2010-09-17 04:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	100.0
2010-09-17 07:00:00	MSFT	Stock	25.5	25.55	25.5	25.55	2300.0
2010-09-17 07:30:00	MSFT	Stock	25.5	25.5	25.36	25.44	8000.0
2010-09-17 08:00:00	MSFT	Stock	25.44	25.49	25.37	25.43	22840.0
2010-09-17 08:30:00	MSFT	Stock	25.41	25.45	25.35	25.43	16975.0
2010-09-17 09:00:00	MSFT	Stock	25.41	25.47	25.35	25.4	93909.0
2010-09-17 09:30:00	MSFT	Stock	25.4	25.53	25.25	25.32	21246697.0
2010-09-17 10:00:00	MSFT	Stock	25.32	25.329	25.16	25.17	6370741.0
2010-09-17 10:30:00	MSFT	Stock	25.17	25.22	25.12	25.179	4318619.0
2010-09-17 11:00:00	MSFT	Stock	25.175	25.23	25.15	25.15	4344168.0
2010-09-17 11:30:00	MSFT	Stock	25.15	25.2	25.13	25.175	3028122.0
2010-09-17 12:00:00	MSFT	Stock	25.176	25.2	25.16	25.175	1597173.0
2010-09-17 12:30:00	MSFT	Stock	25.18	25.2	25.09	25.113	2047461.0
2010-09-17 13:00:00	MSFT	Stock	25.12	25.13	25.08	25.11	2437230.0
2010-09-17 13:30:00	MSFT	Stock	25.11	25.17	25.08	25.13	2464371.0
2010-09-17 14:00:00	MSFT	Stock	25.135	25.2	25.13	25.16	1887447.0
2010-09-17 14:30:00	MSFT	Stock	25.165	25.19	25.15	25.16	1274312.0
2010-09-17 15:00:00	MSFT	Stock	25.16	25.17	25.09	25.12	4082419.0
2010-09-17 15:30:00	MSFT	Stock	25.12	25.26	25.12	25.22	8028569.0

> showing 50 of 75,620 rows — these rows as CSV

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