PREVIEW / etf_30min / 2009-12-14

all etf 30-min files

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

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-14 04:00:00	SPY	ETF	111.66	111.76	111.66	111.76	2600.0
2009-12-14 05:00:00	SPY	ETF	111.83	111.91	111.83	111.91	1800.0
2009-12-14 05:30:00	SPY	ETF	111.82	111.82	111.74	111.74	2400.0
2009-12-14 06:00:00	SPY	ETF	111.75	111.77	111.75	111.77	2190.0
2009-12-14 06:30:00	SPY	ETF	111.73	111.75	111.63	111.75	8400.0
2009-12-14 07:00:00	SPY	ETF	111.75	111.88	111.74	111.86	108964.0
2009-12-14 07:30:00	SPY	ETF	111.84	111.84	111.76	111.83	133134.0
2009-12-14 08:00:00	SPY	ETF	111.82	111.95	111.4	111.92	829170.0
2009-12-14 08:30:00	SPY	ETF	111.92	112.17	111.07	111.81	503867.0
2009-12-14 09:00:00	SPY	ETF	111.8	111.93	111.8	111.86	942435.0
2009-12-14 09:30:00	SPY	ETF	111.87	111.88	111.54	111.611	13980806.0
2009-12-14 10:00:00	SPY	ETF	111.62	111.63	111.37	111.55	10453155.0
2009-12-14 10:30:00	SPY	ETF	111.56	111.76	111.47	111.63	9113252.0
2009-12-14 11:00:00	SPY	ETF	111.64	111.81	111.55	111.77	5371393.0
2009-12-14 11:30:00	SPY	ETF	111.7701	111.92	111.7	111.77	5301330.0
2009-12-14 12:00:00	SPY	ETF	111.77	111.86	111.74	111.8399	4057252.0
2009-12-14 12:30:00	SPY	ETF	111.83	112.0	111.82	111.88	5499603.0
2009-12-14 13:00:00	SPY	ETF	111.88	111.9	111.65	111.8	4973873.0
2009-12-14 13:30:00	SPY	ETF	111.81	111.84	111.63	111.8	14374814.0
2009-12-14 14:00:00	SPY	ETF	111.809	111.86	111.74	111.77	3020305.0
2009-12-14 14:30:00	SPY	ETF	111.77	111.91	111.72	111.81	5448134.0
2009-12-14 15:00:00	SPY	ETF	111.82	111.91	111.74	111.8	4327711.0
2009-12-14 15:30:00	SPY	ETF	111.8	111.94	111.795	111.88	11246541.0
2009-12-14 16:00:00	SPY	ETF	111.88	111.9054	111.46	111.78	4148177.0
2009-12-14 16:30:00	SPY	ETF	111.78	111.82	111.1317	111.73	2110381.0
2009-12-14 17:00:00	SPY	ETF	111.73	111.76	111.69	111.74	67332.0
2009-12-14 17:30:00	SPY	ETF	111.7	111.75	111.69	111.75	12450.0
2009-12-14 18:00:00	SPY	ETF	111.73	111.87	111.59	111.68	419841.0
2009-12-14 18:30:00	SPY	ETF	111.68	111.74	111.66	111.72	13822.0
2009-12-14 19:00:00	SPY	ETF	111.72	111.72	111.67	111.71	19007.0
2009-12-14 19:30:00	SPY	ETF	111.71	111.81	111.71	111.8	34185.0
2009-12-14 04:00:00	QQQ	ETF	44.4	44.4	44.4	44.4	150.0
2009-12-14 06:00:00	QQQ	ETF	44.39	44.39	44.39	44.39	100.0
2009-12-14 06:30:00	QQQ	ETF	44.35	44.39	44.35	44.39	700.0
2009-12-14 07:00:00	QQQ	ETF	44.39	44.46	44.39	44.46	13080.0
2009-12-14 07:30:00	QQQ	ETF	44.41	44.43	44.39	44.42	45050.0
2009-12-14 08:00:00	QQQ	ETF	44.42	44.49	44.13	44.46	217817.0
2009-12-14 08:30:00	QQQ	ETF	44.45	44.5	44.43	44.45	86563.0
2009-12-14 09:00:00	QQQ	ETF	44.44	44.46	44.41	44.43	600344.0
2009-12-14 09:30:00	QQQ	ETF	44.43	44.45	44.33	44.36	6680058.0
2009-12-14 10:00:00	QQQ	ETF	44.36	44.38	44.19	44.3199	6245732.0
2009-12-14 10:30:00	QQQ	ETF	44.32	44.4	44.27	44.3674	5061051.0
2009-12-14 11:00:00	QQQ	ETF	44.37	44.47	44.35	44.46	2596670.0
2009-12-14 11:30:00	QQQ	ETF	44.45	44.509	44.4	44.42	2732439.0
2009-12-14 12:00:00	QQQ	ETF	44.424	44.5	44.42	44.499	2731288.0
2009-12-14 12:30:00	QQQ	ETF	44.49	44.6	44.2448	44.54	2908515.0
2009-12-14 13:00:00	QQQ	ETF	44.54	44.55	44.5	44.53	1675482.0
2009-12-14 13:30:00	QQQ	ETF	44.53	44.54	44.45	44.5315	1639339.0
2009-12-14 14:00:00	QQQ	ETF	44.531	44.56	44.48	44.4974	1188930.0
2009-12-14 14:30:00	QQQ	ETF	44.49	44.57	44.49	44.54	3264320.0

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

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