PREVIEW / etf_30min / 2007-07-13

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-13.parquet
  size:    120 KB
  rows:    4,655

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-07-13 06:30:00	SPY	ETF	154.43	154.43	154.43	154.43	7000.0
2007-07-13 07:00:00	SPY	ETF	154.47	154.55	154.45	154.49	103700.0
2007-07-13 07:30:00	SPY	ETF	154.53	154.75	154.53	154.73	918300.0
2007-07-13 08:00:00	SPY	ETF	154.75	154.8	154.35	154.78	1477700.0
2007-07-13 08:30:00	SPY	ETF	154.7	154.7	154.42	154.56	1423500.0
2007-07-13 09:00:00	SPY	ETF	154.57	154.68	154.53	154.59	596700.0
2007-07-13 09:30:00	SPY	ETF	154.57	154.86	154.39	154.58	14585720.0
2007-07-13 10:00:00	SPY	ETF	154.58	154.94	154.58	154.76	13982712.0
2007-07-13 10:30:00	SPY	ETF	154.77	155.21	154.73	155.14	11850214.0
2007-07-13 11:00:00	SPY	ETF	155.14	155.17	154.95	155.0	4375870.0
2007-07-13 11:30:00	SPY	ETF	154.98	154.99	154.73	154.76	4643473.0
2007-07-13 12:00:00	SPY	ETF	154.76	154.9	154.72	154.87	4876621.0
2007-07-13 12:30:00	SPY	ETF	154.86	154.96	154.77	154.92	2607200.0
2007-07-13 13:00:00	SPY	ETF	154.925	155.02	154.82	154.96	3547400.0
2007-07-13 13:30:00	SPY	ETF	154.96	155.1	154.92	155.0	3299800.0
2007-07-13 14:00:00	SPY	ETF	155.01	155.17	154.94	155.04	4111588.0
2007-07-13 14:30:00	SPY	ETF	155.04	155.46	154.89	155.39	9329187.0
2007-07-13 15:00:00	SPY	ETF	155.38	155.42	155.15	155.42	6824870.0
2007-07-13 15:30:00	SPY	ETF	155.41	155.45	155.1	155.12	12367206.0
2007-07-13 16:00:00	SPY	ETF	155.08	155.18	154.88	155.1778	5659500.0
2007-07-13 16:30:00	SPY	ETF	155.05	155.05	154.93	154.96	69000.0
2007-07-13 17:00:00	SPY	ETF	154.96	155.03	154.85	155.03	3011200.0
2007-07-13 17:30:00	SPY	ETF	154.92	154.92	154.9	154.9	9900.0
2007-07-13 18:00:00	SPY	ETF	154.96	154.96	154.83	154.83	17500.0
2007-07-13 18:30:00	SPY	ETF	154.85	154.86	154.85	154.86	300.0
2007-07-13 19:00:00	SPY	ETF	154.88	154.91	154.87	154.91	400.0
2007-07-13 07:00:00	QQQ	ETF	49.61	49.66	49.61	49.63	36600.0
2007-07-13 07:30:00	QQQ	ETF	49.65	49.68	49.63	49.68	188750.0
2007-07-13 08:00:00	QQQ	ETF	49.68	49.71	49.65	49.7	504588.0
2007-07-13 08:30:00	QQQ	ETF	49.69	49.69	49.56	49.61	1318632.0
2007-07-13 09:00:00	QQQ	ETF	49.62	49.64	49.57	49.62	885095.0
2007-07-13 09:30:00	QQQ	ETF	49.62	49.76	49.58	49.6	12864188.0
2007-07-13 10:00:00	QQQ	ETF	49.6	49.71	49.5699	49.61	14421009.0
2007-07-13 10:30:00	QQQ	ETF	49.6	49.76	49.59	49.7385	6395135.0
2007-07-13 11:00:00	QQQ	ETF	49.74	49.75	49.67	49.73	3736356.0
2007-07-13 11:30:00	QQQ	ETF	49.72	49.72	49.62	49.6285	2941451.0
2007-07-13 12:00:00	QQQ	ETF	49.62	49.68	49.61	49.65	2625637.0
2007-07-13 12:30:00	QQQ	ETF	49.65	49.69	49.64	49.68	1141041.0
2007-07-13 13:00:00	QQQ	ETF	49.678	49.72	49.63	49.698	1506504.0
2007-07-13 13:30:00	QQQ	ETF	49.698	49.75	49.68	49.7181	1911420.0
2007-07-13 14:00:00	QQQ	ETF	49.72	49.79	49.64	49.75	2476620.0
2007-07-13 14:30:00	QQQ	ETF	49.752	49.88	49.74	49.86	5083847.0
2007-07-13 15:00:00	QQQ	ETF	49.85	49.95	49.81	49.9385	4050404.0
2007-07-13 15:30:00	QQQ	ETF	49.94	49.97	49.9	49.96	7651533.0
2007-07-13 16:00:00	QQQ	ETF	49.96	49.96	49.86	49.91	608128.0
2007-07-13 16:30:00	QQQ	ETF	49.91	49.94	49.89	49.9	530034.0
2007-07-13 17:00:00	QQQ	ETF	49.7701	49.9	49.64	49.84	210913.0
2007-07-13 17:30:00	QQQ	ETF	49.87	49.87	49.87	49.87	7960.0
2007-07-13 18:00:00	QQQ	ETF	49.89	49.9	49.87	49.87	26116.0
2007-07-13 18:30:00	QQQ	ETF	49.88	49.91	49.88	49.91	16432.0

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

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