PREVIEW / etf_30min / 2007-07-12

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-12.parquet
  size:    123 KB
  rows:    4,664

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
2007-07-12 05:00:00	SPY	ETF	152.18	152.18	152.18	152.18	2000.0
2007-07-12 06:00:00	SPY	ETF	152.04	152.06	152.04	152.06	29500.0
2007-07-12 06:30:00	SPY	ETF	151.98	152.06	151.98	152.03	106800.0
2007-07-12 07:00:00	SPY	ETF	152.11	152.16	152.08	152.08	64700.0
2007-07-12 07:30:00	SPY	ETF	152.16	152.46	152.16	152.45	739900.0
2007-07-12 08:00:00	SPY	ETF	152.44	152.5	152.03	152.42	514100.0
2007-07-12 08:30:00	SPY	ETF	152.44	152.53	152.32	152.45	1704500.0
2007-07-12 09:00:00	SPY	ETF	152.46	152.63	152.35	152.36	869500.0
2007-07-12 09:30:00	SPY	ETF	152.37	153.03	152.34	152.94	15843050.0
2007-07-12 10:00:00	SPY	ETF	152.94	153.03	152.71	152.8	10424188.0
2007-07-12 10:30:00	SPY	ETF	152.81	153.2	152.81	153.05	10352881.0
2007-07-12 11:00:00	SPY	ETF	153.05	153.13	152.97	153.07	5670600.0
2007-07-12 11:30:00	SPY	ETF	153.07	153.32	153.02	153.2	8059506.0
2007-07-12 12:00:00	SPY	ETF	153.21	153.62	153.2	153.58	9490209.0
2007-07-12 12:30:00	SPY	ETF	153.57	153.59	153.44	153.52	3993897.0
2007-07-12 13:00:00	SPY	ETF	153.51	153.65	153.48	153.61	4387900.0
2007-07-12 13:30:00	SPY	ETF	153.62	153.77	153.55	153.59	5937976.0
2007-07-12 14:00:00	SPY	ETF	153.6	153.64	153.35	153.52	7791200.0
2007-07-12 14:30:00	SPY	ETF	153.52	153.86	153.49	153.8	8126465.0
2007-07-12 15:00:00	SPY	ETF	153.8	154.15	152.7	154.13	8973403.0
2007-07-12 15:30:00	SPY	ETF	154.14	154.75	154.02	154.73	20282069.0
2007-07-12 16:00:00	SPY	ETF	154.72	154.72	154.35	154.36	2911700.0
2007-07-12 16:30:00	SPY	ETF	154.38	154.46	152.87	154.45	420900.0
2007-07-12 17:00:00	SPY	ETF	154.44	154.45	154.36	154.36	656100.0
2007-07-12 17:30:00	SPY	ETF	154.42	154.44	154.42	154.44	4200.0
2007-07-12 18:00:00	SPY	ETF	154.43	154.44	154.39	154.39	325800.0
2007-07-12 18:30:00	SPY	ETF	154.42	154.42	154.38	154.41	2000.0
2007-07-12 19:00:00	SPY	ETF	154.42	154.42	154.41	154.42	2400.0
2007-07-12 19:30:00	SPY	ETF	154.43	154.46	154.39	154.44	15700.0
2007-07-12 04:00:00	QQQ	ETF	48.87	48.87	48.87	48.87	500.0
2007-07-12 07:00:00	QQQ	ETF	48.93	48.93	48.89	48.92	110700.0
2007-07-12 07:30:00	QQQ	ETF	48.93	49.02	48.93	49.02	101261.0
2007-07-12 08:00:00	QQQ	ETF	49.01	49.06	49.01	49.04	909680.0
2007-07-12 08:30:00	QQQ	ETF	49.04	49.05	49.0	49.04	1041541.0
2007-07-12 09:00:00	QQQ	ETF	49.03	49.08	48.95	48.96	1257615.0
2007-07-12 09:30:00	QQQ	ETF	48.97	49.07	48.92	49.05	15829162.0
2007-07-12 10:00:00	QQQ	ETF	49.05	49.09	48.94	48.965	4954119.0
2007-07-12 10:30:00	QQQ	ETF	48.9615	49.1	48.95	49.0515	5281628.0
2007-07-12 11:00:00	QQQ	ETF	49.06	49.12	49.04	49.08	8864837.0
2007-07-12 11:30:00	QQQ	ETF	49.08	49.17	49.05	49.12	6465171.0
2007-07-12 12:00:00	QQQ	ETF	49.11	49.27	49.11	49.269	6742407.0
2007-07-12 12:30:00	QQQ	ETF	49.26	49.29	49.21	49.27	3948261.0
2007-07-12 13:00:00	QQQ	ETF	49.27	49.3	49.24	49.28	2588884.0
2007-07-12 13:30:00	QQQ	ETF	49.29	49.36	49.26	49.3	6939458.0
2007-07-12 14:00:00	QQQ	ETF	49.3	49.31	49.23	49.29	5142984.0
2007-07-12 14:30:00	QQQ	ETF	49.28	49.42	49.27	49.4	5021349.0
2007-07-12 15:00:00	QQQ	ETF	49.3989	49.51	49.38	49.51	7375915.0
2007-07-12 15:30:00	QQQ	ETF	49.51	49.67	49.5	49.66	17836753.0
2007-07-12 16:00:00	QQQ	ETF	49.66	49.67	49.54	49.58	1247180.0
2007-07-12 16:30:00	QQQ	ETF	49.57	49.58	49.55	49.57	89382.0

> showing 50 of 4,664 rows — these rows as CSV

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