PREVIEW / etf_30min / 2008-11-03

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-03.parquet
  size:    172 KB
  rows:    6,154

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
2008-11-03 04:00:00	SPY	ETF	97.3	97.3	97.3	97.3	100.0
2008-11-03 04:30:00	SPY	ETF	97.39	97.41	97.18	97.18	3038.0
2008-11-03 05:00:00	SPY	ETF	97.14	97.21	97.0	97.0	600.0
2008-11-03 05:30:00	SPY	ETF	96.96	96.96	96.79	96.86	1400.0
2008-11-03 06:00:00	SPY	ETF	96.83	96.92	96.79	96.92	400.0
2008-11-03 06:30:00	SPY	ETF	96.89	97.41	96.89	97.32	28700.0
2008-11-03 07:00:00	SPY	ETF	97.41	97.63	97.3	97.35	244213.0
2008-11-03 07:30:00	SPY	ETF	97.35	97.44	97.16	97.19	588347.0
2008-11-03 08:00:00	SPY	ETF	97.55	98.15	96.51	96.75	1741637.0
2008-11-03 08:30:00	SPY	ETF	96.75	96.83	96.6	96.68	1174449.0
2008-11-03 09:00:00	SPY	ETF	96.69	96.77	96.51	96.75	827141.0
2008-11-03 09:30:00	SPY	ETF	96.78	97.69	96.42	96.98	25111678.0
2008-11-03 10:00:00	SPY	ETF	96.98	97.33	96.44	96.51	26660582.0
2008-11-03 10:30:00	SPY	ETF	96.51	97.32	96.3	96.97	15948533.0
2008-11-03 11:00:00	SPY	ETF	96.97	97.2	96.6	96.9	8385848.0
2008-11-03 11:30:00	SPY	ETF	96.89	97.46	96.84	97.32	9768420.0
2008-11-03 12:00:00	SPY	ETF	97.3285	97.42	97.04	97.27	10477359.0
2008-11-03 12:30:00	SPY	ETF	97.27	97.38	96.76	96.84	7663654.0
2008-11-03 13:00:00	SPY	ETF	96.83	97.22	96.73	96.79	7253746.0
2008-11-03 13:30:00	SPY	ETF	96.78	96.97	96.39	96.52	8581283.0
2008-11-03 14:00:00	SPY	ETF	96.5299	96.76	96.0	96.43	22054136.0
2008-11-03 14:30:00	SPY	ETF	96.43	96.68	96.2	96.25	8824402.0
2008-11-03 15:00:00	SPY	ETF	96.25	96.75	95.95	96.43	15478696.0
2008-11-03 15:30:00	SPY	ETF	96.45	97.22	96.3	96.76	24380071.0
2008-11-03 16:00:00	SPY	ETF	96.71	97.21	96.402	97.16	6111974.0
2008-11-03 16:30:00	SPY	ETF	97.16	97.3	96.9587	97.25	2150274.0
2008-11-03 17:00:00	SPY	ETF	97.23	97.3	96.91	97.2	1542143.0
2008-11-03 17:30:00	SPY	ETF	97.25	97.3	97.23	97.29	35290.0
2008-11-03 18:00:00	SPY	ETF	97.24	97.35	97.15	97.28	66977.0
2008-11-03 18:30:00	SPY	ETF	97.23	97.26	96.97	97.0	46247.0
2008-11-03 19:00:00	SPY	ETF	97.09	97.35	96.92	96.92	43450.0
2008-11-03 19:30:00	SPY	ETF	96.94	96.96	96.69	96.88	33476.0
2008-11-03 05:00:00	QQQ	ETF	32.87	32.9	32.87	32.9	600.0
2008-11-03 05:30:00	QQQ	ETF	32.88	32.92	32.88	32.92	1500.0
2008-11-03 06:00:00	QQQ	ETF	32.78	32.78	32.69	32.73	16539.0
2008-11-03 06:30:00	QQQ	ETF	32.73	32.79	32.73	32.79	1400.0
2008-11-03 07:00:00	QQQ	ETF	32.86	32.96	32.86	32.88	46700.0
2008-11-03 07:30:00	QQQ	ETF	32.91	32.94	32.85	32.88	171264.0
2008-11-03 08:00:00	QQQ	ETF	33.15	33.45	32.78	32.87	1961801.0
2008-11-03 08:30:00	QQQ	ETF	32.86	32.88	32.75	32.85	1146236.0
2008-11-03 09:00:00	QQQ	ETF	32.84	32.85	32.73	32.8	795102.0
2008-11-03 09:30:00	QQQ	ETF	32.81	33.12	32.67	32.97	17713348.0
2008-11-03 10:00:00	QQQ	ETF	32.97	33.14	32.8	32.88	15690919.0
2008-11-03 10:30:00	QQQ	ETF	32.88	33.0301	32.79	32.932	8960391.0
2008-11-03 11:00:00	QQQ	ETF	32.94	33.01	32.82	32.9	5007039.0
2008-11-03 11:30:00	QQQ	ETF	32.91	33.2941	32.88	33.01	7038129.0
2008-11-03 12:00:00	QQQ	ETF	33.01	33.08	32.97	33.0495	7103674.0
2008-11-03 12:30:00	QQQ	ETF	33.05	33.09	32.94	32.98	7571470.0
2008-11-03 13:00:00	QQQ	ETF	32.9874	33.1	32.9	32.92	3858349.0
2008-11-03 13:30:00	QQQ	ETF	32.91	32.98	32.82	32.85	4710082.0

> showing 50 of 6,154 rows — these rows as CSV

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