PREVIEW / etf_30min / 2007-06-21

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-21.parquet
  size:    121 KB
  rows:    4,487

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-06-21 04:30:00	SPY	ETF	151.44	151.44	151.44	151.44	1000.0
2007-06-21 05:00:00	SPY	ETF	151.42	151.42	151.42	151.42	2000.0
2007-06-21 05:30:00	SPY	ETF	151.4	151.4	151.38	151.38	3000.0
2007-06-21 06:00:00	SPY	ETF	151.24	151.24	151.19	151.19	11500.0
2007-06-21 06:30:00	SPY	ETF	151.25	151.3	151.24	151.25	111400.0
2007-06-21 07:00:00	SPY	ETF	151.21	151.25	150.89	150.91	386100.0
2007-06-21 07:30:00	SPY	ETF	150.92	151.02	150.6	150.83	1988600.0
2007-06-21 08:00:00	SPY	ETF	150.88	151.17	150.7	150.86	2152300.0
2007-06-21 08:30:00	SPY	ETF	150.84	151.23	150.83	151.22	2340300.0
2007-06-21 09:00:00	SPY	ETF	151.22	151.22	150.94	151.06	2565500.0
2007-06-21 09:30:00	SPY	ETF	151.08	151.27	150.36	150.38	20587672.0
2007-06-21 10:00:00	SPY	ETF	150.38	151.47	150.25	151.24	38575830.0
2007-06-21 10:30:00	SPY	ETF	151.25	151.72	150.96	151.58	24011925.0
2007-06-21 11:00:00	SPY	ETF	151.58	151.79	151.29	151.38	12520886.0
2007-06-21 11:30:00	SPY	ETF	151.38	151.39	150.88	151.06	13400300.0
2007-06-21 12:00:00	SPY	ETF	151.06	151.39	150.79	151.0	14270861.0
2007-06-21 12:30:00	SPY	ETF	151.02	151.34	150.8	151.13	10531200.0
2007-06-21 13:00:00	SPY	ETF	151.14	151.75	151.14	151.73	8192835.0
2007-06-21 13:30:00	SPY	ETF	151.73	152.08	151.53	152.03	9627999.0
2007-06-21 14:00:00	SPY	ETF	152.03	152.11	151.75	151.76	7242436.0
2007-06-21 14:30:00	SPY	ETF	151.76	151.8	150.73	151.68	9294610.0
2007-06-21 15:00:00	SPY	ETF	151.68	151.87	151.58	151.84	7370193.0
2007-06-21 15:30:00	SPY	ETF	151.84	152.04	151.8	151.98	11878020.0
2007-06-21 16:00:00	SPY	ETF	151.99	152.06	151.92	152.04	2677700.0
2007-06-21 16:30:00	SPY	ETF	152.0	152.0	151.74	151.86	3790700.0
2007-06-21 17:00:00	SPY	ETF	151.88	151.92	151.87	151.91	18400.0
2007-06-21 17:30:00	SPY	ETF	151.88	151.88	151.84	151.85	130600.0
2007-06-21 18:00:00	SPY	ETF	151.88	151.91	151.87	151.87	3600.0
2007-06-21 18:30:00	SPY	ETF	151.89	151.89	151.83	151.83	9000.0
2007-06-21 19:00:00	SPY	ETF	151.85	151.85	151.85	151.85	200.0
2007-06-21 19:30:00	SPY	ETF	151.85	151.87	151.85	151.87	1600.0
2007-06-21 07:00:00	QQQ	ETF	47.3	47.34	47.22	47.22	174980.0
2007-06-21 07:30:00	QQQ	ETF	47.23	47.27	47.14	47.2	451982.0
2007-06-21 08:00:00	QQQ	ETF	47.21	47.26	47.15	47.22	384642.0
2007-06-21 08:30:00	QQQ	ETF	47.22	47.32	47.2	47.32	1465719.0
2007-06-21 09:00:00	QQQ	ETF	47.32	47.33	47.28	47.31	1122717.0
2007-06-21 09:30:00	QQQ	ETF	47.305	47.4	47.12	47.16	16515234.0
2007-06-21 10:00:00	QQQ	ETF	47.1505	47.5	47.08	47.43	35806520.0
2007-06-21 10:30:00	QQQ	ETF	47.43	47.64	47.35	47.57	16695523.0
2007-06-21 11:00:00	QQQ	ETF	47.58	47.61	47.4372	47.49	9510215.0
2007-06-21 11:30:00	QQQ	ETF	47.49	47.49	47.32	47.381	6361413.0
2007-06-21 12:00:00	QQQ	ETF	47.38	47.53	47.37	47.45	6242162.0
2007-06-21 12:30:00	QQQ	ETF	47.45	47.54	47.38	47.46	4858004.0
2007-06-21 13:00:00	QQQ	ETF	47.46	47.68	47.46	47.66	6115639.0
2007-06-21 13:30:00	QQQ	ETF	47.6514	47.78	47.65	47.77	7146828.0
2007-06-21 14:00:00	QQQ	ETF	47.76	47.79	47.66	47.66	4261306.0
2007-06-21 14:30:00	QQQ	ETF	47.66	47.69	47.56	47.65	6403628.0
2007-06-21 15:00:00	QQQ	ETF	47.66	47.72	47.62	47.71	5555352.0
2007-06-21 15:30:00	QQQ	ETF	47.72	47.78	47.7	47.74	7502482.0
2007-06-21 16:00:00	QQQ	ETF	47.74	47.79	47.7	47.76	1186077.0

> showing 50 of 4,487 rows — these rows as CSV

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