PREVIEW / etf_30min / 2010-01-13

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-13.parquet
  size:    241 KB
  rows:    7,975

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-01-13 04:00:00	SPY	ETF	114.08	114.08	114.08	114.08	1000.0
2010-01-13 04:30:00	SPY	ETF	114.03	114.03	114.03	114.03	250.0
2010-01-13 05:00:00	SPY	ETF	113.95	113.95	113.95	113.95	15100.0
2010-01-13 05:30:00	SPY	ETF	113.92	113.92	113.9	113.9	10480.0
2010-01-13 06:30:00	SPY	ETF	113.94	113.94	113.94	113.94	100.0
2010-01-13 07:00:00	SPY	ETF	113.88	114.1	113.88	114.1	395922.0
2010-01-13 07:30:00	SPY	ETF	114.07	114.15	114.05	114.09	216501.0
2010-01-13 08:00:00	SPY	ETF	114.09	114.18	113.9	114.08	554408.0
2010-01-13 08:30:00	SPY	ETF	114.08	114.1	113.98	113.99	617788.0
2010-01-13 09:00:00	SPY	ETF	114.0	114.01	113.93	113.95	1056701.0
2010-01-13 09:30:00	SPY	ETF	113.95	114.11	113.79	113.83	16562788.0
2010-01-13 10:00:00	SPY	ETF	113.83	113.88	113.39	113.49	15439265.0
2010-01-13 10:30:00	SPY	ETF	113.48	113.72	113.37	113.72	12930486.0
2010-01-13 11:00:00	SPY	ETF	113.72	114.03	113.64	113.99	12471438.0
2010-01-13 11:30:00	SPY	ETF	113.99	114.13	113.9	114.05	8601618.0
2010-01-13 12:00:00	SPY	ETF	114.05	114.39	113.65	114.31	12730550.0
2010-01-13 12:30:00	SPY	ETF	114.31	114.54	114.27	114.3501	8996474.0
2010-01-13 13:00:00	SPY	ETF	114.35	114.51	114.28	114.4	6246071.0
2010-01-13 13:30:00	SPY	ETF	114.4	114.49	114.28	114.32	7718903.0
2010-01-13 14:00:00	SPY	ETF	114.31	114.51	114.29	114.39	8076596.0
2010-01-13 14:30:00	SPY	ETF	114.4	114.68	114.4	114.67	9607793.0
2010-01-13 15:00:00	SPY	ETF	114.67	114.8	114.54	114.75	8370453.0
2010-01-13 15:30:00	SPY	ETF	114.75	114.94	114.62	114.64	18764640.0
2010-01-13 16:00:00	SPY	ETF	114.63	114.9298	113.56	114.62	6914313.0
2010-01-13 16:30:00	SPY	ETF	114.61	114.64	113.6914	114.62	1061567.0
2010-01-13 17:00:00	SPY	ETF	114.62	114.64	113.61	114.59	561104.0
2010-01-13 17:30:00	SPY	ETF	114.6	114.6	114.57	114.59	8528.0
2010-01-13 18:00:00	SPY	ETF	114.58	114.61	114.56	114.6	17843.0
2010-01-13 18:30:00	SPY	ETF	114.6	114.61	114.6	114.61	7971.0
2010-01-13 19:00:00	SPY	ETF	114.64	114.66	114.62	114.63	10100.0
2010-01-13 19:30:00	SPY	ETF	114.65	114.82	114.65	114.82	55663.0
2010-01-13 04:00:00	QQQ	ETF	45.99	45.99	45.99	45.99	100.0
2010-01-13 04:30:00	QQQ	ETF	45.97	45.97	45.97	45.97	800.0
2010-01-13 07:00:00	QQQ	ETF	45.92	45.97	45.9	45.97	175970.0
2010-01-13 07:30:00	QQQ	ETF	45.98	46.01	45.97	45.98	41614.0
2010-01-13 08:00:00	QQQ	ETF	45.98	46.03	45.96	45.98	199621.0
2010-01-13 08:30:00	QQQ	ETF	45.99	45.99	45.93	45.93	178969.0
2010-01-13 09:00:00	QQQ	ETF	45.93	45.97	45.91	45.93	471833.0
2010-01-13 09:30:00	QQQ	ETF	45.93	46.08	45.82	45.835	10141508.0
2010-01-13 10:00:00	QQQ	ETF	45.84	45.87	45.61	45.7	11606951.0
2010-01-13 10:30:00	QQQ	ETF	45.7	45.855	45.65	45.83	6440971.0
2010-01-13 11:00:00	QQQ	ETF	45.83	45.9	45.76	45.9	5114210.0
2010-01-13 11:30:00	QQQ	ETF	45.9	45.94	45.83	45.87	3113860.0
2010-01-13 12:00:00	QQQ	ETF	45.875	46.11	45.87	46.08	6192757.0
2010-01-13 12:30:00	QQQ	ETF	46.08	46.22	46.06	46.16	6835572.0
2010-01-13 13:00:00	QQQ	ETF	46.16	46.22	46.11	46.21	3025315.0
2010-01-13 13:30:00	QQQ	ETF	46.22	46.3	46.2	46.23	6195796.0
2010-01-13 14:00:00	QQQ	ETF	46.24	46.3	46.22	46.29	3605712.0
2010-01-13 14:30:00	QQQ	ETF	46.29	46.39	46.28	46.39	5474306.0
2010-01-13 15:00:00	QQQ	ETF	46.39	46.41	46.3	46.3899	4733319.0

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

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