PREVIEW / etf_30min / 2009-10-19

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-19.parquet
  size:    235 KB
  rows:    7,842

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-10-19 04:00:00	SPY	ETF	109.28	109.28	109.23	109.27	2600.0
2009-10-19 04:30:00	SPY	ETF	109.23	109.23	109.23	109.23	100.0
2009-10-19 05:00:00	SPY	ETF	109.25	109.26	109.25	109.26	253.0
2009-10-19 05:30:00	SPY	ETF	109.25	109.3	109.25	109.25	30200.0
2009-10-19 06:00:00	SPY	ETF	109.25	109.25	109.25	109.25	1500.0
2009-10-19 06:30:00	SPY	ETF	109.2	109.27	109.2	109.27	30799.0
2009-10-19 07:00:00	SPY	ETF	109.27	109.37	109.25	109.32	276825.0
2009-10-19 07:30:00	SPY	ETF	109.31	109.33	109.22	109.28	191958.0
2009-10-19 08:00:00	SPY	ETF	109.28	109.43	108.0	109.2	587341.0
2009-10-19 08:30:00	SPY	ETF	109.2	109.27	108.52	109.2	1015713.0
2009-10-19 09:00:00	SPY	ETF	109.2	109.22	109.02	109.05	800148.0
2009-10-19 09:30:00	SPY	ETF	109.07	109.24	108.73	108.8284	15924378.0
2009-10-19 10:00:00	SPY	ETF	108.8299	109.34	108.78	109.31	14641806.0
2009-10-19 10:30:00	SPY	ETF	109.31	109.75	109.31	109.59	15006253.0
2009-10-19 11:00:00	SPY	ETF	109.59	109.88	109.56	109.83	11152335.0
2009-10-19 11:30:00	SPY	ETF	109.82	110.03	109.8	109.97	9143393.0
2009-10-19 12:00:00	SPY	ETF	109.97	109.99	109.86	109.87	5263482.0
2009-10-19 12:30:00	SPY	ETF	109.88	109.96	109.83	109.91	4168620.0
2009-10-19 13:00:00	SPY	ETF	109.9	110.0	109.79	109.88	7569643.0
2009-10-19 13:30:00	SPY	ETF	109.89	110.13	109.86	109.9617	8933850.0
2009-10-19 14:00:00	SPY	ETF	109.97	110.13	109.94	110.0601	6513068.0
2009-10-19 14:30:00	SPY	ETF	110.06	110.11	109.9	110.049	6766949.0
2009-10-19 15:00:00	SPY	ETF	110.05	110.07	109.79	109.83	6905770.0
2009-10-19 15:30:00	SPY	ETF	109.84	110.0	109.78	109.84	17273156.0
2009-10-19 16:00:00	SPY	ETF	109.84	109.9278	108.79	109.62	11799157.0
2009-10-19 16:30:00	SPY	ETF	109.53	110.15	109.45	110.03	4226449.0
2009-10-19 17:00:00	SPY	ETF	110.02	110.1	109.93	109.96	791121.0
2009-10-19 17:30:00	SPY	ETF	109.96	110.08	109.93	110.0	58699.0
2009-10-19 18:00:00	SPY	ETF	109.98	110.03	109.9	109.93	68233.0
2009-10-19 18:30:00	SPY	ETF	109.93	109.98	109.9	109.94	21601.0
2009-10-19 19:00:00	SPY	ETF	109.93	109.98	109.93	109.98	31213.0
2009-10-19 19:30:00	SPY	ETF	109.98	110.06	109.97	110.06	62255.0
2009-10-19 04:00:00	QQQ	ETF	42.89	42.89	42.88	42.88	17578.0
2009-10-19 05:00:00	QQQ	ETF	42.9	42.93	42.9	42.93	504.0
2009-10-19 05:30:00	QQQ	ETF	42.92	42.93	42.91	42.91	3520.0
2009-10-19 06:00:00	QQQ	ETF	42.9	42.94	42.9	42.91	22404.0
2009-10-19 06:30:00	QQQ	ETF	42.93	42.93	42.91	42.91	600.0
2009-10-19 07:00:00	QQQ	ETF	42.9	42.95	42.9	42.94	211400.0
2009-10-19 07:30:00	QQQ	ETF	42.94	42.95	42.91	42.93	87440.0
2009-10-19 08:00:00	QQQ	ETF	42.93	42.93	42.3	42.86	283324.0
2009-10-19 08:30:00	QQQ	ETF	42.86	42.9	42.84	42.86	156487.0
2009-10-19 09:00:00	QQQ	ETF	42.87	42.88	42.8	42.82	315010.0
2009-10-19 09:30:00	QQQ	ETF	42.81	42.9	42.63	42.67	10288015.0
2009-10-19 10:00:00	QQQ	ETF	42.67	42.85	42.59	42.835	9938057.0
2009-10-19 10:30:00	QQQ	ETF	42.83	43.04	42.82	42.98	6821997.0
2009-10-19 11:00:00	QQQ	ETF	42.98	43.09	42.95	43.075	7498252.0
2009-10-19 11:30:00	QQQ	ETF	43.08	43.26	43.03	43.2215	6263699.0
2009-10-19 12:00:00	QQQ	ETF	43.23	43.24	43.15	43.1501	2557016.0
2009-10-19 12:30:00	QQQ	ETF	43.16	43.205	43.14	43.17	1277227.0
2009-10-19 13:00:00	QQQ	ETF	43.17	43.2	43.1	43.15	2737376.0

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

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