PREVIEW / etf_30min / 2008-03-04

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-04.parquet
  size:    162 KB
  rows:    5,781

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-03-04 04:00:00	SPY	ETF	133.33	133.33	133.33	133.33	100.0
2008-03-04 04:30:00	SPY	ETF	133.27	133.27	133.0	133.0	300.0
2008-03-04 05:00:00	SPY	ETF	132.79	132.79	132.59	132.59	2600.0
2008-03-04 05:30:00	SPY	ETF	132.5	132.57	132.49	132.49	500.0
2008-03-04 06:00:00	SPY	ETF	132.58	132.62	132.32	132.32	75000.0
2008-03-04 06:30:00	SPY	ETF	132.41	132.41	132.0	132.25	170300.0
2008-03-04 07:00:00	SPY	ETF	132.25	132.57	132.2	132.5	507200.0
2008-03-04 07:30:00	SPY	ETF	132.48	132.65	132.41	132.44	296200.0
2008-03-04 08:00:00	SPY	ETF	132.44	132.62	132.03	132.56	1000000.0
2008-03-04 08:30:00	SPY	ETF	132.55	132.73	132.41	132.52	1449500.0
2008-03-04 09:00:00	SPY	ETF	132.52	132.77	132.11	132.22	4241788.0
2008-03-04 09:30:00	SPY	ETF	132.23	132.89	132.2	132.78	21557355.0
2008-03-04 10:00:00	SPY	ETF	132.78	133.0	132.48	132.53	17124332.0
2008-03-04 10:30:00	SPY	ETF	132.53	132.97	131.74	131.76	18396877.0
2008-03-04 11:00:00	SPY	ETF	131.76	131.88	131.43	131.84	19611381.0
2008-03-04 11:30:00	SPY	ETF	131.85	132.03	131.49	131.55	15516092.0
2008-03-04 12:00:00	SPY	ETF	131.56	131.96	131.51	131.95	7836299.0
2008-03-04 12:30:00	SPY	ETF	131.95	132.1501	131.48	131.61	14995249.0
2008-03-04 13:00:00	SPY	ETF	131.6001	131.98	131.28	131.895	15687221.0
2008-03-04 13:30:00	SPY	ETF	131.9	131.93	131.14	131.33	17962403.0
2008-03-04 14:00:00	SPY	ETF	131.34	131.62	130.99	131.33	23890490.0
2008-03-04 14:30:00	SPY	ETF	131.33	132.4	131.2	131.83	26478679.0
2008-03-04 15:00:00	SPY	ETF	131.84	133.1	131.65	132.46	37367027.0
2008-03-04 15:30:00	SPY	ETF	132.46	133.4	132.37	132.92	30932026.0
2008-03-04 16:00:00	SPY	ETF	132.85	133.08	131.45	133.01	2013100.0
2008-03-04 16:30:00	SPY	ETF	133.03	133.4	132.98	133.31	2104900.0
2008-03-04 17:00:00	SPY	ETF	133.31	133.32	132.95	132.95	466400.0
2008-03-04 17:30:00	SPY	ETF	133.04	133.1	132.95	133.01	37300.0
2008-03-04 18:00:00	SPY	ETF	133.0	133.2	133.0	133.15	30400.0
2008-03-04 18:30:00	SPY	ETF	133.18	133.24	133.15	133.2	12700.0
2008-03-04 19:00:00	SPY	ETF	133.2	133.28	133.13	133.22	16000.0
2008-03-04 19:30:00	SPY	ETF	133.21	133.24	133.03	133.11	74900.0
2008-03-04 04:30:00	QQQ	ETF	42.68	42.68	42.68	42.68	300.0
2008-03-04 06:00:00	QQQ	ETF	42.41	42.41	42.41	42.41	2000.0
2008-03-04 06:30:00	QQQ	ETF	42.29	42.33	42.22	42.22	154200.0
2008-03-04 07:00:00	QQQ	ETF	42.29	42.4	42.29	42.4	355741.0
2008-03-04 07:30:00	QQQ	ETF	42.38	42.44	42.36	42.39	148131.0
2008-03-04 08:00:00	QQQ	ETF	42.42	42.47	42.31	42.45	675363.0
2008-03-04 08:30:00	QQQ	ETF	42.45	42.5	42.39	42.44	451976.0
2008-03-04 09:00:00	QQQ	ETF	42.46	42.51	42.32	42.4	991852.0
2008-03-04 09:30:00	QQQ	ETF	42.41	42.52	42.32	42.4578	14179397.0
2008-03-04 10:00:00	QQQ	ETF	42.45	42.57	42.34	42.4	9649404.0
2008-03-04 10:30:00	QQQ	ETF	42.4	42.4	42.2	42.2	12676784.0
2008-03-04 11:00:00	QQQ	ETF	42.21	42.28	42.08	42.2699	9232329.0
2008-03-04 11:30:00	QQQ	ETF	42.26	42.3	42.17	42.205	8771823.0
2008-03-04 12:00:00	QQQ	ETF	42.2	42.37	42.18	42.36	6780193.0
2008-03-04 12:30:00	QQQ	ETF	42.36	42.45	42.22	42.26	7799859.0
2008-03-04 13:00:00	QQQ	ETF	42.26	42.41	42.15	42.3601	5997970.0
2008-03-04 13:30:00	QQQ	ETF	42.37	42.37	42.12	42.14	9419510.0
2008-03-04 14:00:00	QQQ	ETF	42.15	42.26	42.02	42.16	13281447.0

> showing 50 of 5,781 rows — these rows as CSV

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