PREVIEW / etf_30min / 2010-06-15

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-15.parquet
  size:    260 KB
  rows:    8,439

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-06-15 04:00:00	SPY	ETF	109.84	109.93	109.84	109.93	800.0
2010-06-15 04:30:00	SPY	ETF	109.95	110.14	109.95	110.14	500.0
2010-06-15 05:00:00	SPY	ETF	110.02	110.2	109.84	110.12	13166.0
2010-06-15 05:30:00	SPY	ETF	110.14	110.5	110.14	110.45	8780.0
2010-06-15 06:00:00	SPY	ETF	110.42	110.47	110.34	110.34	1000.0
2010-06-15 06:30:00	SPY	ETF	110.37	110.39	110.32	110.32	49800.0
2010-06-15 07:00:00	SPY	ETF	110.33	110.4	110.08	110.13	176918.0
2010-06-15 07:30:00	SPY	ETF	110.14	110.25	110.1	110.25	89380.0
2010-06-15 08:00:00	SPY	ETF	110.23	110.43	109.4761	110.16	4323682.0
2010-06-15 08:30:00	SPY	ETF	110.17	110.42	109.48	110.21	3269384.0
2010-06-15 09:00:00	SPY	ETF	110.22	110.41	110.2	110.29	1433495.0
2010-06-15 09:30:00	SPY	ETF	110.28	110.67	110.09	110.51	28366912.0
2010-06-15 10:00:00	SPY	ETF	110.51	110.64	110.21	110.54	16603598.0
2010-06-15 10:30:00	SPY	ETF	110.54	110.8	110.47	110.7684	14049479.0
2010-06-15 11:00:00	SPY	ETF	110.77	110.85	110.61	110.69	10606100.0
2010-06-15 11:30:00	SPY	ETF	110.681	110.97	110.56	110.8617	8813389.0
2010-06-15 12:00:00	SPY	ETF	110.869	111.07	110.869	110.91	8222883.0
2010-06-15 12:30:00	SPY	ETF	110.91	111.06	110.77	111.04	9871176.0
2010-06-15 13:00:00	SPY	ETF	111.04	111.35	110.84	111.19	14201483.0
2010-06-15 13:30:00	SPY	ETF	111.185	111.36	111.1	111.33	8077991.0
2010-06-15 14:00:00	SPY	ETF	111.33	111.73	111.2	111.595	18132766.0
2010-06-15 14:30:00	SPY	ETF	111.59	111.63	111.45	111.5	12949974.0
2010-06-15 15:00:00	SPY	ETF	111.5	111.83	111.4	111.829	14901984.0
2010-06-15 15:30:00	SPY	ETF	111.82	112.1	111.7	111.98	38016997.0
2010-06-15 16:00:00	SPY	ETF	111.98	112.08	110.15	111.88	21426748.0
2010-06-15 16:30:00	SPY	ETF	111.88	111.88	111.74	111.81	2409008.0
2010-06-15 17:00:00	SPY	ETF	111.81	111.86	111.72	111.76	380641.0
2010-06-15 17:30:00	SPY	ETF	111.76	111.95	111.73	111.78	42964.0
2010-06-15 18:00:00	SPY	ETF	111.76	111.95	111.65	111.68	345247.0
2010-06-15 18:30:00	SPY	ETF	111.69	111.75	111.68	111.72	123526.0
2010-06-15 19:00:00	SPY	ETF	111.71	111.72	111.63	111.63	71318.0
2010-06-15 19:30:00	SPY	ETF	111.63	111.71	111.62	111.67	59614.0
2010-06-15 04:30:00	QQQ	ETF	45.78	45.78	45.78	45.78	200.0
2010-06-15 05:00:00	QQQ	ETF	45.72	45.72	45.72	45.72	100.0
2010-06-15 05:30:00	QQQ	ETF	45.8	45.93	45.8	45.93	7200.0
2010-06-15 06:00:00	QQQ	ETF	45.92	45.92	45.87	45.87	5800.0
2010-06-15 06:30:00	QQQ	ETF	45.87	45.89	45.85	45.88	65285.0
2010-06-15 07:00:00	QQQ	ETF	45.86	45.91	45.76	45.81	156742.0
2010-06-15 07:30:00	QQQ	ETF	45.79	45.83	45.78	45.8	92379.0
2010-06-15 08:00:00	QQQ	ETF	45.79	45.8	45.68	45.72	440958.0
2010-06-15 08:30:00	QQQ	ETF	45.71	45.84	45.64	45.66	2010489.0
2010-06-15 09:00:00	QQQ	ETF	45.67	45.77	45.66	45.72	3082725.0
2010-06-15 09:30:00	QQQ	ETF	45.72	46.21	45.68	46.13	10468110.0
2010-06-15 10:00:00	QQQ	ETF	46.13	46.1769	45.9562	46.1	7024933.0
2010-06-15 10:30:00	QQQ	ETF	46.095	46.2	46.07	46.18	3842496.0
2010-06-15 11:00:00	QQQ	ETF	46.19	46.22	46.1	46.14	2618556.0
2010-06-15 11:30:00	QQQ	ETF	46.14	46.31	46.0619	46.27	3340848.0
2010-06-15 12:00:00	QQQ	ETF	46.27	46.38	46.25	46.34	2885808.0
2010-06-15 12:30:00	QQQ	ETF	46.3475	46.37	46.25	46.36	3235311.0
2010-06-15 13:00:00	QQQ	ETF	46.36	46.49	45.4532	46.43	6537122.0

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

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