PREVIEW / etf_30min / 2009-11-02

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-02.parquet
  size:    238 KB
  rows:    7,893

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-11-02 04:00:00	SPY	ETF	104.35	104.37	104.29	104.3	2413.0
2009-11-02 04:30:00	SPY	ETF	104.43	104.49	104.25	104.25	600.0
2009-11-02 05:00:00	SPY	ETF	104.43	104.43	104.4	104.4	3500.0
2009-11-02 05:30:00	SPY	ETF	104.35	104.49	104.35	104.48	5000.0
2009-11-02 06:00:00	SPY	ETF	104.35	104.46	104.35	104.46	8527.0
2009-11-02 06:30:00	SPY	ETF	104.46	104.52	104.35	104.47	22209.0
2009-11-02 07:00:00	SPY	ETF	104.41	104.47	104.24	104.36	223780.0
2009-11-02 07:30:00	SPY	ETF	104.34	104.36	104.16	104.24	446731.0
2009-11-02 08:00:00	SPY	ETF	103.85	104.57	103.85	104.33	353422.0
2009-11-02 08:30:00	SPY	ETF	104.33	104.35	104.15	104.17	400114.0
2009-11-02 09:00:00	SPY	ETF	104.16	104.25	103.56	104.13	1565480.0
2009-11-02 09:30:00	SPY	ETF	104.13	104.52	103.86	104.44	29938399.0
2009-11-02 10:00:00	SPY	ETF	104.44	105.37	104.345	105.179	37193655.0
2009-11-02 10:30:00	SPY	ETF	105.18	105.41	104.66	104.7	15433577.0
2009-11-02 11:00:00	SPY	ETF	104.69	105.18	104.57	104.92	14457419.0
2009-11-02 11:30:00	SPY	ETF	104.92	105.1	104.75	104.9	6857707.0
2009-11-02 12:00:00	SPY	ETF	104.9	104.95	104.4	104.44	8768860.0
2009-11-02 12:30:00	SPY	ETF	104.44	104.52	103.15	103.17	25508296.0
2009-11-02 13:00:00	SPY	ETF	103.17	104.88	103.08	103.9	15496953.0
2009-11-02 13:30:00	SPY	ETF	103.9	103.915	103.22	103.26	12229367.0
2009-11-02 14:00:00	SPY	ETF	103.25	104.02	103.08	104.01	18181281.0
2009-11-02 14:30:00	SPY	ETF	104.0	104.22	103.7	103.92	16965664.0
2009-11-02 15:00:00	SPY	ETF	103.92	104.17	103.62	103.86	13775297.0
2009-11-02 15:30:00	SPY	ETF	103.86	104.49	103.83	104.36	25790700.0
2009-11-02 16:00:00	SPY	ETF	104.32	105.16	103.45	104.42	9874014.0
2009-11-02 16:30:00	SPY	ETF	104.43	104.63	104.41	104.57	306035.0
2009-11-02 17:00:00	SPY	ETF	104.57	104.64	104.54	104.57	155547.0
2009-11-02 17:30:00	SPY	ETF	104.54	104.54	104.5	104.5	38050.0
2009-11-02 18:00:00	SPY	ETF	104.54	104.56	104.49	104.5	71568.0
2009-11-02 18:30:00	SPY	ETF	104.49	104.57	104.48	104.49	43872.0
2009-11-02 19:00:00	SPY	ETF	104.52	104.84	104.52	104.75	118403.0
2009-11-02 19:30:00	SPY	ETF	104.74	104.8	104.68	104.76	104451.0
2009-11-02 04:00:00	QQQ	ETF	41.14	41.14	41.12	41.12	900.0
2009-11-02 04:30:00	QQQ	ETF	41.19	41.19	41.16	41.16	219.0
2009-11-02 05:00:00	QQQ	ETF	41.11	41.11	41.11	41.11	100.0
2009-11-02 05:30:00	QQQ	ETF	41.17	41.17	41.17	41.17	100.0
2009-11-02 06:30:00	QQQ	ETF	41.19	41.19	41.13	41.13	10100.0
2009-11-02 07:00:00	QQQ	ETF	41.16	41.16	41.1	41.12	81700.0
2009-11-02 07:30:00	QQQ	ETF	41.09	41.09	41.05	41.09	29863.0
2009-11-02 08:00:00	QQQ	ETF	40.97	41.21	40.97	41.11	262582.0
2009-11-02 08:30:00	QQQ	ETF	41.11	41.15	40.96	41.09	166857.0
2009-11-02 09:00:00	QQQ	ETF	41.1	41.12	40.96	41.01	555964.0
2009-11-02 09:30:00	QQQ	ETF	41.01	41.13	40.77	41.04	17921219.0
2009-11-02 10:00:00	QQQ	ETF	41.03	41.5	41.03	41.43	22381376.0
2009-11-02 10:30:00	QQQ	ETF	41.44	41.57	41.23	41.25	13763508.0
2009-11-02 11:00:00	QQQ	ETF	41.25	41.43	41.2	41.34	8375180.0
2009-11-02 11:30:00	QQQ	ETF	41.35	41.45	41.3	41.361	4094223.0
2009-11-02 12:00:00	QQQ	ETF	41.361	41.385	41.2	41.231	5410071.0
2009-11-02 12:30:00	QQQ	ETF	41.23	41.2699	40.73	40.782	14298659.0
2009-11-02 13:00:00	QQQ	ETF	40.78	41.06	40.75	41.03	8985348.0

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

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