PREVIEW / etf_30min / 2009-09-29

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-29.parquet
  size:    227 KB
  rows:    7,472

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-09-29 04:00:00	SPY	ETF	106.23	106.23	106.18	106.18	200.0
2009-09-29 04:30:00	SPY	ETF	106.14	106.14	106.14	106.14	100.0
2009-09-29 05:00:00	SPY	ETF	106.18	106.18	106.11	106.15	10400.0
2009-09-29 05:30:00	SPY	ETF	106.2	106.2	106.2	106.2	100.0
2009-09-29 06:00:00	SPY	ETF	106.21	106.26	106.11	106.11	11700.0
2009-09-29 06:30:00	SPY	ETF	106.1	106.2	106.1	106.17	9800.0
2009-09-29 07:00:00	SPY	ETF	106.16	106.26	106.12	106.22	53761.0
2009-09-29 07:30:00	SPY	ETF	106.25	106.38	106.19	106.19	56556.0
2009-09-29 08:00:00	SPY	ETF	106.18	106.35	106.08	106.34	968544.0
2009-09-29 08:30:00	SPY	ETF	106.33	106.38	106.26	106.36	696719.0
2009-09-29 09:00:00	SPY	ETF	106.36	106.77	106.03	106.5	1852062.0
2009-09-29 09:30:00	SPY	ETF	106.51	107.02	106.37	106.88	19315636.0
2009-09-29 10:00:00	SPY	ETF	106.88	106.938	106.01	106.39	26183192.0
2009-09-29 10:30:00	SPY	ETF	106.39	106.59	106.02	106.05	11228030.0
2009-09-29 11:00:00	SPY	ETF	106.05	106.2	105.9	106.19	8564550.0
2009-09-29 11:30:00	SPY	ETF	106.18	106.22	105.78	105.96	7015698.0
2009-09-29 12:00:00	SPY	ETF	105.96	106.2	105.95	106.02	5868083.0
2009-09-29 12:30:00	SPY	ETF	106.0101	106.33	106.01	106.32	4936604.0
2009-09-29 13:00:00	SPY	ETF	106.32	106.53	106.2944	106.44	6049886.0
2009-09-29 13:30:00	SPY	ETF	106.44	106.51	106.34	106.5017	4700097.0
2009-09-29 14:00:00	SPY	ETF	106.5	106.52	106.2311	106.33	5387012.0
2009-09-29 14:30:00	SPY	ETF	106.34	106.4	106.13	106.33	4834407.0
2009-09-29 15:00:00	SPY	ETF	106.34	106.43	106.16	106.16	6679325.0
2009-09-29 15:30:00	SPY	ETF	106.17	106.3429	106.01	106.02	13096847.0
2009-09-29 16:00:00	SPY	ETF	106.02	106.45	105.88	105.97	3228287.0
2009-09-29 16:30:00	SPY	ETF	105.95	105.97	105.88	105.94	197594.0
2009-09-29 17:00:00	SPY	ETF	105.94	105.99	105.85	105.92	265338.0
2009-09-29 17:30:00	SPY	ETF	105.9	105.94	105.89	105.94	79850.0
2009-09-29 18:00:00	SPY	ETF	105.92	106.03	105.9	105.98	138990.0
2009-09-29 18:30:00	SPY	ETF	105.96	105.97	105.94	105.97	3960.0
2009-09-29 19:00:00	SPY	ETF	105.97	105.97	105.94	105.97	4368.0
2009-09-29 19:30:00	SPY	ETF	105.97	106.04	105.95	106.03	28546.0
2009-09-29 04:00:00	QQQ	ETF	42.34	42.34	42.34	42.34	200.0
2009-09-29 04:30:00	QQQ	ETF	42.3	42.3	42.3	42.3	700.0
2009-09-29 05:00:00	QQQ	ETF	42.25	42.25	42.25	42.25	3000.0
2009-09-29 06:00:00	QQQ	ETF	42.31	42.32	42.24	42.24	25400.0
2009-09-29 06:30:00	QQQ	ETF	42.27	42.27	42.27	42.27	100.0
2009-09-29 07:00:00	QQQ	ETF	42.25	42.3	42.25	42.3	12906.0
2009-09-29 07:30:00	QQQ	ETF	42.32	42.32	42.27	42.28	141754.0
2009-09-29 08:00:00	QQQ	ETF	42.27	42.33	42.24	42.33	315687.0
2009-09-29 08:30:00	QQQ	ETF	42.33	42.36	42.32	42.36	52458.0
2009-09-29 09:00:00	QQQ	ETF	42.36	42.47	42.24	42.42	965995.0
2009-09-29 09:30:00	QQQ	ETF	42.41	42.6201	42.36	42.55	15105377.0
2009-09-29 10:00:00	QQQ	ETF	42.55	42.5651	42.13	42.33	24327975.0
2009-09-29 10:30:00	QQQ	ETF	42.34	42.39	42.13	42.13	7107327.0
2009-09-29 11:00:00	QQQ	ETF	42.13	42.2	42.08	42.2	4649376.0
2009-09-29 11:30:00	QQQ	ETF	42.2	42.22	42.03	42.1	2883574.0
2009-09-29 12:00:00	QQQ	ETF	42.09	42.19	42.09	42.1201	3211983.0
2009-09-29 12:30:00	QQQ	ETF	42.13	42.31	42.12	42.31	4473675.0
2009-09-29 13:00:00	QQQ	ETF	42.31	42.41	42.3001	42.3601	4013508.0

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

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