PREVIEW / stock_30min / 2007-02-27

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-02-27.parquet
  size:    1.0 MB
  rows:    56,646
  symbols: 2,520

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
2007-02-27 04:30:00	AAPL	Stock	3.1286	3.1286	3.1286	3.1286	8400.0
2007-02-27 07:00:00	AAPL	Stock	3.1143	3.1196	3.1071	3.1093	176400.0
2007-02-27 07:30:00	AAPL	Stock	3.1089	3.1139	3.1046	3.1104	1417920.0
2007-02-27 08:00:00	AAPL	Stock	3.1096	3.1243	3.1071	3.1171	2829540.0
2007-02-27 08:30:00	AAPL	Stock	3.1161	3.1161	3.0971	3.1039	3215576.0
2007-02-27 09:00:00	AAPL	Stock	3.1036	3.1125	3.08	3.0811	4840136.0
2007-02-27 09:30:00	AAPL	Stock	3.0821	3.1057	3.0675	3.0882	158440324.0
2007-02-27 10:00:00	AAPL	Stock	3.0882	3.1054	3.0839	3.1032	78396416.0
2007-02-27 10:30:00	AAPL	Stock	3.1029	3.11	3.0904	3.0929	67849852.0
2007-02-27 11:00:00	AAPL	Stock	3.0932	3.0979	3.0861	3.0939	42659680.0
2007-02-27 11:30:00	AAPL	Stock	3.0936	3.1	3.0714	3.0721	58884672.0
2007-02-27 12:00:00	AAPL	Stock	3.0721	3.0739	3.05	3.0657	94350228.0
2007-02-27 12:30:00	AAPL	Stock	3.065	3.0746	3.0614	3.0629	44654512.0
2007-02-27 13:00:00	AAPL	Stock	3.0629	3.0721	3.0546	3.0589	32359040.0
2007-02-27 13:30:00	AAPL	Stock	3.0593	3.0657	3.0482	3.0536	47329436.0
2007-02-27 14:00:00	AAPL	Stock	3.0536	3.0546	2.9982	3.0	131494496.0
2007-02-27 14:30:00	AAPL	Stock	3.0004	3.0336	2.9839	3.0036	118941564.0
2007-02-27 15:00:00	AAPL	Stock	3.0032	3.0329	2.9789	3.0229	129330432.0
2007-02-27 15:30:00	AAPL	Stock	3.0229	3.0332	2.9982	2.9982	99616272.0
2007-02-27 16:00:00	AAPL	Stock	2.9996	3.0254	2.9939	3.0014	4359124.0
2007-02-27 16:30:00	AAPL	Stock	3.0004	3.0004	2.9886	2.9929	1356572.0
2007-02-27 17:00:00	AAPL	Stock	2.9921	3.0018	2.9921	3.0	875168.0
2007-02-27 17:30:00	AAPL	Stock	3.0018	3.0125	2.9961	2.9961	918848.0
2007-02-27 18:00:00	AAPL	Stock	2.9961	2.9975	2.9857	2.9975	636356.0
2007-02-27 18:30:00	AAPL	Stock	2.9893	2.9911	2.9871	2.9875	109732.0
2007-02-27 19:00:00	AAPL	Stock	2.9907	2.9911	2.9879	2.9882	187768.0
2007-02-27 19:30:00	AAPL	Stock	2.9879	2.9893	2.9875	2.9875	202972.0
2007-02-27 04:00:00	MSFT	Stock	28.82	28.82	28.82	28.82	100.0
2007-02-27 07:00:00	MSFT	Stock	28.75	28.75	28.75	28.75	200.0
2007-02-27 07:30:00	MSFT	Stock	28.7	28.7	28.7	28.7	1300.0
2007-02-27 08:00:00	MSFT	Stock	28.77	29.27	28.77	28.78	21060.0
2007-02-27 08:30:00	MSFT	Stock	28.78	28.78	28.7	28.7	19865.0
2007-02-27 09:00:00	MSFT	Stock	28.7	28.74	28.66	28.7	66549.0
2007-02-27 09:30:00	MSFT	Stock	28.71	28.95	28.65	28.92	7832282.0
2007-02-27 10:00:00	MSFT	Stock	28.93	28.97	28.81	28.86	4843387.0
2007-02-27 10:30:00	MSFT	Stock	28.865	28.9	28.8	28.8	4596157.0
2007-02-27 11:00:00	MSFT	Stock	28.8	28.83	28.76	28.78	4101215.0
2007-02-27 11:30:00	MSFT	Stock	28.782	28.823	28.75	28.75	3325901.0
2007-02-27 12:00:00	MSFT	Stock	28.75	28.76	28.67	28.69	3487897.0
2007-02-27 12:30:00	MSFT	Stock	28.69	28.74	28.69	28.7	2784294.0
2007-02-27 13:00:00	MSFT	Stock	28.7	28.71	28.65	28.67	4196881.0
2007-02-27 13:30:00	MSFT	Stock	28.67	28.69	28.56	28.59	3619120.0
2007-02-27 14:00:00	MSFT	Stock	28.58	28.62	28.37	28.37	8550530.0
2007-02-27 14:30:00	MSFT	Stock	28.37	28.48	28.02	28.03	10906436.0
2007-02-27 15:00:00	MSFT	Stock	28.04	28.41	27.79	28.1	12617816.0
2007-02-27 15:30:00	MSFT	Stock	28.1	28.38	27.88	27.88	11621843.0
2007-02-27 16:00:00	MSFT	Stock	27.88	27.96	27.7	27.91	477144.0
2007-02-27 16:30:00	MSFT	Stock	27.89	27.9	27.83	27.83	143621.0
2007-02-27 17:00:00	MSFT	Stock	27.84	27.87	27.79	27.86	44526.0
2007-02-27 17:30:00	MSFT	Stock	28.04	28.04	27.8	27.87	62059.0

> showing 50 of 56,646 rows — these rows as CSV

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