PREVIEW / etf_30min / 2009-10-02

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-02.parquet
  size:    236 KB
  rows:    7,764

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
2009-10-02 04:00:00	SPY	ETF	102.95	103.01	102.88	102.88	7100.0
2009-10-02 04:30:00	SPY	ETF	102.88	103.03	102.86	103.03	2600.0
2009-10-02 05:00:00	SPY	ETF	103.12	103.15	102.98	103.01	2300.0
2009-10-02 05:30:00	SPY	ETF	102.9	102.9	102.85	102.85	4200.0
2009-10-02 06:00:00	SPY	ETF	102.9	102.94	102.89	102.9	6800.0
2009-10-02 06:30:00	SPY	ETF	102.95	102.95	102.85	102.86	17000.0
2009-10-02 07:00:00	SPY	ETF	102.87	102.97	102.81	102.81	103321.0
2009-10-02 07:30:00	SPY	ETF	102.86	103.03	102.86	102.98	220760.0
2009-10-02 08:00:00	SPY	ETF	102.94	103.11	102.66	102.88	1882381.0
2009-10-02 08:30:00	SPY	ETF	102.66	102.85	101.75	101.82	12618446.0
2009-10-02 09:00:00	SPY	ETF	101.82	102.13	101.68	102.02	6107250.0
2009-10-02 09:30:00	SPY	ETF	102.02	102.58	101.99	102.32	36635429.0
2009-10-02 10:00:00	SPY	ETF	102.32	102.84	102.03	102.82	27537645.0
2009-10-02 10:30:00	SPY	ETF	102.82	103.1	102.44	102.59	24599054.0
2009-10-02 11:00:00	SPY	ETF	102.59	102.89	102.5	102.6	11374188.0
2009-10-02 11:30:00	SPY	ETF	102.6	102.89	102.34	102.4291	16927447.0
2009-10-02 12:00:00	SPY	ETF	102.42	102.83	102.41	102.79	8569073.0
2009-10-02 12:30:00	SPY	ETF	102.8	103.03	102.58	102.7801	9462117.0
2009-10-02 13:00:00	SPY	ETF	102.78	103.08	102.76	102.98	7386380.0
2009-10-02 13:30:00	SPY	ETF	102.98	103.03	102.8	102.87	5770957.0
2009-10-02 14:00:00	SPY	ETF	102.87	103.03	102.72	102.932	6690810.0
2009-10-02 14:30:00	SPY	ETF	102.94	103.02	102.77	102.8	6581749.0
2009-10-02 15:00:00	SPY	ETF	102.79	102.85	102.61	102.62	8454952.0
2009-10-02 15:30:00	SPY	ETF	102.62	102.85	102.36	102.55	18998501.0
2009-10-02 16:00:00	SPY	ETF	102.55	103.02	102.2	102.59	5981751.0
2009-10-02 16:30:00	SPY	ETF	102.61	103.2767	102.57	102.68	3138618.0
2009-10-02 17:00:00	SPY	ETF	102.68	102.69	102.62	102.62	39394.0
2009-10-02 17:30:00	SPY	ETF	102.62	102.8	102.62	102.7	135503.0
2009-10-02 18:00:00	SPY	ETF	102.72	102.74	102.7	102.7	5500.0
2009-10-02 18:30:00	SPY	ETF	102.75	102.75	102.75	102.75	2100.0
2009-10-02 19:00:00	SPY	ETF	102.71	102.75	102.7	102.7	15898.0
2009-10-02 19:30:00	SPY	ETF	102.72	102.8	102.72	102.78	18808.0
2009-10-02 04:00:00	QQQ	ETF	41.01	41.01	40.99	40.99	600.0
2009-10-02 04:30:00	QQQ	ETF	41.0	41.01	40.99	41.01	1200.0
2009-10-02 05:30:00	QQQ	ETF	40.98	40.98	40.98	40.98	200.0
2009-10-02 06:00:00	QQQ	ETF	40.99	41.01	40.99	41.01	2200.0
2009-10-02 06:30:00	QQQ	ETF	41.05	41.05	41.05	41.05	5000.0
2009-10-02 07:00:00	QQQ	ETF	40.99	41.0	40.96	41.0	9207.0
2009-10-02 07:30:00	QQQ	ETF	41.0	41.05	41.0	41.04	40320.0
2009-10-02 08:00:00	QQQ	ETF	41.02	41.03	40.97	40.97	432851.0
2009-10-02 08:30:00	QQQ	ETF	40.91	40.95	40.63	40.66	5216004.0
2009-10-02 09:00:00	QQQ	ETF	40.66	40.82	40.64	40.72	4366525.0
2009-10-02 09:30:00	QQQ	ETF	40.72	41.09	40.72	41.0	27792378.0
2009-10-02 10:00:00	QQQ	ETF	40.99	41.2	40.93	41.18	21034152.0
2009-10-02 10:30:00	QQQ	ETF	41.18	41.25	40.98	41.008	11797118.0
2009-10-02 11:00:00	QQQ	ETF	41.01	41.05	40.96	40.97	8365484.0
2009-10-02 11:30:00	QQQ	ETF	40.98	41.09	40.87	40.93	6980081.0
2009-10-02 12:00:00	QQQ	ETF	40.92	41.1	40.92	41.09	5667128.0
2009-10-02 12:30:00	QQQ	ETF	41.1	41.15	40.97	41.0898	6894346.0
2009-10-02 13:00:00	QQQ	ETF	41.08	41.17	41.07	41.12	3614210.0

> showing 50 of 7,764 rows — these rows as CSV

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