PREVIEW / etf_30min / 2007-08-15

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-15.parquet
  size:    134 KB
  rows:    4,880

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-08-15 04:00:00	SPY	ETF	142.65	142.65	142.65	142.65	100.0
2007-08-15 05:30:00	SPY	ETF	142.85	142.85	142.85	142.85	3000.0
2007-08-15 06:00:00	SPY	ETF	142.71	142.71	142.57	142.57	60200.0
2007-08-15 06:30:00	SPY	ETF	142.47	142.61	142.32	142.32	78300.0
2007-08-15 07:00:00	SPY	ETF	142.25	142.57	142.25	142.26	1000200.0
2007-08-15 07:30:00	SPY	ETF	142.34	142.36	142.15	142.24	478200.0
2007-08-15 08:00:00	SPY	ETF	142.24	142.59	142.2	142.4	1876500.0
2007-08-15 08:30:00	SPY	ETF	142.35	142.68	142.22	142.26	4050700.0
2007-08-15 09:00:00	SPY	ETF	142.25	142.73	142.25	142.71	3285700.0
2007-08-15 09:30:00	SPY	ETF	142.72	143.9	142.13	143.31	41249166.0
2007-08-15 10:00:00	SPY	ETF	143.31	144.46	142.76	144.3	32750961.0
2007-08-15 10:30:00	SPY	ETF	144.3	144.305	143.34	143.57	16253398.0
2007-08-15 11:00:00	SPY	ETF	143.58	143.9	143.36	143.81	9114970.0
2007-08-15 11:30:00	SPY	ETF	143.81	143.83	142.75	142.91	16236762.0
2007-08-15 12:00:00	SPY	ETF	142.91	143.42	142.88	143.13	10038819.0
2007-08-15 12:30:00	SPY	ETF	143.12	143.55	142.87	143.23	11117183.0
2007-08-15 13:00:00	SPY	ETF	143.22	143.72	143.0	143.54	8047110.0
2007-08-15 13:30:00	SPY	ETF	143.55	144.38	143.55	143.91	17217685.0
2007-08-15 14:00:00	SPY	ETF	143.91	144.01	143.1	143.2	15083715.0
2007-08-15 14:30:00	SPY	ETF	143.19	143.48	142.25	142.44	24206741.0
2007-08-15 15:00:00	SPY	ETF	142.46	142.82	141.51	141.51	28199692.0
2007-08-15 15:30:00	SPY	ETF	141.51	142.0	140.62	140.9	43071423.0
2007-08-15 16:00:00	SPY	ETF	140.93	141.25	140.8408	141.18	10122800.0
2007-08-15 16:30:00	SPY	ETF	141.18	141.18	140.88	140.93	3217000.0
2007-08-15 17:00:00	SPY	ETF	140.96	143.482	140.84	140.98	653400.0
2007-08-15 17:30:00	SPY	ETF	140.92	141.03	140.7	140.88	94100.0
2007-08-15 18:00:00	SPY	ETF	140.81	140.85	140.65	140.71	99700.0
2007-08-15 18:30:00	SPY	ETF	140.66	140.79	140.64	140.72	15800.0
2007-08-15 19:00:00	SPY	ETF	140.75	140.89	140.7	140.81	57300.0
2007-08-15 19:30:00	SPY	ETF	140.81	140.88	140.76	140.88	32500.0
2007-08-15 20:00:00	SPY	ETF	140.88	140.88	140.88	140.88	100.0
2007-08-15 04:00:00	QQQ	ETF	46.81	46.81	46.81	46.81	3001.0
2007-08-15 06:30:00	QQQ	ETF	46.6	46.6	46.56	46.56	30000.0
2007-08-15 07:00:00	QQQ	ETF	46.6	46.6	46.53	46.53	274196.0
2007-08-15 07:30:00	QQQ	ETF	46.54	46.56	46.46	46.49	580019.0
2007-08-15 08:00:00	QQQ	ETF	46.49	46.64	46.48	46.53	3456785.0
2007-08-15 08:30:00	QQQ	ETF	46.55	46.65	46.5	46.54	1598526.0
2007-08-15 09:00:00	QQQ	ETF	46.55	46.68	46.54	46.68	2395865.0
2007-08-15 09:30:00	QQQ	ETF	46.68	47.04	46.58	46.86	27193662.0
2007-08-15 10:00:00	QQQ	ETF	46.86	47.08	46.66	47.08	24166253.0
2007-08-15 10:30:00	QQQ	ETF	47.08	47.08	46.72	46.81	14734726.0
2007-08-15 11:00:00	QQQ	ETF	46.81	46.95	46.73	46.93	5696041.0
2007-08-15 11:30:00	QQQ	ETF	46.93	46.93	46.53	46.55	16265797.0
2007-08-15 12:00:00	QQQ	ETF	46.55	46.77	46.54	46.68	8186099.0
2007-08-15 12:30:00	QQQ	ETF	46.67	46.78	46.59	46.68	4745801.0
2007-08-15 13:00:00	QQQ	ETF	46.69	46.83	46.61	46.78	5091497.0
2007-08-15 13:30:00	QQQ	ETF	46.79	47.09	46.79	46.942	13440640.0
2007-08-15 14:00:00	QQQ	ETF	46.95	47.0	46.71	46.75	7857876.0
2007-08-15 14:30:00	QQQ	ETF	46.75	46.78	46.43	46.45	11093676.0
2007-08-15 15:00:00	QQQ	ETF	46.47	46.58	46.15	46.17	20689036.0

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

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