PREVIEW / etf_30min / 2010-02-17

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-17.parquet
  size:    243 KB
  rows:    8,203

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
2010-02-17 04:00:00	SPY	ETF	110.19	110.2	110.16	110.16	4200.0
2010-02-17 04:30:00	SPY	ETF	110.15	110.29	110.15	110.23	2461.0
2010-02-17 05:00:00	SPY	ETF	110.15	110.2	110.1	110.1	9100.0
2010-02-17 05:30:00	SPY	ETF	110.14	110.14	110.12	110.12	20000.0
2010-02-17 06:00:00	SPY	ETF	110.11	110.11	110.0	110.0	7600.0
2010-02-17 06:30:00	SPY	ETF	110.02	110.2	110.02	110.2	64600.0
2010-02-17 07:00:00	SPY	ETF	110.13	110.23	110.08	110.23	405391.0
2010-02-17 07:30:00	SPY	ETF	110.2	110.44	110.2	110.38	520839.0
2010-02-17 08:00:00	SPY	ETF	110.38	110.41	110.11	110.32	1653049.0
2010-02-17 08:30:00	SPY	ETF	110.33	110.45	110.26	110.36	1515736.0
2010-02-17 09:00:00	SPY	ETF	110.37	110.38	110.21	110.27	1834973.0
2010-02-17 09:30:00	SPY	ETF	110.27	110.34	110.0	110.12	24995165.0
2010-02-17 10:00:00	SPY	ETF	110.12	110.29	109.93	110.27	15205439.0
2010-02-17 10:30:00	SPY	ETF	110.27	110.41	110.06	110.11	17318740.0
2010-02-17 11:00:00	SPY	ETF	110.1	110.15	109.85	109.89	13802037.0
2010-02-17 11:30:00	SPY	ETF	109.89	110.08	109.74	109.97	12943044.0
2010-02-17 12:00:00	SPY	ETF	109.98	110.22	109.975	110.18	7562707.0
2010-02-17 12:30:00	SPY	ETF	110.175	110.21	110.02	110.18	4829537.0
2010-02-17 13:00:00	SPY	ETF	110.19	110.29	109.8	110.18	5629155.0
2010-02-17 13:30:00	SPY	ETF	110.18	110.19	110.02	110.11	5089194.0
2010-02-17 14:00:00	SPY	ETF	110.11	110.24	109.85	110.02	14410044.0
2010-02-17 14:30:00	SPY	ETF	110.02	110.22	109.97	110.21	6262344.0
2010-02-17 15:00:00	SPY	ETF	110.205	110.31	110.12	110.18	8119421.0
2010-02-17 15:30:00	SPY	ETF	110.18	110.34	110.1	110.26	15956518.0
2010-02-17 16:00:00	SPY	ETF	110.26	110.44	109.0215	110.43	8520689.0
2010-02-17 16:30:00	SPY	ETF	110.43	110.46	109.7731	110.35	1702777.0
2010-02-17 17:00:00	SPY	ETF	110.36	110.46	110.35	110.43	110606.0
2010-02-17 17:30:00	SPY	ETF	110.43	110.43	110.26	110.4	44753.0
2010-02-17 18:00:00	SPY	ETF	110.4	110.4	110.35	110.35	49417.0
2010-02-17 18:30:00	SPY	ETF	110.35	110.39	110.34	110.34	15004.0
2010-02-17 19:00:00	SPY	ETF	110.35	110.36	110.3	110.3	66445.0
2010-02-17 19:30:00	SPY	ETF	110.3	110.31	110.18	110.2	104199.0
2010-02-17 04:00:00	QQQ	ETF	44.44	44.44	44.44	44.44	750.0
2010-02-17 04:30:00	QQQ	ETF	44.45	44.46	44.45	44.46	1400.0
2010-02-17 05:00:00	QQQ	ETF	44.43	44.43	44.43	44.43	500.0
2010-02-17 05:30:00	QQQ	ETF	44.41	44.41	44.41	44.41	500.0
2010-02-17 06:00:00	QQQ	ETF	44.4	44.4	44.4	44.4	100.0
2010-02-17 07:00:00	QQQ	ETF	44.39	44.39	44.33	44.38	509530.0
2010-02-17 07:30:00	QQQ	ETF	44.38	44.6	44.38	44.47	523895.0
2010-02-17 08:00:00	QQQ	ETF	44.36	44.48	44.35	44.46	793418.0
2010-02-17 08:30:00	QQQ	ETF	44.47	44.55	44.44	44.51	2805336.0
2010-02-17 09:00:00	QQQ	ETF	44.52	44.55	44.47	44.49	2789564.0
2010-02-17 09:30:00	QQQ	ETF	44.5	44.55	44.33	44.43	12340017.0
2010-02-17 10:00:00	QQQ	ETF	44.44	44.53	44.39	44.5	5994882.0
2010-02-17 10:30:00	QQQ	ETF	44.495	44.57	44.44	44.505	9045840.0
2010-02-17 11:00:00	QQQ	ETF	44.51	44.51	44.29	44.31	8573992.0
2010-02-17 11:30:00	QQQ	ETF	44.31	44.38	44.26	44.37	4726306.0
2010-02-17 12:00:00	QQQ	ETF	44.37	44.45	44.35	44.44	2810820.0
2010-02-17 12:30:00	QQQ	ETF	44.44	44.47	44.39	44.45	2159020.0
2010-02-17 13:00:00	QQQ	ETF	44.46	44.525	44.45	44.5099	2507182.0

> showing 50 of 8,203 rows — these rows as CSV

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