PREVIEW / etf_30min / 2008-09-24

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-24.parquet
  size:    171 KB
  rows:    6,033

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-09-24 05:00:00	SPY	ETF	120.0	120.0	120.0	120.0	500.0
2008-09-24 05:30:00	SPY	ETF	120.0	120.0	120.0	120.0	3000.0
2008-09-24 06:00:00	SPY	ETF	119.8	119.8	119.4	119.4	11400.0
2008-09-24 06:30:00	SPY	ETF	119.36	119.5	119.0	119.5	24400.0
2008-09-24 07:00:00	SPY	ETF	119.5	119.87	119.44	119.68	328472.0
2008-09-24 07:30:00	SPY	ETF	119.68	119.68	118.8	119.45	750150.0
2008-09-24 08:00:00	SPY	ETF	119.46	120.5	119.11	119.88	2780549.0
2008-09-24 08:30:00	SPY	ETF	119.9	120.02	119.43	119.69	4706982.0
2008-09-24 09:00:00	SPY	ETF	119.67	120.244	119.08	119.19	3912154.0
2008-09-24 09:30:00	SPY	ETF	119.18	119.3	118.3	118.83	33249330.0
2008-09-24 10:00:00	SPY	ETF	118.82	118.98	118.08	118.74	29289747.0
2008-09-24 10:30:00	SPY	ETF	118.75	119.31	118.65	119.281	18222443.0
2008-09-24 11:00:00	SPY	ETF	119.28	119.32	118.28	118.77	17648708.0
2008-09-24 11:30:00	SPY	ETF	118.77	119.05	118.16	118.75	17765579.0
2008-09-24 12:00:00	SPY	ETF	118.75	118.97	118.21	118.45	13403602.0
2008-09-24 12:30:00	SPY	ETF	118.45	118.76	118.34	118.57	13686486.0
2008-09-24 13:00:00	SPY	ETF	118.57	120.0	118.48	119.4	21298439.0
2008-09-24 13:30:00	SPY	ETF	119.4	119.6	118.6712	118.96	18115891.0
2008-09-24 14:00:00	SPY	ETF	118.96	119.12	118.5	118.96	20611883.0
2008-09-24 14:30:00	SPY	ETF	118.97	119.52	118.71	118.76	15028417.0
2008-09-24 15:00:00	SPY	ETF	118.77	119.1	118.16	118.73	19856793.0
2008-09-24 15:30:00	SPY	ETF	118.73	118.97	117.79	118.84	36187915.0
2008-09-24 16:00:00	SPY	ETF	118.8	119.05	118.437	118.9	11347694.0
2008-09-24 16:30:00	SPY	ETF	118.9	119.04	118.2244	118.99	2399563.0
2008-09-24 17:00:00	SPY	ETF	118.99	118.99	118.5	118.65	5185515.0
2008-09-24 17:30:00	SPY	ETF	118.7	118.73	118.51	118.6	22867.0
2008-09-24 18:00:00	SPY	ETF	118.58	118.83	118.58	118.71	184364.0
2008-09-24 18:30:00	SPY	ETF	118.78	118.8	118.62	118.8	5218.0
2008-09-24 19:00:00	SPY	ETF	118.81	118.98	118.8	118.87	12806.0
2008-09-24 19:30:00	SPY	ETF	118.82	118.9	118.57	118.65	19212.0
2008-09-24 05:30:00	QQQ	ETF	40.99	40.99	40.99	40.99	100.0
2008-09-24 06:30:00	QQQ	ETF	40.9	40.9	40.9	40.9	900.0
2008-09-24 07:00:00	QQQ	ETF	40.93	40.95	40.85	40.89	11000.0
2008-09-24 07:30:00	QQQ	ETF	40.86	40.86	40.65	40.83	80710.0
2008-09-24 08:00:00	QQQ	ETF	40.83	41.07	40.77	41.02	3782823.0
2008-09-24 08:30:00	QQQ	ETF	41.02	41.11	40.94	41.0	1409789.0
2008-09-24 09:00:00	QQQ	ETF	41.0	41.15	40.83	40.84	1852038.0
2008-09-24 09:30:00	QQQ	ETF	40.85	40.88	40.55	40.78	22367695.0
2008-09-24 10:00:00	QQQ	ETF	40.77	40.83	40.52	40.75	12975641.0
2008-09-24 10:30:00	QQQ	ETF	40.75	41.09	40.73	41.07	10825863.0
2008-09-24 11:00:00	QQQ	ETF	41.07	41.09	40.76	40.96	8377535.0
2008-09-24 11:30:00	QQQ	ETF	40.96	41.03	40.66	40.88	7596964.0
2008-09-24 12:00:00	QQQ	ETF	40.8784	41.0	40.7	40.76	7965454.0
2008-09-24 12:30:00	QQQ	ETF	40.76	40.9	40.73	40.81	3906870.0
2008-09-24 13:00:00	QQQ	ETF	40.81	41.26	40.76	41.2412	7518199.0
2008-09-24 13:30:00	QQQ	ETF	41.24	41.26	40.99	41.03	7275674.0
2008-09-24 14:00:00	QQQ	ETF	41.03	41.14	40.89	41.12	6476527.0
2008-09-24 14:30:00	QQQ	ETF	41.13	41.26	40.9489	40.96	7237446.0
2008-09-24 15:00:00	QQQ	ETF	40.96	41.12	40.59	40.84	11180636.0
2008-09-24 15:30:00	QQQ	ETF	40.8399	41.17	40.53	40.91	13168470.0

> showing 50 of 6,033 rows — these rows as CSV

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