PREVIEW / etf_30min / 2009-12-18

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-18.parquet
  size:    233 KB
  rows:    7,787

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-12-18 04:00:00	SPY	ETF	109.9	110.39	109.9	110.39	800.0
2009-12-18 04:30:00	SPY	ETF	110.39	110.41	110.39	110.41	8338.0
2009-12-18 05:00:00	SPY	ETF	110.46	110.63	110.46	110.63	1641.0
2009-12-18 05:30:00	SPY	ETF	110.52	110.52	110.41	110.41	9600.0
2009-12-18 06:00:00	SPY	ETF	110.46	110.51	110.41	110.49	3150.0
2009-12-18 06:30:00	SPY	ETF	110.43	110.43	110.09	110.16	46932.0
2009-12-18 07:00:00	SPY	ETF	110.14	110.42	110.13	110.38	96333.0
2009-12-18 07:30:00	SPY	ETF	110.38	110.38	110.22	110.31	141722.0
2009-12-18 08:00:00	SPY	ETF	110.32	110.37	110.13	110.2	569094.0
2009-12-18 08:30:00	SPY	ETF	110.21	110.48	110.05	110.06	1342789.0
2009-12-18 09:00:00	SPY	ETF	110.05	110.21	110.03	110.2	1421291.0
2009-12-18 09:30:00	SPY	ETF	110.2	110.3	109.91	110.05	20104617.0
2009-12-18 10:00:00	SPY	ETF	110.05	110.2	109.84	109.95	11425330.0
2009-12-18 10:30:00	SPY	ETF	109.95	109.96	109.62	109.735	13599436.0
2009-12-18 11:00:00	SPY	ETF	109.74	109.78	109.28	109.44	13202104.0
2009-12-18 11:30:00	SPY	ETF	109.44	109.51	109.3	109.4799	9625171.0
2009-12-18 12:00:00	SPY	ETF	109.48	109.78	109.39	109.74	8000368.0
2009-12-18 12:30:00	SPY	ETF	109.74	109.85	109.5	109.8	9394692.0
2009-12-18 13:00:00	SPY	ETF	109.81	110.06	109.76	110.04	9169270.0
2009-12-18 13:30:00	SPY	ETF	110.035	110.05	109.84	109.9	6227452.0
2009-12-18 14:00:00	SPY	ETF	109.9	109.96	109.82	109.88	4630447.0
2009-12-18 14:30:00	SPY	ETF	109.87	109.99	109.79	109.95	5423474.0
2009-12-18 15:00:00	SPY	ETF	109.96	110.03	109.83	109.8375	7484826.0
2009-12-18 15:30:00	SPY	ETF	109.83	110.28	109.72	110.23	21862643.0
2009-12-18 16:00:00	SPY	ETF	110.24	110.34	109.34	110.32	20198704.0
2009-12-18 16:30:00	SPY	ETF	110.32	110.42	110.31	110.4	4459173.0
2009-12-18 17:00:00	SPY	ETF	110.4	110.45	110.38	110.4399	2454319.0
2009-12-18 17:30:00	SPY	ETF	110.41	110.52	110.4	110.41	291938.0
2009-12-18 18:00:00	SPY	ETF	110.41	110.47	110.4	110.4	478902.0
2009-12-18 18:30:00	SPY	ETF	110.41	110.52	110.16	110.29	1434470.0
2009-12-18 19:00:00	SPY	ETF	110.28	110.36	110.28	110.36	25652.0
2009-12-18 19:30:00	SPY	ETF	110.35	110.39	110.3	110.34	10435.0
2009-12-18 04:00:00	QQQ	ETF	44.13	44.13	44.13	44.13	200.0
2009-12-18 04:30:00	QQQ	ETF	44.13	44.13	44.13	44.13	200.0
2009-12-18 05:30:00	QQQ	ETF	44.17	44.17	44.11	44.11	7400.0
2009-12-18 06:00:00	QQQ	ETF	44.11	44.11	44.09	44.1	700.0
2009-12-18 06:30:00	QQQ	ETF	44.09	44.1	44.01	44.02	23600.0
2009-12-18 07:00:00	QQQ	ETF	44.02	44.1	44.01	44.09	15100.0
2009-12-18 07:30:00	QQQ	ETF	44.06	44.08	44.05	44.08	80277.0
2009-12-18 08:00:00	QQQ	ETF	44.08	44.1	44.0	44.04	887655.0
2009-12-18 08:30:00	QQQ	ETF	44.04	44.04	43.99	44.02	381836.0
2009-12-18 09:00:00	QQQ	ETF	44.02	44.17	44.01	44.15	1224964.0
2009-12-18 09:30:00	QQQ	ETF	44.15	44.34	44.01	44.2501	14979294.0
2009-12-18 10:00:00	QQQ	ETF	44.26	44.31	44.1701	44.22	6568390.0
2009-12-18 10:30:00	QQQ	ETF	44.2299	44.23	44.05	44.1299	5973193.0
2009-12-18 11:00:00	QQQ	ETF	44.13	44.16	44.0	44.041	7090893.0
2009-12-18 11:30:00	QQQ	ETF	44.04	44.11	44.01	44.09	4769900.0
2009-12-18 12:00:00	QQQ	ETF	44.09	44.22	44.06	44.2	4548722.0
2009-12-18 12:30:00	QQQ	ETF	44.2	44.29	44.1	44.28	7528779.0
2009-12-18 13:00:00	QQQ	ETF	44.27	44.37	44.2	44.36	9954067.0

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

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