PREVIEW / etf_30min / 2009-07-23

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-23.parquet
  size:    242 KB
  rows:    7,846

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-07-23 04:00:00	SPY	ETF	95.66	95.66	95.66	95.66	350.0
2009-07-23 04:30:00	SPY	ETF	95.72	95.75	95.72	95.72	3500.0
2009-07-23 05:00:00	SPY	ETF	95.81	95.81	95.81	95.81	100.0
2009-07-23 05:30:00	SPY	ETF	95.75	95.75	95.75	95.75	100.0
2009-07-23 06:00:00	SPY	ETF	95.72	95.76	95.72	95.76	5200.0
2009-07-23 06:30:00	SPY	ETF	95.69	95.69	95.48	95.59	26500.0
2009-07-23 07:00:00	SPY	ETF	95.52	95.69	95.52	95.66	155428.0
2009-07-23 07:30:00	SPY	ETF	95.67	95.98	95.67	95.87	587308.0
2009-07-23 08:00:00	SPY	ETF	95.88	96.02	95.83	95.92	954485.0
2009-07-23 08:30:00	SPY	ETF	95.93	96.08	95.66	95.67	2645355.0
2009-07-23 09:00:00	SPY	ETF	95.67	95.71	95.55	95.61	1999494.0
2009-07-23 09:30:00	SPY	ETF	95.61	96.41	95.53	96.35	23961419.0
2009-07-23 10:00:00	SPY	ETF	96.36	97.0	96.17	96.83	29896430.0
2009-07-23 10:30:00	SPY	ETF	96.82	97.32	96.82	97.16	20698150.0
2009-07-23 11:00:00	SPY	ETF	97.16	97.74	96.9	97.62	19088056.0
2009-07-23 11:30:00	SPY	ETF	97.62	97.78	97.48	97.52	11709795.0
2009-07-23 12:00:00	SPY	ETF	97.52	97.73	97.51	97.72	8249443.0
2009-07-23 12:30:00	SPY	ETF	97.7203	97.89	97.58	97.87	10824025.0
2009-07-23 13:00:00	SPY	ETF	97.87	97.91	96.88	97.81	8248303.0
2009-07-23 13:30:00	SPY	ETF	97.8126	98.06	97.74	97.75	11863493.0
2009-07-23 14:00:00	SPY	ETF	97.75	98.0	97.67	97.77	11365445.0
2009-07-23 14:30:00	SPY	ETF	97.77	97.95	97.74	97.89	12855632.0
2009-07-23 15:00:00	SPY	ETF	97.89	98.08	97.86	97.97	15608169.0
2009-07-23 15:30:00	SPY	ETF	97.96	97.97	97.48	97.68	37864438.0
2009-07-23 16:00:00	SPY	ETF	97.68	97.8	95.5222	96.9	16101943.0
2009-07-23 16:30:00	SPY	ETF	96.9	97.05	96.81	96.83	12035475.0
2009-07-23 17:00:00	SPY	ETF	96.83	96.9	96.72	96.89	858572.0
2009-07-23 17:30:00	SPY	ETF	96.81	96.9	96.7	96.82	278070.0
2009-07-23 18:00:00	SPY	ETF	96.84	96.91	96.8	96.89	286985.0
2009-07-23 18:30:00	SPY	ETF	96.9	96.96	96.9	96.94	18828.0
2009-07-23 19:00:00	SPY	ETF	96.94	96.97	96.92	96.95	27558.0
2009-07-23 19:30:00	SPY	ETF	96.95	96.97	96.9	96.92	44752.0
2009-07-23 04:00:00	QQQ	ETF	38.45	38.45	38.45	38.45	400.0
2009-07-23 04:30:00	QQQ	ETF	38.48	38.5	38.48	38.5	2300.0
2009-07-23 05:00:00	QQQ	ETF	38.47	38.47	38.47	38.47	200.0
2009-07-23 06:00:00	QQQ	ETF	38.48	38.5	38.48	38.5	10000.0
2009-07-23 06:30:00	QQQ	ETF	38.42	38.44	38.36	38.4	13700.0
2009-07-23 07:00:00	QQQ	ETF	38.43	38.45	38.39	38.43	30451.0
2009-07-23 07:30:00	QQQ	ETF	38.44	38.54	38.44	38.48	259270.0
2009-07-23 08:00:00	QQQ	ETF	38.48	38.56	38.45	38.47	860246.0
2009-07-23 08:30:00	QQQ	ETF	38.48	38.52	38.41	38.41	809325.0
2009-07-23 09:00:00	QQQ	ETF	38.41	38.45	38.38	38.45	993742.0
2009-07-23 09:30:00	QQQ	ETF	38.45	38.84	38.39	38.82	18568537.0
2009-07-23 10:00:00	QQQ	ETF	38.82	39.02	38.74	38.9665	15860743.0
2009-07-23 10:30:00	QQQ	ETF	38.9626	39.14	38.93	39.045	13736936.0
2009-07-23 11:00:00	QQQ	ETF	39.05	39.29	39.04	39.23	12365742.0
2009-07-23 11:30:00	QQQ	ETF	39.23	39.35	39.18	39.24	6224779.0
2009-07-23 12:00:00	QQQ	ETF	39.2301	39.31	39.23	39.3	5479226.0
2009-07-23 12:30:00	QQQ	ETF	39.31	39.42	39.25	39.41	6261533.0
2009-07-23 13:00:00	QQQ	ETF	39.4001	39.42	38.98	39.39	3111363.0

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

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