PREVIEW / stock_30min / 2010-09-20

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-20.parquet
  size:    1.4 MB
  rows:    76,469
  symbols: 3,502

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-20 04:30:00	AAPL	Stock	9.8571	9.8571	9.8571	9.8571	5600.0
2010-09-20 05:00:00	AAPL	Stock	9.8571	9.8571	9.8571	9.8571	5600.0
2010-09-20 07:00:00	AAPL	Stock	9.8493	9.8764	9.8489	9.8746	16800.0
2010-09-20 07:30:00	AAPL	Stock	9.8671	9.875	9.8664	9.8682	91700.0
2010-09-20 08:00:00	AAPL	Stock	9.8739	9.8739	9.8571	9.8571	941948.0
2010-09-20 08:30:00	AAPL	Stock	9.8575	9.8643	9.8482	9.8532	1054284.0
2010-09-20 09:00:00	AAPL	Stock	9.8525	9.8675	9.8525	9.8611	711256.0
2010-09-20 09:30:00	AAPL	Stock	9.8629	9.9961	9.8518	9.9732	127004416.0
2010-09-20 10:00:00	AAPL	Stock	9.9739	10.0629	9.9646	10.0464	97255816.0
2010-09-20 10:30:00	AAPL	Stock	10.0471	10.0489	10.0068	10.0271	51925972.0
2010-09-20 11:00:00	AAPL	Stock	10.0271	10.0421	10.0132	10.0264	25463592.0
2010-09-20 11:30:00	AAPL	Stock	10.0261	10.0446	10.0214	10.0254	24197880.0
2010-09-20 12:00:00	AAPL	Stock	10.0254	10.0393	10.015	10.0219	22286404.0
2010-09-20 12:30:00	AAPL	Stock	10.0225	10.0475	10.0179	10.0425	28293748.0
2010-09-20 13:00:00	AAPL	Stock	10.0428	10.0614	10.0325	10.0514	29890112.0
2010-09-20 13:30:00	AAPL	Stock	10.0525	10.0714	10.0482	10.0696	31717112.0
2010-09-20 14:00:00	AAPL	Stock	10.0693	10.0857	10.0575	10.0857	31127628.0
2010-09-20 14:30:00	AAPL	Stock	10.0857	10.1054	10.0814	10.1021	37198084.0
2010-09-20 15:00:00	AAPL	Stock	10.1025	10.1286	10.0939	10.1064	48774432.0
2010-09-20 15:30:00	AAPL	Stock	10.1058	10.135	10.0993	10.1264	82637296.0
2010-09-20 16:00:00	AAPL	Stock	10.1225	10.1243	9.876	10.1224	10467884.0
2010-09-20 16:30:00	AAPL	Stock	10.1118	10.1139	10.1086	10.1086	320096.0
2010-09-20 17:00:00	AAPL	Stock	10.11	10.1204	10.1079	10.1204	599144.0
2010-09-20 17:30:00	AAPL	Stock	10.1118	10.1179	10.1111	10.1175	163380.0
2010-09-20 18:00:00	AAPL	Stock	10.1175	10.1193	10.1154	10.1179	212548.0
2010-09-20 18:30:00	AAPL	Stock	10.1196	10.1196	10.1111	10.1139	114912.0
2010-09-20 19:00:00	AAPL	Stock	10.1121	10.1154	10.1107	10.1154	213164.0
2010-09-20 19:30:00	AAPL	Stock	10.1136	10.1193	10.1132	10.1157	128296.0
2010-09-20 07:30:00	MSFT	Stock	25.4	25.4	25.4	25.4	300.0
2010-09-20 08:00:00	MSFT	Stock	25.3	25.31	25.26	25.28	15100.0
2010-09-20 08:30:00	MSFT	Stock	25.28	25.3	25.27	25.27	14930.0
2010-09-20 09:00:00	MSFT	Stock	25.29	25.3	25.23	25.27	26233.0
2010-09-20 09:30:00	MSFT	Stock	25.28	25.28	25.11	25.22	4561467.0
2010-09-20 10:00:00	MSFT	Stock	25.23	25.44	25.166	25.43	4332336.0
2010-09-20 10:30:00	MSFT	Stock	25.44	25.45	25.38	25.385	3986828.0
2010-09-20 11:00:00	MSFT	Stock	25.39	25.41	25.3	25.33	2529066.0
2010-09-20 11:30:00	MSFT	Stock	25.323	25.37	25.3	25.36	2169156.0
2010-09-20 12:00:00	MSFT	Stock	25.36	25.36	25.28	25.282	1770760.0
2010-09-20 12:30:00	MSFT	Stock	25.28	25.33	25.26	25.315	1714717.0
2010-09-20 13:00:00	MSFT	Stock	25.31	25.33	25.27	25.28	1545166.0
2010-09-20 13:30:00	MSFT	Stock	25.29	25.34	25.26	25.315	1883088.0
2010-09-20 14:00:00	MSFT	Stock	25.312	25.37	25.27	25.365	1995865.0
2010-09-20 14:30:00	MSFT	Stock	25.37	25.41	25.36	25.402	2927930.0
2010-09-20 15:00:00	MSFT	Stock	25.4	25.5	25.4	25.44	3804426.0
2010-09-20 15:30:00	MSFT	Stock	25.44	25.52	25.41	25.43	9350862.0
2010-09-20 16:00:00	MSFT	Stock	25.43	25.499	25.36	25.445	6974474.0
2010-09-20 16:30:00	MSFT	Stock	25.43	25.5	25.41	25.42	68834.0
2010-09-20 17:00:00	MSFT	Stock	25.43	25.44	25.42	25.44	49904.0
2010-09-20 17:30:00	MSFT	Stock	25.41	25.41	25.38	25.38	2688.0
2010-09-20 18:00:00	MSFT	Stock	25.38	25.43	25.37	25.4	40195.0

> showing 50 of 76,469 rows — these rows as CSV

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